Bug 402526

Summary:	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 ...) )
Product:	[Frameworks and Libraries] Akonadi	Reporter:	Dennis Schridde <heri+kde>
Component:	server	Assignee:	kdepim bugs <pim-bugs-null>
Status:	RESOLVED DUPLICATE
Severity:	normal
Priority:	NOR
Version First Reported In:	unspecified
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

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 ***