Hi all,
I got into nasty issue with KDE/KMail/Akonadi service. Occasionally after resuming my laptop from sleep I am facing issue with not being able send/receive email. Solution is to either restart laptop (shivers) or restart Akonadi server.
In logs I find these entries:
130908 14:49:51 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
130908 14:49:51 [ERROR] mysqld: Deadlock found when trying to get lock; try restarting transaction
Any clues as to approach this? Not knowing that emails are not arriving due to silent failure of server is slightly disturbing.
Cheers and thanks for help.
My guess is that this is related to sleep, that is, when mysqld is interrupted, it locks things to prevent harm to the database and needs to receive a RELEASE_LOCK instruction in order to proceed. You may only need to issue
systemctl stop mysql.service
systemctl start mysql.service
commands in order to continue. However, I have never tried it - so I cannot guarantee it.
It is fairly easy to fix, just restart akonadi server. However, as i said, more troubling is that there is not indication of this issue other than looking at akonadi logs.
Imagine yourself working and not being notified about critical emails. No fun.
Suggestion: A KDE Notification when Akonadi encounters error in log would be sufficient hint that things went wrong.