My Oracle Support Banner

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

Last updated on FEBRUARY 11, 2019

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
 Workaround
 Permanent solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.