[Mediawiki-l] MediaWiki-l Digest, Vol 38, Issue 12

[Simon Renshaw]

Sorry, my experience with the app is somewhat limited.

I do run it on MySQL 5 and I have no problems.

Simon

-----Original Message-----
From: mediawiki-l-bounces at Wikimedia.org
[mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Patricia Barden
Sent: 9 novembre, 2006 13:49
To: mediawiki-l at Wikimedia.org
Subject: Re: [Mediawiki-l] MediaWiki-l Digest, Vol 38, Issue 12

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 at Wikimedia.org wrote:

> Message: 4
> Date: Tue, 07 Nov 2006 11:03:23 -0500
> From: Simon Renshaw <simon at benchmarkconsulting.com>
> Subject: Re: [Mediawiki-l] MySQL Database Error
> To: MediaWiki announcements and site admin list
> 	<mediawiki-l at Wikimedia.org>
> Message-ID:
> 	<F89BA86F375B2F43B05CB04E01B199BA0D9384 at 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 at Wikimedia.org
> [mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Patricia  
> Barden
> Sent: 7 novembre, 2006 10:56
> To: mediawiki-l at 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 at prwatch.org

Patricia Barden
Webmaster
Center for Media and Democracy
520 University Avenue, Suite 227
Madison, WI 53703
Phone: 608-260-9713
webmaster at 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



_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l