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
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
|
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
Thursday, 08 July 2021, 22:38 GMT
Reason for closing: Fixed
Additional comments about closing: qt5-base 5.15.2+kde+r207-2
Apparently this breaks Qt's version detection https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/mysql/qsql_mysql.cpp#n1279