Re: Incorrect key file for table 'XXX.MYI'; try to repair it

[Shane Bester]

Hi Hava!

In addition to Rick's comments, you should consider upgrading. 5.0.21 is known
to have many corruption bugs. Go for 5.0.90 or 5.1.45 as a start.. Here are some bugs, in case of anything relevant:

| http://bugs.mysql.com/6265 | Closed | DELETE+ INSERT .. SELECT + DELETE crash table. |
| http://bugs.mysql.com/18544 | Closed | LOCK TABLES timeout causes MyISAM table corruption |
| http://bugs.mysql.com/19627 | Closed | temporary merge table locking |
| http://bugs.mysql.com/22384 | Closed | DELETE FROM table causes "Incorrect key file for table" |
| http://bugs.mysql.com/23578 | Closed | Corruption prevents Optimize table from working properly with a spatial index |
| http://bugs.mysql.com/23838 | Can't repeat | Incorrect key file for table |
| http://bugs.mysql.com/24566 | Closed | Incorrect key file for table ( the size of table is more than 2G) |
| http://bugs.mysql.com/25048 | Closed | ERROR 126 : Incorrect key file for table '.XXXX.MYI'; try to repair it |
| http://bugs.mysql.com/25255 | Can't repeat | MyISAM table corruption when using thread_cache_size |
| http://bugs.mysql.com/25433 | Won't fix | KILL causes errno 144 table '.\test\t1' is marked as crashed |
| http://bugs.mysql.com/25523 | Can't repeat | Corruption of MyISAM tables |
| http://bugs.mysql.com/25673 | Closed | spatial index corruption, error 126 incorrect key file for table |
| http://bugs.mysql.com/25712 | Closed | insert delayed and check table run together report crashed tables |
| http://bugs.mysql.com/25853 | Closed | key_cache_block_size=4MB causes table corruptions + duplicate key errors |
| http://bugs.mysql.com/26464 | Closed | insert delayed + update + merge = corruption |
| http://bugs.mysql.com/28574 | Closed | repair table causes queries to fail with various corruption errors: 126,134,145 |
| http://bugs.mysql.com/28837 | Closed | MyISAM storage engine error (134) doing delete with self-join |
| http://bugs.mysql.com/29070 | Closed | Error in spatial index |
| http://bugs.mysql.com/29261 | Closed | repeatable innodb and myisam corruption |
| http://bugs.mysql.com/29299 | Closed | repeatable myisam fulltext index corruption |
| http://bugs.mysql.com/29333 | Closed | myisam corruption with character set cp932 collate cp932_japanese_ci |
| http://bugs.mysql.com/29838 | Closed | myisam corruption using concurrent select ... and update |
| http://bugs.mysql.com/30284 | Closed | spatial key corruption |
| http://bugs.mysql.com/30286 | Closed | spatial index cause corruption and server crash! |
| http://bugs.mysql.com/31305 | Closed | myisam tables crash when they are near capacity |
| http://bugs.mysql.com/32705 | Closed | myisam corruption: Key in wrong position at page 1024 with ucs2_bin |
| http://bugs.mysql.com/32791 | Verified | Incorrect key file for table './nica_search/test.MYI'; try to repair it |
| http://bugs.mysql.com/37752 | Duplicate | Table crash for ROW_FORMAT=DYNAMIC on MyISAM |
| http://bugs.mysql.com/38848 | Closed | myisam_use_mmap causes widespread myisam corruption on windows |
| http://bugs.mysql.com/43932 | Closed | myisam index corruption with large index and large key_buffer_size |
| http://bugs.mysql.com/44657 | Duplicate | Got error 124 from storage engine when load concurrent data infile working |
| http://bugs.mysql.com/46766 | Duplicate | ALTER TABLE corrupts table on combined drop and add index |
| http://bugs.mysql.com/46946 | No Feedback | myisamchk -n corrupts table with spatial index |
| http://bugs.mysql.com/47073 | Closed | valgrind errs, corruption,failed repair of partition,low myisam_sort_buffer_size |
| http://bugs.mysql.com/48645 | Patch pending | Dropping an unique key and adding one leads to a table corruption |
| http://bugs.mysql.com/49030 | Verified | optimize table breaks myisam table when using myisam_use_mmap on windows |
| http://bugs.mysql.com/49250 | Closed | spatial btree index corruption and crash |
| http://bugs.mysql.com/49628 | Closed | corrupt table after legal SQL, LONGTEXT column |
| http://bugs.mysql.com/51307 | Closed | widespread corruption with partitions and insert...select |
| http://bugs.mysql.com/52599 | Verified | alter table remove partitioning on non-partitioned table corrupts myisam index |