[Akonadi] [Bug 402526] New: Akonadi Server 18.08.3: DATABASE ERROR: Error code: "1213", "Deadlock found when trying to get lock; try restarting transaction QMYSQL3: Unable to execute statement", Query: "UPDATE PimItemTable SET atime = ? WHERE ( ( PimItemTable.id = ? OR ...) )

[Dennis Schridde]

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

            Bug ID: 402526
           Summary: Akonadi Server 18.08.3: DATABASE ERROR: Error code:
                    "1213", "Deadlock found when trying to get lock; try
                    restarting transaction QMYSQL3: Unable to execute
                    statement", Query: "UPDATE PimItemTable SET atime = ?
                    WHERE ( ( PimItemTable.id = ? OR ...) )
           Product: Akonadi
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: devurandom at gmx.net
  Target Milestone: ---

SUMMARY
I found the following error in my system log:
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1213"
org.kde.pim.akonadiserver:   DB error:  "Deadlock found when trying to get
lock; try restarting transaction"                                               
org.kde.pim.akonadiserver:   Error text: "Deadlock found when trying to get
lock; try restarting transaction QMYSQL3: Unable to execute statement"          
org.kde.pim.akonadiserver:   Query: "UPDATE PimItemTable SET atime = ? WHERE (
( PimItemTable.id = ? OR PimItemTable.id = ? OR << repeats a few hundred (?)
times >> ) )

STEPS TO REPRODUCE
Unknown

OBSERVED RESULT
Abovementioned error message in the system log

EXPECTED RESULT
No error in the system log

SOFTWARE/OS VERSIONS
Distribution: Fedora 29
Linux: 4.19.10-300.fc29.x86_64
Package Version: kf5-akonadi-server-18.08.3-1.fc29.src.rpm
KDE Applications Version: 18.08.3
KDE Plasma Version: 5.9.3
KDE Frameworks Version: 5.52.0
Qt Version: 5.11.1

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