Bug 402526 - 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 PimItemTable.id = ? OR ...) )
Summary: DATABASE ERROR: Error code: "1213", "Deadlock found when trying to get lock; ...
Status: RESOLVED DUPLICATE of bug 399167
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: unspecified
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-24 11:33 UTC by Dennis Schridde
Modified: 2019-03-11 13:47 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Schridde 2018-12-24 11:33:15 UTC 
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
Comment 1 Kevin Funk 2019-03-11 13:47:26 UTC 

*** This bug has been marked as a duplicate of bug 399167 ***