Page MenuHomePhabricator

Database error: Incorrect key file for table 'objectcache'
Closed, InvalidPublic

Description

Author: tderouin

Description:
Hi,

We are occassionally seeing this error for some special pages such as

Special:Recentchanges Special:Specialpages Special:Randompage:

Database error
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 "1034:

Incorrect key file for table 'objectcache'; try to repair it (localhost)"

This seems to be only reproducable by going to special pages, although I could
be wrong. Why would the code attempt to read something out of the objectcache
for a special page? Hitting refresh resolves the problem and the correct page is
viewable.


Version: 1.4.x
Severity: normal
OS: Windows XP
Platform: PC

Details

Reference
bz3383

Event Timeline

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

tderouin wrote:

Hi,

I just saw this bug again when on a printable version of a normal article page
and returning to the regular article.

Same MySQL error. Hitting refresh loads the page correctly.

The objectcache table is used on many occasions.

Please use MySQL's tools to repair the table. See http://dev.mysql.com/ for
documentation on MySQL.

tderouin wrote:

Thanks, that seems to have worked. I guess "Try to repair it" was a little too
vague for me.