[Akonadi] [Bug 439769] New: Akonadi fails with Mariadb 10.6.3

[bugzilla_noreply at kde.org]

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.