[Mediawiki-l] FIXED: Ungraceful mysqld shutdown & "Database error"

[Matt England]

[I wrote this before I saw Brion's reply...apparently my mail delivery on 
this list got shut off seemingly without me knowing it...hmmm....

I'll still send the note below for my future documentation purposes...and 
for those in my group admin-ing our MediaWiki site.]


At 4/28/2005 05:14 PM, Matt England wrote:
>I unfortunately was in a position where I ungracefully shutdown my mysql 
>server.  After restarting it, I'm finding that MediaWiki reports "Database 
>error: Internal error" after any attempt to save an edited wiki 
>page.  It's worth noting that all the changes seem to be accepted, in that 
>if I visit the page the changes I supplied during the edit are displayed.

It appears (initially) that I have at least removed my symptom.

I initially found this while trying to dump my mediawiki database (in an 
attempt to recreate it somewhere else):

root at biz2tek 5:50pm [/scratch/mediawiki-database-recovery] 93> mysqldump -u 
root -p mediawiki_1 > mediawiki_1.sql
Enter password:
mysqldump: Can't get CREATE TABLE for table `searchindex` (Can't open file: 
'searchindex.MYI'. (errno: 145))
root at biz2tek 5:50pm [/scratch/mediawiki-database-recovery] 94>

...so then I did some googling on "mysql errno 145" and found this reference:

http://www.karakas-online.de/forum/viewtopic.php?t=332

...and then followed the recommendations there to do the following stuff, 
which seems to have cleared up my problem.  (*whew*)

Is it fair to assume that database-table corruption (particularly the 
indeces) can be a common issue, particularly during an ungraceful (in my 
case 'kill -9') database shutdown?

-Matt


root at biz2tek 5:50pm [/scratch/mediawiki-database-recovery] 93> mysqldump -u 
root -p mediawiki_1 > mediawiki_1.sql
Enter password:
mysqldump: Can't get CREATE TABLE for table `searchindex` (Can't open file: 
'searchindex.MYI'. (errno: 145))
root at biz2tek 5:50pm [/scratch/mediawiki-database-recovery] 94> mysql -u 
root -p mediawiki_1           Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 154 to server version: 4.0.21-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> repair table searchindex;
+-------------------------+--------+----------+----------+
| Table                   | Op     | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| mediawiki_1.searchindex | repair | status   | OK       |
+-------------------------+--------+----------+----------+
1 row in set (0.30 sec)

mysql> exit
Bye
root at biz2tek 5:51pm [/scratch/mediawiki-database-recovery] 95>
root at biz2tek 5:51pm [/scratch/mediawiki-database-recovery] 95> mysqldump -u 
root -p mediawiki_1 > mediawiki_1.sql
mediawiki_1.sql: File exists.
root at biz2tek 5:51pm [/scratch/mediawiki-database-recovery] 96> rm !$
rm mediawiki_1.sql
rm: remove regular file `mediawiki_1.sql'? y
root at biz2tek 5:51pm [/scratch/mediawiki-database-recovery] 97> mysqldump -u 
root -p mediawiki_1 > mediawiki_1.sql
Enter password:
root at biz2tek 5:51pm [/scratch/mediawiki-database-recovery] 98>



At 4/28/2005 05:14 PM, Matt England wrote:
>Hello,
>
>I'm in a bit of predicament.
>
>I unfortunately was in a position where I ungracefully shutdown my mysql 
>server.  After restarting it, I'm finding that MediaWiki reports "Database 
>error: Internal error" after any attempt to save an edited wiki 
>page.  It's worth noting that all the changes seem to be accepted, in that 
>if I visit the page the changes I supplied during the edit are displayed.
>
>I'm trying to debug this problem, for while it seems cosmetic at first, 
>it's certainly disturbing to my users.  Further, I want to learn from this 
>and figure out how to recover from this...not to mention figure out where 
>the darn mysql/mediawiki logs are.  [[Special:Log]] tells me absolutely 
>nothing.  Not one log entry.
>
>I am running mysql 4.0.21, MediaWiki 1.4.0, Apache 2.0.52 (apache and 
>mysql stuff comes from XAMPP 1.49a).  I can provide more info about this 
>upon request.  I'd also provide pertinent logs...if I could find anything.
>
>I'm hunting around meta.wikimedia.org and have yet to find anything that 
>addresses.  I also have tried several times to search this email list's 
>archive via a google mechanism and have yet to succeed (I can't find any 
>of my old emails from several weeks/months ago when I search for "Matt 
>England"...even though I can find *some* emails...).
>
>Thanks for any help.  Like I mentioned, I'm kind of in a tight spot on 
>this one.
>
>-Matt