Last modified: 2010-05-15 15:56:49 UTC
I'm running mediawiki 1.68, an i got an error on most pages.
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 "Revision::fetchRow". MySQL returned error "1016: Can't
open file: 'revision.MYI'. (errno: 145) (localhost)".
If i look at the mysql server, it says that table Revision is in use. But there
is nobody which use it right now. Can i unlock this table somehow?
This site runs for a long time without problems. I did not any updates within
the last days, so it should not be related to an update.
It runs on a debian woody with mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu
After some time spending in google, i found a solution.
REPAIR TABLE revision fixed this problem.
But i still don't know the reason.
MySQL problem - not MediaWiki.