Bug#1031770: kontact: cannot show existing messages and will not retrieve new ones
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
Reply to: