Mailing List Archive

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@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

On 09/20/2004 4:23 PM, Markus Klaus Schäffauer
<markus.klaus.schaeffauer@romanistik.uni-freiburg.de> 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?

# /usr/bin/perror 145
MySQL error: 145 = Table was marked as crashed and should be repaired

Shut down your database and run `myisamchk -r` on that file.

Paul

On Sep 20, 2004, at 3:21 PM, Paul Fierro wrote:
> # /usr/bin/perror 145
> MySQL error: 145 = Table was marked as crashed and should be repaired
>
> Shut down your database and run `myisamchk -r` on that file.

Shutting down shouldn't generally be necessary; you can issue 'REPAIR
TABLE searchindex' from within mysql.

Note that these kinds of errors indicate one or more of the following:
* Power outage or other unorganized shutdown of the computer / server.
* Bug in MySQL itself
* Bug in operating system
* Hardware failure

-- brion vibber (brion @ pobox.com)