[debian-mysql] Bug#1031860: kmail with akonadi stops working after security-upgrade of '*mariadb*'

[Markus Hochholdinger]

Hi,

I encountered the same issue and found the culprit:
https://bugs.archlinux.org/task/71471
https://github.com/mariadb-corporation/mariadb-connector-c/commit/
a37b7c3965706f9a062baaba0c494dd6efb2c306
https://code.qt.io/cgit/qt/qtbase.git/tree/src/plugins/sqldrivers/mysql/
qsql_mysql.cpp#n1279

I created the attached patch mariadb_lib.c.patch with the information from the 
above link and rebuilded:
 apt-get source mariadb-10.3
 apt-get build-dep mariadb-10.3
 cd mariadb-10.3-10.3.38
 patch libmariadb/libmariadb/mariadb_lib.c < /tmp/mariadb_lib.c.patch
 debian/rules binary

After installing the resulting packages
 mariadb-common_10.3.38-0+deb10u2_all.deb
 mariadb-server-core-10.3_10.3.38-0+deb10u2_amd64.deb
 mariadb-client-core-10.3_10.3.38-0+deb10u2_amd64.deb
 libmariadb3_10.3.38-0+deb10u2_amd64.deb
kmail/qt/akonadi was working for me again. Please ensure you stopped akonadi 
after updating these packaes, e.g. with
 akondaictl stop
Otherwise the updated packages/binaries wouldn't be used.

Background from the above links:
Instead of server version the api functions mysql_get_client_info and
mysql_get_client_version should return MARIADB_PACKAGE_VERSION/ID.
Apparently this breaks Qt's version detection.


Hope this helps, cheers,

Markus


On Fri, 24 Feb 2023 13:07:41 +0100 =?ISO-8859-1?Q?J=FCrgen?= Leibner 
<2010jl at gmx.de> wrote:
> Package:		mariadb-server-core-10.3
> Version:	1:10.3.38-0+deb10u1
> 
> libmariadb3/oldstable 1:10.3.38-0+deb10u1 amd64 [aktualisierbar von: 
1:10.3.36-0+deb10u2] 
> mariadb-client-core-10.3/oldstable 1:10.3.38-0+deb10u1 amd64 [aktualisierbar 
von: 1:10.3.36-0+deb10u2] 
> mariadb-common/oldstable 1:10.3.38-0+deb10u1 all [aktualisierbar von: 
1:10.3.36-0+deb10u2] 
> mariadb-server-core-10.3/oldstable 1:10.3.38-0+deb10u1 amd64 [aktualisierbar 
von: 1:10.3.36-0+deb10u2]
> 
> When I upgrade the above listed packages, kmail doesn't work anymore due to 
the following akonadi failures and kmail gets unusable.
> I expected, that a security upgrade doesn't break any working application or 
environment.
> 
> org.kde.pim.akonadicore: Creating/updating items from the akonadi database 
failed: ""
> org.kde.pim.akonadicore: Creating/updating items from the akonadi database 
failed: "Failed to store merged item"
> org.kde.pim.akonadicore: Error during ItemSync:  "Failed to store merged 
item"
> org.kde.pim.imapresource: Detected inconsistency in local cache, we're 
missing some messages. Server:  57  Local:  56
> org.kde.pim.imapresource: Refetching complete mailbox.
> org.kde.pim.akonadiserver: Payload file  "/home/jever/.local/share/akonadi/
file_db_data/01/685201_r0"  could not be open for reading!
> org.kde.pim.akonadiserver: Error:  "No such file or directory"
> org.kde.pim.akonadiserver: DATABASE ERROR:
> org.kde.pim.akonadiserver:   Error code: "1292"
> org.kde.pim.akonadiserver:   DB error:  "Incorrect datetime value: 
'2023-02-23T12:59:27Z' for column `akonadi`.`pimitemtable`.`atime` at row 1"
> org.kde.pim.akonadiserver:   Error text: "Incorrect datetime value: 
'2023-02-23T12:59:27Z' for column `akonadi`.`pimitemtable`.`atime` at row 1 
QMYSQL: Die Abfrage konnte nicht ausgeführt werden"
> org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET rev = :0, 
remoteId = :1, remoteRevision = :2, gid = :3, collectionId = :4, mimeTypeId = 
:5, datetime = :6, atime = :7, dirty = :8, size = :9 WHERE ( id = :10 )"
> org.kde.pim.akonadiserver: Error during updating record with id 342547  in 
table "PimItemTable" "Incorrect datetime value: '2023-02-23T12:59:27Z' for 
column `akonadi`.`pimitemtable`.`atime` at row 1 QMYSQL: Die Abfrage konnte 
nicht ausgeführt werden"
> 
> org.kde.pim.akonadicore: Creating/updating items from the akonadi database 
failed: ""
> org.kde.pim.akonadicore: ""
> org.kde.pim.akonadicore: Creating/updating items from the akonadi database 
failed: "Failed to store merged item"
> org.kde.pim.akonadicore: Error during ItemSync:  "Failed to store merged 
item"
> org.kde.pim.akonadiserver: DATABASE ERROR:
> org.kde.pim.akonadiserver:   Error code: "1292"
> org.kde.pim.akonadiserver:   DB error:  "Incorrect datetime value: 
'2023-02-23T13:13:54Z' for column `akonadi`.`pimitemtable`.`atime` at row 1"
> org.kde.pim.akonadiserver:   Error text: "Incorrect datetime value: 
'2023-02-23T13:13:54Z' for column `akonadi`.`pimitemtable`.`atime` at row 1 
QMYSQL: Die Abfrage konnte nicht ausgeführt werden"
> org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = :0 
WHERE ( ( PimItemTable.id = :1 ) )"
> org.kde.pim.akonadiserver: Unable to update item access time
> org.kde.pim.akonadiserver: DATABASE ERROR:
> org.kde.pim.akonadiserver:   Error code: "1292"
> org.kde.pim.akonadiserver:   DB error:  "Incorrect datetime value: 
'2023-02-23T13:13:54Z' for column `akonadi`.`pimitemtable`.`atime` at row 1"
> org.kde.pim.akonadiserver:   Error text: "Incorrect datetime value: 
'2023-02-23T13:13:54Z' for column `akonadi`.`pimitemtable`.`atime` at row 1 
QMYSQL: Die Abfrage konnte nicht ausgeführt werden"
> org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = :0 
WHERE ( ( PimItemTable.id = :1 ) )"
> org.kde.pim.akonadiserver: Unable to update item access time
> 
> Greetings
> Jürgen Leibner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mariadb_lib.c.patch
Type: text/x-patch
Size: 640 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20230226/abe48f1c/attachment-0001.bin>