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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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