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.
Russ Lavoy wrote:
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.
Which MediaWiki version? This was supposed to be fixed on 1.13.1 (update to 1.13.2). Although to never get those deadlocks, you should use memcached.
I have seen 2 of these errors occur in 1.13.2, over the past few weeks.
DanB
..."SiteStatsUpdate::doUpdate". MySQL returned error "1213: Deadlock found when trying to get lock; try restarting transaction
Which MediaWiki version? This was supposed to be fixed on 1.13.1 (update to 1.13.2). Although to never get those deadlocks, you should use memcached.
<snip> Although to never get those deadlocks, you should use memcached. </snip>
I do use memcached and I am running 1.12.0 and cannot upgrade to 1.13.2 because of performance issues regarding caching that I am having a hard time figuring out.
Thanks
--- On Fri, 11/7/08, Platonides Platonides@gmail.com wrote:
From: Platonides Platonides@gmail.com Subject: Re: [Mediawiki-l] Database Deadlock Issue To: mediawiki-l@lists.wikimedia.org Date: Friday, November 7, 2008, 3:40 AM Russ Lavoy wrote:
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.
Which MediaWiki version? This was supposed to be fixed on 1.13.1 (update to 1.13.2). Although to never get those deadlocks, you should use memcached.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org