Page MenuHomePhabricator

Database error - Can't open file: 'objectcache.MYI'
Closed, InvalidPublic


I'm getting this error on my site, and i'm not sure why. I haven't made any
hardware/software changes, nor have i updated my sql database lately. This
started happening sometime during the night, and I'm not sure what is causing
this error:

Database error
From This Might Be A Wiki
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 "1016:
Can't open file: 'objectcache.MYI' (errno: 145) (localhost)".

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



Event Timeline

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

issue 'REPAIR TABLE objectcache', it is a trouble with your server.

After looking at it further, is it possible that the objectcache table in mysql
got corrupted and needs to be rebuilt???

Ah, you beat me to it. Thanks for the quick response. Also, yes, i meant
"repair", not "rebuild"...thanks.