Hi,
so I've tried the binary distribution for linux and I have these errors
in logfile (I've seen them already under 3.23.41, under which I compressed
the tables):
010910 18:12:20 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
010910 18:13:52 read_const: Got error 127 when reading table ./Ncrassa/contig_data
Running myisamchk without options does not show any errors. Here are some
details:
$ myisamchk -dvvv /data/mysql/Ncrassa/contig_data.MYI
MyISAM file: /data/mysql/Ncrassa/contig_data.MYI
Record format: Compressed
Character set: latin1 (8)
File-version: 1
Creation time: 2001-08-29 5:45:44
Recover time: 2001-08-30 0:08:31
Status: checked,analyzed,optimized keys,sorted index pages
Checksum: 2185832194
Data records: 247 Deleted blocks: 0
Datafile parts: 247 Deleted data: 0
Datafile pointer (bytes): 4 Keyfile pointer (bytes): 2
Datafile length: 4562802 Keyfile length: 15360
Max datafile length: 4294967294 Max keyfile length: 67107839
Recordlength: 55929
table description:
Key Start Len Index Type Rec/key Root Blocksize
1 2 3 unique uint24 1 1024 1024
2 108 100 multip. char packed stripped 1 4096 1024
3 208 255 multip. char packed stripped 247 7168 2048
4 8 100 multip. char packed stripped 1 9216 1024
5 5 3 multip. uint24 prefix 1 12288 1024
Field Start Length Nullpos Nullbit Type Huff tree Bits
1 1 1 constant 1 0
2 2 3 zerofill(2) 2 9
3 5 3 zerofill(2) 2 9
4 8 100 no endspace 2 9
5 108 100 no endspace 2 9
6 208 255 constant 3 0
7 463 12 1 1 blob 4 3
"CHECK TABLE CONTIG_DATA" says that the table is also OK.
My question is: because I compressed the table under "broken" 3.23.41,
shouldn't I uncpress the table and compress again? Or at least recreate the index.
The problem is, that I don't know how to repeat this problem. I can work with table
(i.e. SELECTs work).
However, the message in logfile is weird. It happens (and happened even
before this upgrade) with other tables:
010910 16:08:04 read_const: Got error 127 when reading table
./Athaliana_II/contig_data
010910 16:12:28 read_const: Got error 127 when reading table
./Campylobacter_jejuni_NCTC_11168/blast_data
You may want to check pub/mysql/secret/compressed.tgz or delete it as
junk. ;) Thanks!
--
Martin Mokrejs - 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
---------------------------------------------------------------------
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