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 ?)

Linux Kernel, Network, and Services configuration.
Post Reply
Message
Author
TonyB
Posts: 3
Joined: 2023-05-13 14:34

[Software] KMail crashes at startup (akonadi issue ?)

#1 Post by TonyB »

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.

Aki
Global Moderator
Global Moderator
Posts: 2816
Joined: 2014-07-20 18:12
Location: Europe
Has thanked: 68 times
Been thanked: 382 times

Re: [Software] KMail crashes at startup (akonadi issue ?)

#2 Post by Aki »

Hello,
What's your Debian version ?
What are the versions of involved programs ?
Have you installed packages/programs from outside Debian repositories ?
⢀⣴⠾⠻⢶⣦⠀
⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
⠈⠳⣄⠀

TonyB
Posts: 3
Joined: 2023-05-13 14:34

Re: [Software] KMail crashes at startup (akonadi issue ?)

#3 Post by TonyB »

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

Aki
Global Moderator
Global Moderator
Posts: 2816
Joined: 2014-07-20 18:12
Location: Europe
Has thanked: 68 times
Been thanked: 382 times

Re: [Software] KMail crashes at startup (akonadi issue ?)

#4 Post by Aki »

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.
⢀⣴⠾⠻⢶⣦⠀
⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
⠈⠳⣄⠀

TonyB
Posts: 3
Joined: 2023-05-13 14:34

Re: [Software] KMail crashes at startup (akonadi issue ?)

#5 Post by TonyB »

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

Aki
Global Moderator
Global Moderator
Posts: 2816
Joined: 2014-07-20 18:12
Location: Europe
Has thanked: 68 times
Been thanked: 382 times

Re: [Software] KMail crashes at startup (akonadi issue ?)

#6 Post by Aki »

Hello,
I'm happy I helped you to sort it out.
Happy Debian !
⢀⣴⠾⠻⢶⣦⠀
⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
⠈⠳⣄⠀

Post Reply