Package: kontact Version: 4:18.08.3-1 Severity: important Dear Maintainer,
Today I found that Kontact would not load and show messages that already reside in my mailboxes, and it refuses to download new ones. In the status bar, messages like the following are shown: Unable to fetch item from backend (collection -1) Unable to retrieve item from resource Opening akonadiconsole and its browser functionality does show messages in the list for each mailbox, and it also manages to show each message payload. However, the following error messages are generated in the terminal window: org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1292" org.kde.pim.akonadiserver: DB error: "Incorrect datetime value: '2023-02-22T12:00:36Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1" org.kde.pim.akonadiserver: Error text: "Incorrect datetime value: '2023-02-22T12:00:36Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query" 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: '2023-02-22T12:00:36Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1292" org.kde.pim.akonadiserver: DB error: "Incorrect datetime value: '2023-02-22T12:08:21Z' for column `akonadi`.`pimitemtable`.`atime` at row 1" org.kde.pim.akonadiserver: Error text: "Incorrect datetime value: '2023-02-22T12:08:21Z' for column `akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: Query: "UPDATE PimItemTable SET atime = :0 WHERE ( PimItemTable.collectionId = :1 )" org.kde.pim.akonadiserver: Unable to update item access time It turns out that this is caused by a bug that was reported back in 2021: "Kmail fails to display message, akonadiserver errors" https://forums.opensuse.org/t/kmail-fails-to-display-message-akonadiserver-errors/147051 "Bug 1189184 - org.kde.pim.akonadiserver: Error code: "1292"" https://bugzilla.opensuse.org/show_bug.cgi?id=1189184 "Akonadi fails with Mariadb 10.6.3" https://bugs.kde.org/show_bug.cgi?id=439769 "mysql client version detection broken with MariaDB 10.6" https://bugreports.qt.io/browse/QTBUG-95071 I imagine that a fix for this bug needs to be introduced to the packaged Qt 5 SQL library from whichever version was fixed. It looks like the libqt5sql5-mysql:amd64 package on my system is based on 5.11: 5.11.3+dfsg1-1+deb10u5 But upstream fixes only covered 5.15 and 6.2 branches. I see that the following package was upgraded on my system recently: libmariadb3_1%3a10.3.38-0+deb10u1_amd64.deb The libmariadb3 package has the following version: 1:10.3.38-0+deb10u1 So, this may have caused this bug to appear on my system. If anyone really thought that they absolutely had to incorporate a full relational database server into their desktop application, then at the very least they should have used PostgreSQL and saved everyone the bother of dealing with the circus that is MySQL. I will spare everyone the usual rant about Akonadi, noting only that "akonadictl restart" is a regular command invocation in my workflow. Thanks in advance for any consideration of this issue, Paul -- System Information: Debian Release: 10.13 APT prefers oldstable-updates APT policy: (500, 'oldstable-updates'), (500, 'oldstable') Architecture: amd64 (x86_64) Kernel: Linux 5.5.0-0.bpo.2-amd64 (SMP w/8 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en (charmap=UTF-8) Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages kontact depends on: ii kdepim-runtime 4:18.08.3-4 ii kio 5.54.1-1 ii libc6 2.28-10+deb10u2 ii libgcc1 1:8.3.0-6 ii libkf5completion5 5.54.0-1 ii libkf5configcore5 5.54.0-1+deb10u1 ii libkf5configgui5 5.54.0-1+deb10u1 ii libkf5configwidgets5 5.54.0-1 ii libkf5coreaddons5 5.54.0-1 ii libkf5crash5 5.54.0-1 ii libkf5grantleetheme-plugins 18.08.3-1 ii libkf5grantleetheme5 18.08.3-1 ii libkf5i18n5 5.54.0-1 ii libkf5iconthemes5 5.54.0-1 ii libkf5kcmutils5 5.54.0-1 ii libkf5kdepimdbusinterfaces5 4:18.08.3-2 ii libkf5kiowidgets5 5.54.1-1 ii libkf5kontactinterface5 18.08.3-1 ii libkf5libkdepim-plugins 4:18.08.3-2 ii libkf5libkdepim5 4:18.08.3-2 ii libkf5parts5 5.54.0-1 ii libkf5service-bin 5.54.0-1 ii libkf5service5 5.54.0-1 ii libkf5widgetsaddons5 5.54.0-1 ii libkf5windowsystem5 5.54.0-1 ii libkf5xmlgui5 5.54.0-1 ii libqt5core5a 5.11.3+dfsg1-1+deb10u5 ii libqt5dbus5 5.11.3+dfsg1-1+deb10u5 ii libqt5gui5 5.11.3+dfsg1-1+deb10u5 ii libqt5webengine5 5.11.3+dfsg-2+deb10u1 ii libqt5webenginewidgets5 5.11.3+dfsg-2+deb10u1 ii libqt5widgets5 5.11.3+dfsg1-1+deb10u5 ii libstdc++6 8.3.0-6 Versions of packages kontact recommends: ii accountwizard 4:18.08.3-1 ii akregator 4:18.08.3-2 ii kaddressbook 4:18.08.3-3 ii kmail 4:18.08.3-1 ii knotes 4:18.08.3-1 ii korganizer 4:18.08.3-1 Versions of packages kontact suggests: pn gnokii <none> -- no debconf information