mediaWiki_searchindex is marked as crashed and should be repaired
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Dec 9 2006, 11:29 AM

Description

Author: hwasungmars

Description:
When I try to change a contents in a page the following error occurs:

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 "SearchMySQL4::update". MySQL returned error "145:

Table './hwasungmars_mw/mediaWiki_searchindex' is marked as crashed and should be repaired (localhost)".

I tried the mysql check table command with ALL of the options available, but I could not find any
errors. One amazing this is that even though the error message pops out, if I refresh it, it works.

Here are some version information:

MediaWiki: 1.8.2
PHP: 5.1.6 (apache2handler)
MySQL: 5.0.24a-Debian_9-log
CPU: x86_64
OS: Ubuntu Linux Server Edgy
Kernel: 2.6.17-10-server
Website: http://www.hwasungmars.net

I hope this is not a big problem.

Version: 1.8.x
Severity: normal
OS: Linux
Platform: PC
URL: http://www.hwasungmars.net

Details

Reference: bz8198

Event Timeline

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

• bzimport added a project: MediaWiki-libs-Rdbms.

• bzimport set Reference to bz8198.

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

• bzimport created this task.Dec 9 2006, 11:29 AM

This is not a MediaWiki bug; your database server simply crashed at some point
and requires the MyISAM tables which were open at the time of the crash to be
checked for consistency.

The searchindex table is especially vulnerable to this due to the use of
MyISAM table format instead of more reliable InnoDB, as required for the
fulltext index.

(This is a general MySQL issue, so I'm going ahead and closing the bug here.)

You most likely simply need to issue MySQL's 'REPAIR TABLE' command, such as:
REPAIR TABLE mediaWiki_searchindex;

For more information, please see:

http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/myisam-table-problems.html

mediaWiki_searchindex is marked as crashed and should be repairedClosed, InvalidPublicActions

Description

Details

Event Timeline

mediaWiki_searchindex is marked as crashed and should be repaired
Closed, InvalidPublic
Actions