Hello,
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.
Only mysqld resrart everything returns to normal.
I would like to know if there is a way of preventing this from happening.
Using MediaWiki 1.6.12
Thanks, Addady
Hi!
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 from.
mediawiki-l@lists.wikimedia.org