Alter Table Fails , Innodb , ERROR 1034 (HY000): INCORRECT KEY FILE
(Doc ID 2119622.1)
Last updated on FEBRUARY 11, 2019
MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
When attempting to alter table an Innodb table the the following error occurs.
mysql> ALTER TABLE 'test'.'t1' ADD COLUMN 'a' BIGINT(11) NULL AFTER 'b',ADD COLUMN 'c' VARCHAR(45) NULL AFTER 'a';
ERROR 1034 (HY000): Incorrect key file for table 't1'; try to repair it
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.