Last modified: 2010-05-15 15:42:46 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T10198, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 8198 - mediaWiki_searchindex is marked as crashed and should be repaired
mediaWiki_searchindex is marked as crashed and should be repaired
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.8.x
PC Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://www.hwasungmars.net
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-12-09 11:29 UTC by Hwasung Lee
Modified: 2010-05-15 15:42 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Hwasung Lee 2006-12-09 11:29:48 UTC
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.
Comment 1 Brion Vibber 2006-12-10 08:15:51 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links