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 <simonbenchmarkconsulting.com>
> Subject: Re: [Mediawiki-l] MySQL Database Error
> To: MediaWiki announcements and site admin list
> <mediawiki-lWikimedia.org>
> Message-ID:
> <F89BA86F375B2F43B05CB04E01B199BA0D9384castor-
> srvr1.benchmarkcanada.com>
>
> Content-Type: text/plain; charset=us-ascii
>
> Did you run the update.php script?
>
> Simon
>
> -----Original Message-----
> From: mediawiki-l-bouncesWikimedia.org
> [mailto:mediawiki-l-bouncesWikimedia.org] On Behalf Of
Patricia
> Barden
> Sent: 7 novembre, 2006 10:56
> To: mediawiki-lWikimedia.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
> webmasterprwatch.org
Patricia Barden
Webmaster
Center for Media and Democracy
520 University Avenue, Suite 227
Madison, WI 53703
Phone: 608-260-9713
webmasterprwatch.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-lWikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
|