[Akonadi] [Bug 439769] New: Akonadi fails with Mariadb 10.6.3
bugzilla_noreply at kde.org
bugzilla_noreply at kde.org
Mon Jul 12 05:50:20 BST 2021
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 at kde.org
Reporter: kelly at 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.
More information about the Kdepim-bugs
mailing list