Last modified: 2010-05-15 15:34:02 UTC
CPU: AMD64 PHP: 5.3 MySql: 4.1.9 System: Suse Linux 9.1 Tableprefix: wiki_ 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. Thanks! Support ==( Ticket Thread #[ 85094 ] Summary )===========================[ BEGIN ] Username, ******* 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 site...<br>http://www.bayareanightgame.com<br><br>http://www.bayareanightgame.com/index.php/Special:Search?search=something&go=Go<br><br>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).
