Page MenuHomePhabricator

Major database query error when viewing article
Closed, ResolvedPublic

Description

Author: admin

Description:
When trying to view the page
[http://www.rushyo.com/iptwowiki/index.php/Coldorran_First_Special_Brigade] and
others on the same MediaWiki (http://www.rushyo.com/iptwowiki/IPTwoWiki) I
get an error similar to the following:

'''' 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 "1030:
Got error 134 from table handler (localhost)".''''

The site has been working fine until now and I cannot isolate what has caused
the bug. It only occurs on certain pages and I cannot find any continuity
between them.

Editing the page works entirely, it is merely viewing the article that causes
the error. Other users have encountered the same problem, using the latest IE
and Firefox browsers. The server recently ran an 'infinite loop' script which
slowed the server down tremendously about the same time this happened and may
have contributed to whatever has happened.


Version: 1.4.x
Severity: critical
OS: Windows XP
Platform: PC
URL: http://www.rushyo.com/iptwowiki/index.php/Coldorran_First_Special_Brigade

Details

Reference
bz3168

Event Timeline

bzimport raised the priority of this task from to High.Nov 21 2014, 8:44 PM
bzimport set Reference to bz3168.
bzimport added a subscriber: Unknown Object (MLST).

When you encounter MySQL errors, please remember to look up the error number. This can be done with
the 'perror' command-line utility:

$ perror 134
MySQL error: 134 = Record was already deleted (or record file crashed)

So, you should probably run REPAIR TABLES on your tables.

admin wrote:

ah thank you. I don't have command line access to the server, but running a
horde of REPAIR QUICK statements did fix it.