<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(a)gmail.com> wrote:
From: Platonides <Platonides(a)gmail.com>
Subject: Re: [Mediawiki-l] Database Deadlock Issue
To: mediawiki-l(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l