Results 1 to 3 of 3

Thread: KMail/Akonadi service error related to MySQL/MariaDB

  1. #1

    Question KMail/Akonadi service error related to MySQL/MariaDB

    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:
    Code:
    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.

  2. #2
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: KMail/Akonadi service error related to MySQL/MariaDB

    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

    Code:
    systemctl stop mysql.service
    systemctl start mysql.service
    commands in order to continue. However, I have never tried it - so I cannot guarantee it.

  3. #3

    Default Re: KMail/Akonadi service error related to MySQL/MariaDB

    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •