Hello , i recently posted a message regarding table corruption upon deletes.
I have done more poking around and notice that Myisamchk dies upon trying to check the FULLTEXT Index in my last message. I then see that 1034 error is popping up after a myisamchk -o fixes the table , and I try to delete a record again. I have also noticed that the only tables that are corrupting are ones that have fulltext indexes. Here is some more info , if anyone can help , it would be greatly appreciated. Should I consider rebuilding the full text indexes? Thanks, Aaron mysql> DELETE FROM Offers_To_Buy WHERE ID=1601598 ; ERROR 1034 (HY000): Incorrect key file for table 'Offers_To_Buy_Mirror'; try to repair it System Info: Red Hat 9.0 Kernel 2.4.20-SMP mysql-standard-4.1.7-pc-linux-i686-icc-glibc23 1 Gig Ram Legacy SCSI Raid Array (Raid 5) Indexes on said table: mysql> SHOW INDEXES FROM Offers_To_Buy_Mirror ; +----------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +----------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Offers_To_Buy_Mirror | 1 | ID | 1 | ID | A | 53710 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | oldtitle | 1 | oldtitle | A | 53710 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | user | 1 | userID | A | 655 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | date | 1 | deletedate | A | 202 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | subcategory | 1 | subcatID | A | 1096 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | country | 1 | country | A | 166 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | source | 1 | source | A | 30 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | scdd | 1 | subcatID | A | 1096 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | scdd | 2 | deletedate | A | 26855 | NULL | NULL | | BTREE | | | Offers_To_Buy_Mirror | 1 | keywords | 1 | keywords | NULL | 26855 | NULL | NULL | YES | FULLTEXT | | | Offers_To_Buy_Mirror | 1 | bid | 1 | bid | NULL | 26855 | NULL | NULL | | FULLTEXT | | +----------------------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 11 rows in set (0.01 sec)
