https://bugs.kde.org/show_bug.cgi?id=439769
Bug ID: 439769 Summary: Akonadi fails with Mariadb 10.6.3 Product: Akonadi Version: unspecified Platform: Other OS: Linux Status: REPORTED Severity: normal Priority: NOR Component: server Assignee: kdepim-bugs@kde.org Reporter: ke...@xilka.com Target Milestone: --- SUMMARY Akonadi fails to run with Mariadb 10.6.3. To me it looks like the QDateTime string format with the "T" and maybe the "Z" is invalid with Mariadb 10.6+. STEPS TO REPRODUCE 1. Install Mariadb 10.6.3 2. delete ~/.local/share/akonadi 3. reboot machine 4. start kmail OBSERVED RESULT Errors in ~/.local/share/akonadi/Akonadi.error 2021-07-11T22:04:16 [CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR: 2021-07-11T22:04:16 [CRITICAL] org.kde.pim.akonadiserver: Error code: "1292" 2021-07-11T22:04:16 [CRITICAL] org.kde.pim.akonadiserver: DB error: "Incorrect datetime value: '2021-07-12T04:04:16Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1" 2021-07-11T22:04:16 [CRITICAL] org.kde.pim.akonadiserver: Error text: "Incorrect datetime value: '2021-07-12T04:04:16Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query" 2021-07-11T22:04:16 [CRITICAL] org.kde.pim.akonadiserver: Values: QMap((":0", QVariant(int, 0))(":1", QVariant(QString, "152288"))(":2", QVariant(QString, ""))(":3", QVariant(QString, ""))(":4", QVariant(qlonglong, 21))(":5", QVariant(qlonglong, 4))(":6", QVariant(QDateTime, QDateTime(2021-07-12 04:04:16.872 UTC Qt::UTC)))(":7", QVariant(QDateTime, QDateTime(2021-07-12 04:04:16.871 UTC Qt::UTC)))(":8", QVariant(bool, false))(":9", QVariant(qlonglong, 13241))) 2021-07-11T22:04:16 [CRITICAL] 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)" 2021-07-11T22:04:16 [WARN ] org.kde.pim.akonadiserver: Error during insertion into table "PimItemTable" "Incorrect datetime value: '2021-07-12T04:04:16Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query" 2021-07-11T22:04:16 [WARN ] org.kde.pim.akonadiserver: Error while handling command CreateItem on connection akonadi_imap_resource_0 (0xdd91b0) EXPECTED RESULT Kmail should start and run properly. SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: Kernel 5.12.16 (available in About System) KDE Plasma Version: 5.22.3 KDE Frameworks Version: 5.84 Qt Version: 5.15.3 (from kde source tree) ADDITIONAL INFORMATION -- You are receiving this mail because: You are the assignee for the bug.