Last modified: 2014-06-30 13:34:41 UTC
See https://www.wikidata.org/wiki/Wikidata:Contact_the_development_team/Archive/2013/10#Database_error_when_deleting_items_too_fast When I'm deleting items on Wikidata too fast (many items within short timeframe), I get a database error. I'm using a "flooder" user group. A database query error has occurred. This may indicate a bug in the software. Function: RecentChange::save Error: 1213 Deadlock found when trying to get lock; try restarting transaction (10.64.32.28) See especially the last comment by Adam Shorland (WMDE).
RecentChanges::save is also called for flooders, because also actions by flooders are in the recent changes, there are only marked as bot and therefor needs change of the filter to show bot edits. Same for watchlist.
Today I got the same error message on the Finnish Wikipedia, so it's not related to Wikidata nor flooders user group.
I see this on Commons, likely due to FileDeleteForm calling doDeleteArticleReal(), telling it to keep the transaction open and then deleting the file (slow) and committing afterwards.
Change 138677 had a related patch set uploaded by Aaron Schulz: Reduce deadlocks adding log rows to the RC table on delete https://gerrit.wikimedia.org/r/138677
Change 138677 merged by jenkins-bot: Reduce deadlocks adding log rows to the RC table on delete https://gerrit.wikimedia.org/r/138677
