[Mediawiki-l] Database Deadlock Issue

[Russ Lavoy]

<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 at gmail.com> wrote:

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