Alter Table Fails , Innodb , ERROR 1034 (HY000): INCORRECT KEY FILE (Doc ID 2119622.1)

Last updated on DECEMBER 28, 2016

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms