Bug #11199 | ERROR 1034 (HY000): Incorrect key file for table 'blah'; try to repair it | ||
---|---|---|---|
Submitted: | 9 Jun 2005 11:59 | Modified: | 9 Jul 2005 19:26 |
Reporter: | Adam Reynolds | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S2 (Serious) |
Version: | 4.1.12-standard | OS: | Linux (RedHat Enterprise 3.4) |
Assigned to: | CPU Architecture: | Any |
[9 Jun 2005 11:59]
Adam Reynolds
[9 Jun 2005 16:33]
Adam Reynolds
I managed to work around this problem by breating a new table using the create table like syntax, and then filling that table using the insert into table setect * from syntax. I then stopped the database, moved the offending tables files out of the way (but I still have them) restarted mysql and renemaed the new table back to the original name.
[9 Jun 2005 19:25]
Jorge del Conde
Hi! I was able to insert, update, select and delete from that table structure without problems. Is there any way you can reproduce the table corruption ? Thanks!
[9 Jul 2005 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[3 May 2009 16:55]
yogesh tiwari
Hi, Me too got the same type of error while DELETEing records from database. Snap cop: mysql> DELETE FROM FIN_SALES_REPORT_DETAILS WHERE SALES_REPORT_ID IN (SELECT SALES_REPORT_ID FROM FIN_SALES_REPORT WHERE MASTER_LICENSE_ID = 476757527); ERROR 1034 (HY000): Incorrect key file for table 'FIN_SALES_REPORT_DETAILS'; try to repair it mysql> DELETE FROM FIN_SALES_REPORT_DETAILS WHERE SALES_REPORT_ID IN (SELECT SALES_REPORT_ID FROM FIN_SALES_REPORT WHERE MASTER_LICENSE_ID=476757527); ERROR 1034 (HY000): Incorrect key file for table 'FIN_SALES_REPORT_DETAILS'; try to repair it mysql> SELECT COUNT(*) FROM FIN_SALES_REPORT_DETAILS WHERE SALES_REPORT_ID IN (SELECT SALES_REPORT_ID FROM FIN_SALES_REPORT WHERE MASTER_LICENSE_ID = 476757527); +----------+ | COUNT(*) | +----------+ | 880348 | +----------+ 1 row in set (0.00 sec)