MySQL Forums
Forum List  »  InnoDB

ERROR 1034 (HY000): Incorrect key file for table
Posted by: jongse park
Date: February 04, 2015 03:38AM

Hi,

I use a mysql 5.5.17 server.
when I add index. there is a error:
ERROR 1034 (HY000): Incorrect key file for table

This is the script.
----------------------------------------------------------------------------
mysql> CREATE TABLE `test1` (
-> `neName` varchar(40) NOT NULL DEFAULT '',
-> `cellNum` int(10) DEFAULT NULL,
-> `relationIdx` int(10) DEFAULT NULL,
-> `enbId` int(10) DEFAULT NULL,
-> `targetCellNum` int(10) DEFAULT NULL
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.11 sec)
mysql> alter table test1 modify column enbid int unsigned;
Query OK, 0 rows affected (0.17 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table test1 modify column targetcellnum int unsigned;
Query OK, 0 rows affected (0.16 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table test1 add index test_idx (enbid, targetcellnum);
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> drop table test1;
mysql> CREATE TABLE `test1` (
-> `neName` varchar(40) NOT NULL DEFAULT '',
-> `cellNum` int(10) DEFAULT NULL,
-> `relationIdx` int(10) DEFAULT NULL,
-> `enbId` int(10) DEFAULT NULL,
-> `targetCellNum` int(10) DEFAULT NULL
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.11 sec)
mysql>
mysql> alter table test1 modify column enbid int;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table test1 modify column targetcellnum int;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table test1 add index test_idx (enbid, targetcellnum);
ERROR 1034 (HY000): Incorrect key file for table 'test1'; try to repair it
--------------------------------------------------------------------------

1.
Why does it happen? Is this bug ?
which case does it occur ?
2.
Is there any side effect from this error ?
Is there any similar thing in mysql?
3.
Is there any patch for fix this problem in mysql 5.5.17?

Please help me.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1034 (HY000): Incorrect key file for table
9752
February 04, 2015 03:38AM


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.