Hello:

I apologize if I replied twice to this response, but I left out the previous messages in my last reply so I'm guessing that no one knew what I was talking about.

Anyway, we did run update.php. The entire upgrade was done from the command line and appeared to have completed without a hitch.

Interestingly, we did the upgrade about 3 weeks ago and the error message did not start showing up until about 4 days ago. Our remote host says that it's because of increased traffic to the site but I am not totally convinced of this explanation. I just want to make sure that something else is not going on (if that's possible).

We are currently running MediaWiki v 1.8.2, php 5.1.1 and mysql 4.1.15. Should we upgrade to the latest version of mysql? I'm just not sure where the source of the problem is or even where to start looking.

Again, here is the error message we are getting:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "1213: Deadlock found when trying to get lock; try restarting transaction (localhost)".

I'm pretty concerned because our site has been down quite a lot over the past few days.

Thanks for any help or suggestions you can offer.

~Tricia

On Nov 7, 2006, at 12:43 PM, mediawiki-l-request@Wikimedia.org wrote:

Message: 4 Date: Tue, 07 Nov 2006 11:03:23 -0500 From: Simon Renshaw simon@benchmarkconsulting.com Subject: Re: [Mediawiki-l] MySQL Database Error To: MediaWiki announcements and site admin list mediawiki-l@Wikimedia.org Message-ID: <F89BA86F375B2F43B05CB04E01B199BA0D9384@castor- srvr1.benchmarkcanada.com>

Content-Type: text/plain; charset=us-ascii

Did you run the update.php script?

Simon

-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Patricia Barden Sent: 7 novembre, 2006 10:56 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] MySQL Database Error

Hello all:

We just recently upgraded to MediaWiki 1.8.2. We are running PHP - 5.1.1 and MySQL - 4.1.15.

MySQL generated the following error message yesterday:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "MediaWikiBagOStuff::_doquery". MySQL returned error "1213: Deadlock found when trying to get lock; try restarting transaction (localhost)".

Any ideas about what might be causing this error?

Thank you,

Tricia Barden webmaster@prwatch.org

Patricia Barden Webmaster Center for Media and Democracy 520 University Avenue, Suite 227 Madison, WI 53703 Phone: 608-260-9713 webmaster@prwatch.org www.prwatch.org

Subscribe to our free weekly listserve by visiting: http://www.prwatch.org/cmd/subscribe_sotd.html

Donate now to support independent, public interest reporting: https://secure.groundspring.org/dn/index.php?id=1118

Collaborate with our public interest investigations: http://www.sourcewatch.org