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
