[Mediawiki-l] searchindex.MYI = errno: 145

Mon Sep 20 21:59:11 UTC 2004

By running 'perror 145', I see:

Error code 145:  Unknown error: 145
145 = Table was marked as crashed and should be repaired

Your searchindex table is corrupt.  You can either use REPAIR TABLE from 
within mysql, or you can use the myisamchk app to try to fix the file.  
There's a lot of info on this at http://www.mysql.com

I'd probably repair the file, and then re-run the maintenance script 
'rebuildtextindex.php' with the command:
     php rebuildtextindex.php

I'd also suggest figuring out the root cause of that table corruption, 
but I don't have any great advice for you.  When I was having corruption 
problems, it turned out to be an OS bug or corruption in my partition, I 
don't know which.  I'd worry if you see this corruption again, but for 
now, maybe it's no huge issue.

good luck!
-nick

Markus Klaus Schäffauer wrote:

> Hello,
>
> since I installed MediaWiki 1.3.3, I get sometimes the following error 
> message from the search engine (and have to repair the table):
>
> "SearchEngine::showResults". MySQL meldete den Fehler "1016: Can't 
> open file: 'searchindex.MYI'. (errno: 145)".
>
> What can be the reason for that behaviour and what can I do to avoid it?
>
> Thank you!
> Markus
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l