Hello,
since a few weeks, I have trouble to download mails with KMail.
KMail crashes immediately after start. In the akonadi log files, I can see following entries :
[1986-07-06T18:18:26.000] akonadiserver org.kde.pim.akonadiserver DATABASE ERROR:
[1986-07-06T18:18:26.000] akonadiserver org.kde.pim.akonadiserver Error code: "1292"
[1986-07-06T18:18:26.000] akonadiserver org.kde.pim.akonadiserver DB error: "Incorrect datetime value: '2023-05-15T10:57:10Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1"
[1986-07-06T18:18:26.000] akonadiserver org.kde.pim.akonadiserver Error text: "Incorrect datetime value: '2023-05-15T10:57:10Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query"
[1986-07-06T18:18:27.000] akonadiserver org.kde.pim.akonadiserver Query: "INSERT INTO PimItemTable (rev, remoteRevision, gid, collectionId, mimeTypeId, datetime, atime, dirty, size) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8)"
[1986-07-06T18:18:27.000] akonadiserver org.kde.pim.akonadiserver Error during insertion into table "PimItemTable" "Incorrect datetime value: '2023-05-15T10:57:10Z' for column `akonadi`.`pimitemtable`.`datetime` at row 1 QMYSQL: Unable to execute query"
[1986-07-06T18:18:27.000] akonadi_pop3_resource org.kde.pim.pop3resource ============== ERROR DURING POP3 SYNC ==========================
The first strange thing here is timestamp in the first column [in brackets]. In the akondi console, it is correctly displayed (as "2023-05-15T12:57:10.738").
Obviously, the timestamp of the query to insert values into the MySQL DB is wrong (here "2023-05-15T10:57:10Z"). The "Z" represents the time zone. MySQL seems not to like timestamps with time zone.
The queries are not written or modified by myself. They all originate from akonadi/KMail.
Where do I need to change the settings to remove the timezone from the time stamp ?
I didn't changed anything on my system. It happened suddenly after one of the updates.
I'm happy about any hints/support.
Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230
[Software] KMail crashes at startup (akonadi issue ?)
-
- Global Moderator
- Posts: 2823
- Joined: 2014-07-20 18:12
- Location: Europe
- Has thanked: 69 times
- Been thanked: 385 times
Re: [Software] KMail crashes at startup (akonadi issue ?)
Hello,
What's your Debian version ?
What are the versions of involved programs ?
Have you installed packages/programs from outside Debian repositories ?
What's your Debian version ?
What are the versions of involved programs ?
Have you installed packages/programs from outside Debian repositories ?
Re: [Software] KMail crashes at startup (akonadi issue ?)
Hello Aki,
sorry for having forgotten so important information
The installed versions are :
- Debian : 10.13 (Buster)
- KMail : 5.9.3
- Akonadi (server) : 5.9.3
- MySQL : Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Yes, I'm also using packages from outside of Debian, like the brave browser and some others.
I don't think the issues are related to those packages. The system is working very stable since many years (I'm using only stable package versions).
The whole story started somewhere beginning of April, right after one of the updates. I can't remember which packages were updated, but I'm pretty sure, not KMail and not akonadi.
Regards,
Tony
sorry for having forgotten so important information
The installed versions are :
- Debian : 10.13 (Buster)
- KMail : 5.9.3
- Akonadi (server) : 5.9.3
- MySQL : Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Yes, I'm also using packages from outside of Debian, like the brave browser and some others.
I don't think the issues are related to those packages. The system is working very stable since many years (I'm using only stable package versions).
The whole story started somewhere beginning of April, right after one of the updates. I can't remember which packages were updated, but I'm pretty sure, not KMail and not akonadi.
Regards,
Tony
-
- Global Moderator
- Posts: 2823
- Joined: 2014-07-20 18:12
- Location: Europe
- Has thanked: 69 times
- Been thanked: 385 times
Re: [Software] KMail crashes at startup (akonadi issue ?)
Hello,
It seem a Debian Buster specific bug.
I suppose that is caused by this bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031773 and https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031863
This is a patch, but it is still in process of being merged: https://salsa.debian.org/mariadb-team/m ... est_iid=36
You can try to rebuild the affected package applying the patch by yourself.
It seem a Debian Buster specific bug.
I suppose that is caused by this bug: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031773 and https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1031863
This is a patch, but it is still in process of being merged: https://salsa.debian.org/mariadb-team/m ... est_iid=36
You can try to rebuild the affected package applying the patch by yourself.
Re: [Software] KMail crashes at startup (akonadi issue ?)
Hello Aki,
after studying the bugs you shared, I could successfully downgrade the DB from Ver. 10.3.38 to 10.3.37.
This solved the issue ! KMail works again.
Thanks a lot for your valuable support !
According to the bugs, it looks like the issue persists since several versions but now it was effective And obviously, there's no remediation available.
Kind regards,
Tony
after studying the bugs you shared, I could successfully downgrade the DB from Ver. 10.3.38 to 10.3.37.
This solved the issue ! KMail works again.
Thanks a lot for your valuable support !
According to the bugs, it looks like the issue persists since several versions but now it was effective And obviously, there's no remediation available.
Kind regards,
Tony
-
- Global Moderator
- Posts: 2823
- Joined: 2014-07-20 18:12
- Location: Europe
- Has thanked: 69 times
- Been thanked: 385 times
Re: [Software] KMail crashes at startup (akonadi issue ?)
Hello,
I'm happy I helped you to sort it out.
Happy Debian !
I'm happy I helped you to sort it out.
Happy Debian !