Hi,
once I've reported here problems that somehow randomly we get these
errors in mysql's log file. It looks, that when user drops a table, a
table isn't dropped or somehow remains in cache. The when user tries to
create the table again from scratch, he get's the error 127.
Please note that the error is clearly NOT loggeg in mysqld's error
logfile. Flushing logs or hosts or threads doesn't help to get this error
written to disk.
From what has the user reported, from such a dropped & improperly
recreated table he can only select using the first column and doesn't get
the data from other columns at all. While I was flushing table cache few
times per day, he found that possibly this fixed his problem.
I'm curious why he gets the error when adding index to table's column.
Why not when trying to create the table already?
We are trying to get more out from this. ;)
kulan$ tail /usr/local/mysql/log/kulan.gsf.de.err
011211 13:11:32 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:15:43 read_const: Got error 127 when reading table
./Listeria_monocytogenes_EGD/orf_data
011211 13:16:03 read_const: Got error 127 when reading table
./Listeria_monocytogenes_EGD/orf_data
011213 11:37:32 read_const: Got error 127 when reading table
./Saccharomyces_cerevisiae/funcat_data
011213 11:41:40 read_const: Got error 127 when reading table
./Saccharomyces_cerevisiae/funcat_data
011213 19:14:13 read_const: Got error 127 when reading table
./Agrobacterium_tumefaciens_C58_pAT/blast_data
011213 19:23:21 read_const: Got error 127 when reading table
./Agrobacterium_tumefaciens_C58_pAT/blast_data
011219 16:47:28 read_const: Got error 127 when reading table ./Spombe/blast_data
kulan$ /home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/parse.pl -table intergenome -db
Saccharomyces_cerevisiae
DBD::mysql::st execute failed: Got error 127 from table handler at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Database_Pro_MySQL.pm line 292.
Can not execute SQL statement: 'alter table intergenome add index (hitcode)' at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Database_Pro_MySQL.pm line 292
Database_Pro_MySQL::PrepEx('Database_Pro_MySQL=HASH(0x8594fc8)', 'alter table
intergenome add index (hitcode)') called at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Database_Pro_MySQL.pm line 277
Database_Pro_MySQL::AddIndex('Database_Pro_MySQL=HASH(0x8594fc8)',
'intergenome', 'hitcode') called at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Parse_Pro.pm line 393
Parse_Pro::_IndexTable('Parse_Pro=HASH(0x841b2d8)') called at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Parse_Pro.pm line 373
Parse_Pro::_SetTable('Parse_Pro=HASH(0x841b2d8)') called at
/home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/Parse_Pro.pm line 307
Parse_Pro::new('Parse_Pro', 'SET', 'Saccharomyces_cerevisiae', 'METH',
'intergenome') called at /home/w3/pedant2/mips/PEDANT2/soft/PEDANT2/PERL/parse.pl line
177
Database handle destroyed without explicit disconnect.
kulan$ tail /usr/local/mysql/log/kulan.gsf.de.err
011211 13:11:32 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:11:33 read_const: Got error 127 when reading table ./hemi_prot/prot_data
011211 13:15:43 read_const: Got error 127 when reading table
./Listeria_monocytogenes_EGD/orf_data
011211 13:16:03 read_const: Got error 127 when reading table
./Listeria_monocytogenes_EGD/orf_data
011213 11:37:32 read_const: Got error 127 when reading table
./Saccharomyces_cerevisiae/funcat_data
011213 11:41:40 read_const: Got error 127 when reading table
./Saccharomyces_cerevisiae/funcat_data
011213 19:14:13 read_const: Got error 127 when reading table
./Agrobacterium_tumefaciens_C58_pAT/blast_data
011213 19:23:21 read_const: Got error 127 when reading table
./Agrobacterium_tumefaciens_C58_pAT/blast_data
011219 16:47:28 read_const: Got error 127 when reading table ./Spombe/blast_data
kulan$
--
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
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
