ERROR 1034 (HY000): Incorrect key file for table
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