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
<201...@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
--- mariadb-10.3-10.3.38.a/libmariadb/libmariadb/mariadb_lib.c 2023-01-28 14:25:28.000000000 +0100
+++ mariadb-10.3-10.3.38.b/libmariadb/libmariadb/mariadb_lib.c 2023-02-24 17:09:51.586122627 +0100
@@ -2866,7 +2866,7 @@
const char * STDCALL
mysql_get_client_info(void)
{
- return (char*) MARIADB_PACKAGE_VERSION;
+ return (char*) MARIADB_CLIENT_VERSION_STR;
}
static size_t get_store_length(size_t length)
@@ -3881,7 +3881,7 @@
ulong STDCALL mysql_get_client_version(void)
{
- return MARIADB_PACKAGE_VERSION_ID;
+ return MARIADB_VERSION_ID;
}
ulong STDCALL mysql_hex_string(char *to, const char *from, unsigned long len)
