FS#71471 - [mariadb] 10.6 breaks akonadi

Attached to Project: Arch Linux
Opened by Antonio Rojas (arojas) - Thursday, 08 July 2021, 17:32 GMT
Last edited by Antonio Rojas (arojas) - Thursday, 08 July 2021, 22:38 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Antonio Rojas (arojas)
Christian Hesse (eworm)
Felix Yan (felixonmars)
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
After updating mariadb to 1.6, akonadi can no longer retrieve emails. The logs show an endless string of errors:

org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver: Error code: "1292"
org.kde.pim.akonadiserver: DB error: "Incorrect datetime value: '2021-07-08T17:23:13Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1"
org.kde.pim.akonadiserver: Error text: "Incorrect datetime value: '2021-07-08T17:23:13Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: No es posible ejecutar la consulta"
org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(int, 0))(":1", QVariant(QString, "moonphase+1578026700000"))(":2", QVariant(QString, "\"2453932800000000\""))(":3", QVariant(QString, ""))(":4", QVariant(qlonglong, 35))(":5", QVariant(qlonglong, 2))(":6", QVariant(QDateTime, QDateTime(2021-07-08 17:23:13.906 UTC Qt::UTC)))(":7", QVariant(QDateTime, QDateTime(2021-07-08 17:23:13.906 UTC Qt::UTC)))(":8", QVariant(bool, false))(":9", QVariant(qlonglong, 0)))
org.kde.pim.akonadiserver: Query: "INSERT INTO PimItemTable (rev, remoteId, remoteRevision, gid, collectionId, mimeTypeId, datetime, atime, dirty, size) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9)"
org.kde.pim.akonadiserver: Error during insertion into table "PimItemTable" "Incorrect datetime value: '2021-07-08T17:23:13Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: No es posible ejecutar la consulta"
org.kde.pim.akonadiserver: Error while handling command CreateItem on connection akonadi_google_resource_1 (0x55a078c78440)
org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Failed to append item"
org.kde.pim.akonadicore: Error during ItemSync: "Failed to append item"

Wiping the database doesn't help, so it's not an upgrade issue.
This task depends upon

Closed by  Antonio Rojas (arojas)
Thursday, 08 July 2021, 22:38 GMT
Reason for closing:  Fixed
Additional comments about closing:  qt5-base 5.15.2+kde+r207-2

Loading...