8 messages in com.mysql.lists.bugsRe: myisamchk fails to recover a corr...| From | Sent On | Attachments |
|---|---|---|
| Jocelyn Fournier | 31 Aug 2002 18:13 | |
| Sinisa Milivojevic | 02 Sep 2002 06:30 | |
| Jocelyn Fournier | 02 Sep 2002 10:01 | |
| Sinisa Milivojevic | 02 Sep 2002 11:15 | |
| Jocelyn Fournier | 02 Sep 2002 11:19 | |
| Jocelyn Fournier | 02 Sep 2002 13:08 | |
| Sinisa Milivojevic | 03 Sep 2002 05:18 | |
| Sinisa Milivojevic | 03 Sep 2002 05:19 |
| Subject: | Re: myisamchk fails to recover a corrupted table |
|---|---|
| From: | Jocelyn Fournier (jo...@presence-pc.com) |
| Date: | 09/02/2002 10:01:53 AM |
| List: | com.mysql.lists.bugs |
Hi,
In fact, it seems those particular table doesn't support the backup done by mysqldump. I've just taken a look at the MySQL error file and I can see :
020830 17:48:40 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 2:30:36 Warning: Retrying repair of: './forum/cookie' with keycache 020901 2:36:01 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 2:36:03 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 02:36:03 mysqld ended
020901 02:36:07 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 2:36:24 Warning: Retrying repair of: './forum/cookie' with keycache 020901 2:40:56 Warning: Retrying repair of: './forum/cookie' with keycache 020901 2:42:53 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 2:42:53 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 02:42:53 mysqld ended
020901 02:45:54 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 2:47:03 Warning: Retrying repair of: './forum/cookie' with keycache 020901 2:48:30 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 2:48:31 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 02:48:31 mysqld ended
020901 02:48:36 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 2:57:29 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 2:57:30 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 02:57:30 mysqld ended
020901 02:57:48 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 3:48:17 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 3:48:18 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 03:48:18 mysqld ended
020901 03:48:21 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 3:55:00 /usr/local/mysql/libexec/mysqld: Normal shutdown
020901 3:55:00 /usr/local/mysql/libexec/mysqld: Shutdown Complete
020901 03:55:00 mysqld ended
020901 03:55:46 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 020901 3:57:11 Warning: Retrying repair of: './forum/cookie' with keycache
note that each mysqld ended / started correspond to a backup (mysqldump --add-drop-table --compress --extended-insert --all-databases --c omplete-insert > /home/tmp/bases-presencepc-"$DATETGZ".sql ). In this log, cookie is a new freshly created table.
(BTW mysqldump seems to automatically shutdown mysqld ?)
Regards, Jocelyn
----- Original Message ----- From: "Sinisa Milivojevic" <sin...@mysql.com> To: <jo...@presence-pc.com> Cc: <bu...@lists.mysql.com> Sent: Monday, September 02, 2002 3:31 PM Subject: Re: myisamchk fails to recover a corrupted table
Jocelyn Fournier writes:
Hi,
I've just encountered a problem with myisamchk on a corrupted table.
How-to-repeat :
anedroide:/var/lib/mysql/var# myisamchk -o cookie.MYI - recovering (with keycache) MyISAM-table 'cookie.MYI' Data records: 70572 Found block with too small length at 21127024; Skipped Duplicate key 1 for record at 21513280 against new record at 20111600 myisamchk: Error writing file 'UNOPENED' (Errcode: 9) MyISAM-table 'cookie.MYI' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option
(I already tried to regenerate the .MYI et .frm files, but it doesn't change anything, so it seems to be the data file which is corrupted)
I uploaded the table on ftp://support.mysql.com/pub/mysql/secret/cookie.tar.gz
(I'm using latest mysql-4.0.4 available version)
Regards, Jocelyn
HI!
Your table is truly terribly crashed.
I tried all tricks and none helped.
Can you check whether your file system and / or disk are OK ??
-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com
--------------------------------------------------------------------- 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 bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>