[Mediawiki-l] Hang on mysql deadlock

Domas Mituzas midom.lists at gmail.com
Tue Jan 22 10:21:03 UTC 2008


> Sometimes after edit of long page I am getting the following error:
> "Lock wait timeout exceeded; try restarting transaction"
> and I can't use the wiki any more.

Thats not a deadlock! Thats lock wait timeout.

It happens when other connection acquires a lock, and doesn't  
release. Use 'SHOW PROCESSLIST' and see if you have any long-running  
or stale connections, then you can try figuring out where they come  

Domas Mituzas -- http://dammit.lt/ -- [[user:midom]]

More information about the MediaWiki-l mailing list