Hi, I've observed some table corruption: How-To-Repeat: no idea, but maybe you might have one ;)
$ mysql -hxxx Escherichia_coli_O157_H7 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'intergenome' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 327 to server version: 3.23.49a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> check table intergenome; +--------------------------------------+-------+----------+---------------------------------------------------+ | Table | Op | Msg_type | Msg_text | | +--------------------------------------+-------+----------+---------------------------------------------------+ | Escherichia_coli_O157_H7.intergenome | check | warning | Table is marked as crashed |and last repair failed | | Escherichia_coli_O157_H7.intergenome | check | error | Can't read indexpage from |filepos: -1 | | Escherichia_coli_O157_H7.intergenome | check | error | Corrupt | | +--------------------------------------+-------+----------+---------------------------------------------------+ 3 rows in set (1.20 sec) mysql> flush tables; Query OK, 0 rows affected (0.03 sec) mysql> lock table intergenome write; ERROR 1016: Can't open file: 'intergenome.MYD'. (errno: 144) mysql> Oh yes, it was compressed before the crash. :( # /usr/local/mysql/bin/myisamchk -dvv intergenome MyISAM file: intergenome Record format: Compressed Character set: latin1 (8) File-version: 1 Creation time: 2002-03-23 19:38:55 Recover time: 2002-03-26 0:03:32 Status: crashed Checksum: 1999381211 Data records: 1712335 Deleted blocks: 0 Datafile parts: 1712335 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3 Datafile length: 200889622 Keyfile length: 12134400 Max datafile length: 4294967294 Max keyfile length: 17179868159 Recordlength: 1019 table description: Key Start Len Index Type Rec/key Root Blocksize 1 2 3 unique uint24 1 12133376 1024 2 211 255 multip. char packed stripped 0 2048 3 753 255 multip. char packed stripped 0 2048 4 111 100 multip. char packed stripped 0 1024 5 5 3 multip. uint24 0 1024 6 8 3 multip. uint24 0 1024 Field Start Length Nullpos Nullbit Type Huff tree Bits 1 1 1 constant 1 0 2 2 3 2 9 3 5 3 zerofill(1) 3 9 4 8 3 always zero 2 9 5 11 100 constant 4 0 6 111 100 no endspace 5 5 7 211 255 no endspace 6 9 8 466 4 table-lockup 7 0 9 470 255 no endspace 8 6 10 725 4 no zeros, zerofill(3) 9 1 11 729 4 table-lockup 10 0 12 733 4 table-lockup 11 0 13 737 4 zerofill(2) 12 9 14 741 2 table-lockup 13 0 15 743 2 table-lockup 14 0 16 745 4 zerofill(2) 15 9 17 749 4 zerofill(2) 16 9 18 753 255 no endspace 17 9 19 1008 10 1 1 blob 2 9 20 1018 1 1 2 always zero 2 9 21 1019 1 1 4 always zero 2 9 # /usr/local/mysql/bin/myisamchk -r -v intergenome.MYI - recovering (with sort) MyISAM-table 'intergenome.MYI' Data records: 1712335 - Fixing index 1 - Searching for keys, allocating buffer for 1525193 keys - Last merge and dumping keys - Fixing index 2 - Searching for keys, allocating buffer for 63069 keys - Last merge and dumping keys - Fixing index 3 - Searching for keys, allocating buffer for 63069 keys - Last merge and dumping keys - Fixing index 4 - Searching for keys, allocating buffer for 153916 keys 461000 [1]+ Stopped /usr/local/mysql/bin/myisamchk -r -v intergenome.MYI # ls -la intergenome.* -rw-rw---- 1 mysql mysql 200889629 Mar 23 20:04 intergenome.MYD -rw-rw---- 1 mysql mysql 50610176 Jun 6 11:24 intergenome.MYI -rw-r--r-- 1 root root 200889629 Jun 6 11:22 intergenome.TMD -rw-rw---- 1 mysql mysql 9197 Mar 23 19:38 intergenome.frm # cp intergenome.MYD intergenome.MYD.broken # fg /usr/local/mysql/bin/myisamchk -r -v intergenome.MYI - Last merge and dumping keys - Fixing index 5 - Searching for keys, allocating buffer for 1525195 keys - Last merge and dumping keys - Fixing index 6 - Searching for keys, allocating buffer for 1525195 keys - Last merge and dumping keys # ls -la intergenome.* -rw-rw---- 1 mysql mysql 200889629 Jun 6 11:22 intergenome.MYD -rw-r----- 1 root root 200889629 Jun 6 11:24 intergenome.MYD.broken -rw-rw---- 1 mysql mysql 83649536 Jun 6 11:27 intergenome.MYI -rw-rw---- 1 mysql mysql 9197 Mar 23 19:38 intergenome.frm # # diff -u -w before now --- before Thu Jun 6 11:29:29 2002 +++ now Thu Jun 6 11:29:07 2002 @@ -5,24 +5,24 @@ Character set: latin1 (8) File-version: 1 Creation time: 2002-03-23 19:38:55 - Recover time: 2002-03-26 0:03:32 - Status: crashed + Recover time: 2002-06-06 11:27:16 + Status: checked,analyzed,optimized keys Checksum: 1999381211 Data records: 1712335 Deleted blocks: 0 Datafile parts: 1712335 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 3 - Datafile length: 200889622 Keyfile length: 12134400 + Datafile length: 200889622 Keyfile length: 83649536 Max datafile length: 4294967294 Max keyfile length: 17179868159 Recordlength: 1019 table description: Key Start Len Index Type Rec/key Root Blocksize - 1 2 3 unique uint24 1 12133376 1024 - 2 211 255 multip. char packed stripped 0 2048 - 3 753 255 multip. char packed stripped 0 2048 - 4 111 100 multip. char packed stripped 0 1024 - 5 5 3 multip. uint24 0 1024 - 6 8 3 multip. uint24 0 1024 + 1 2 3 unique uint24 0 12133376 1024 + 2 211 255 multip. char packed stripped 0 26759168 2048 + 3 753 255 multip. char packed stripped 0 50608128 2048 + 4 111 100 multip. char packed stripped 0 59381760 1024 + 5 5 3 multip. uint24 0 71515136 1024 + 6 8 3 multip. uint24 0 83648512 1024 Field Start Length Nullpos Nullbit Type Huff tree Bits 1 1 1 constant 1 0 # Does this tell anything to anyone? I forgot to backup the crashed index file. Maybe that would help to decipher it (I could look into tape backup for it)? TIA -- Martin Mokrejs <[EMAIL PROTECTED]> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 --------------------------------------------------------------------- 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