Re: ERROR 1034 (HY000): Incorrect key file for table
Posted by:
Rick James
Date: February 05, 2015 06:39PM
Well, this is close:
----- 2009-12-07 5.5.0 Milestone 2 -- Bugs Fixed -- -----
With InnoDB, renaming a table column and then creating an index on the renamed column caused a server crash to the .frm file and the InnoDB data directory going out of sync. Now InnoDB 1.0.5 returns an error instead: ERROR 1034 (HY000): Incorrect key file for table 'tbl_name'; try to repair it. To work around the problem, create another table with the same structure and copy the original table to it. (Bug #44571)
http://bugs.mysql.com/bug.php?id=44571
(That was also put into 5.1.41)
I can't dup it in 5.6.12. Suggest you write a bug report against 5.5.17 and reference that old bug. Then post the bug number here.
The bug folks can probably pin down when it was fixed.
Meanwhile, you could upgrade to the current 5.6.xx.
Subject
Views
Written By
Posted
9782
February 04, 2015 03:38AM
Re: ERROR 1034 (HY000): Incorrect key file for table
13579
February 05, 2015 06:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.