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

[Jürgen Leibner]

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 --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20230224/1799b0e9/attachment.htm>