Last modified: 2010-05-15 15:34:02 UTC
System: Suse Linux 9.1
For some reasons the wiki_searchindex.MYI file gets corrupt and can't accessed anymore. The File itself exists. If i
view it in phpmyadmin the table self is shown as "in use". (Maybe the table is locked and for some reasons isn't
unlocked after processing). I discovered this "bug" the second time now. First time right after installation.
Errormessage from logfile:
SearchUpdate::doUpdate 1016 Can't open file: 'wiki_searchindex:MYI' (errno: 145)
This is a bug of MySQL engine or a host running it. No application (mediawiki
either) would be able to work directly with that file. You can try fixing your
tables with 'REPAIR TABLE'.
The below was a dialog with a support person at my hosting company. I have been
having this problem repeatedly. It will show up when editing a page or doing a
search. This is the third time I have had to have them repair the table. Any
ideas or further information you may or maynot need?
The problem was a corrupted .MYI file (bang_searchindex.MYI). Generally when you
see 'Can't open file:' errors, that's the cause. I'd say since this seems to be
reoccurring on the same script that there's something not quite right with the
queries the script is using, but I can't be more specific than that. It might
potentially be a mysql version issue, so if it helps any the mysqld version on
this server is 4.0.24.
==( Ticket Thread #[ 85094 ] Summary )===========================[ BEGIN ]
Request, problem again.<br>an issue with a db error keeps popping up. at first
it showed up during page updates, but now it shows up on searches. please try a
search on the
error should say...<br> A database query syntax error has occurred. This may
indicate a bug in the software. The last attempted database query was:<br><br>
(SQL query hidden)<br><br>from within function ''. MySQL returned error '1016:
Can't open file: 'bang_searchindex.MYI'. (errno: 145) (localhost)'.<br><br><br>I
have researched this on the mediawiki site, and they say that it is a db error.
please advise, and if there is a solution, please include what that is in your
fix / reply. <br><br>fyi, this is the second time i have reported this.<br>
=====================================================================[ END ]
MySQL error: 145 = Table was marked as crashed and should be repaired
This means that MySQL crashed or was shut down improperly while the table was open.
No error in MediaWiki could possibly cause this -- it is either a bug in MySQL, a bug in
the operating system that the database server is running on, or improper maintenance
of the database server (unclean shutdowns, or hardware errors causing crashes).
You need to ask your host to check their MySQL error log for problems, such as crashes
(MySQL normally restarts itself if the server daemon itself crashes, and they might not
be noticing until someone reports an error).