Sergei Golubchik <[EMAIL PROTECTED]> writes: > Hi! > > On Oct 23, David Potter wrote: > > Dear list members, > > > > We are running Mysql 3.23 on Redhat Linux 7.1. > > > > We have an emergency. This is the first time we have ever had a > > problem. Our production database suddenly crashed. I have tried to > > repair the tables with myisamchk commands, -r, -o, etc and nothing > > works. > > > > Here is the output: > > > > myisamchk: error: 'journal.frm' doesn't have a correct index > > definition. You need to recreate it before you can do a repair > > myisamchk: error: 'journal.MYD' doesn't have a correct index > > definition. You need to recreate it before you can do a repair > > This looks like hardware bug or linux kernel bug (there're some in older > versions). MySQL, by itself, NEVER writes to .frm file (besides ALTER > TABLE and CREATE TABLE). So, as you have .frm file corrupted, it was, most > probably, not due to MySQL bug. I'd recommend you to upgrade to the > latest linux kernel - especially, if your server is working under high > load.
Make that the latest errata kernel. You'd want to be very careful about 2.4.10 and up. There are, however, no known corruption problems in existing 2.4.x kernels supported by Red Hat (flaky hardware excepted) on supported configurations (i.e. no reiserfs). -- Trond Eivind Glomsrød Red Hat, Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
