Not the answer you need?
Register and ask your own question!

Tokudb BUG ? ERROR 1034 (HY000): Incorrect key file for table 'mytable'

louishustlouishust EntrantLegacy User Role Contributor
Server version: 5.7.20-18-log Percona Server (GPL), Release 18, Revision 7ce54a6deef

Table info:

CREATE TABLE `mytable` (
`ID` varchar(500) NOT NULL,
`c1` varchar(30) DEFAULT NULL,
`c2` datetime DEFAULT NULL,
`c3` datetime DEFAULT NULL,
`UPDATE_TIME` datetime DEFAULT NULL,
`c4` datetime NOT NULL,
`col1` decimal(4,0) DEFAULT NULL,
`col2` decimal(2,0) DEFAULT NULL,
`col3` decimal(2,0) DEFAULT NULL,
`col4` decimal(2,0) DEFAULT NULL,
`col5` decimal(2,0) DEFAULT NULL,
`col6` varchar(9) NOT NULL,
`col7` decimal(6,0) DEFAULT NULL,
`col8` decimal(6,0) DEFAULT NULL,
`col9` decimal(6,0) DEFAULT NULL,
`col10` decimal(6,0) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `D_UPDATE_TIME` (`UPDATE_TIME`) USING BTREE
) ENGINE=TokuDB DEFAULT CHARSET=utf8


When execute following query:

select * from mytable where update_time < '2018-01-11 07:35:02' limit 1;
ERROR 1034 (HY000): Incorrect key file for table 'mytable'; try to repair it.

FYI:

There is enough space on all my disk. The default txn isolation is RC.

Please tell me why this happend and how to repair it?

Comments

  • PeterPeter Percona CEO Percona Moderator Role
    Do you have anything in the Error Logs ?
  • George LorchGeorge Lorch Percona Percona Moderator Role Patron
    TokuDB does not emit that error. InnoDB, MyISAM and the server code appears to though. It is probably a problem with some system table.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.