[Mediawiki-l] Database Deadlock Issue

Russ Lavoy ussray_00 at yahoo.com
Thu Nov 6 20:04:02 UTC 2008


I am getting the following deadlock issue and it comes back minutes and sometimes hours later...

<snip>
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: 

from within function "SiteStatsUpdate::doUpdate". MySQL returned error "1213: Deadlock found when trying to get lock; try restarting transaction
</snip>


So it seems that multiple processes are trying to edit the same table at the same time which is causing this issue...

How can this be prevented?

Thanks for the help.





      



More information about the MediaWiki-l mailing list