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?