[Akonadi] [Bug 399167] New: Akonadi enters deadlock state which makes it completely unuseable

[Andreas Schneider]

https://bugs.kde.org/show_bug.cgi?id=399167

            Bug ID: 399167
           Summary: Akonadi enters deadlock state which makes it
                    completely unuseable
           Product: Akonadi
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: IMAP resource
          Assignee: kdepim-bugs at kde.org
          Reporter: asn at cryptomilk.org
  Target Milestone: ---

SUMMARY

Every few weeks, akonadi runs into a deadlock state, the console output is:


org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Multiple merge candidates, aborting"
org.kde.pim.akonadicore: Error during ItemSync:  "Multiple merge candidates,
aborting"


It doesn't tell me in which mail account nor folder this is happening. To get
my mails back into a working state, I have to completely remove the database
any synchronize all my mails.


Sometimes after some time I see:

org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1205"
org.kde.pim.akonadiserver:   Error code: "1205"
org.kde.pim.akonadiserver:   DB error:  "Lock wait timeout exceeded; try
restarting transaction"
org.kde.pim.akonadiserver:   DB error:  "Lock wait timeout exceeded; try
restarting transaction"
org.kde.pim.akonadiserver:   Error text: "Lock wait timeout exceeded; try
restarting transaction QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Error text: "Lock wait timeout exceeded; try
restarting transaction QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = ? WHERE (
( PimItemTable.id = ? ) )"
org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = ? WHERE (
( PimItemTable.id = ? ) )"


There is no way to solve this without deep akonadi knowledge.


rpm -q akonadi-server
akonadi-server-18.08.1-1.1.x86_64

-- 
You are receiving this mail because:
You are the assignee for the bug.