Revision Table is in use
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Oct 20 2006, 6:41 AM

Description

Author: suntsu

Description:
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
(i386)

Version: 1.6.x
Severity: normal
OS: Linux
Platform: PC

• bzimport raised the priority of this task from to High.Nov 21 2014, 9:24 PM

• bzimport set Reference to bz7640.

• bzimport added a subscriber: Unknown Object (MLST).

suntsu wrote:

After some time spending in google, i found a solution.
http://wiki.cotch.net/index.php/EvoWiki:Bug_reports

REPAIR TABLE revision fixed this problem.
But i still don't know the reason.

cheers

jimmy.collins wrote:

MySQL problem - not MediaWiki.