[Error] Mysqld: Incorrect Key File For Table './mysql/ndb_binlog_index.myi'; Try To Repair It
(Doc ID 1359881.1)
Last updated on APRIL 02, 2018
Applies to:MySQL Cluster - Version 6.3 and later
Information in this document applies to any platform.
Under certain conditions, the system table ndb_binlog_index can become corrupted.
The most common symptom of such corruption is the ERROR 1194 while trying to execute the following query:
ERROR 1194 (HY000): Table 'ndb_binlog_index' is marked as crashed and should be repaired
The table corruption can be confirmed also from the MySQL error log:
Failed to flush master info file
Slave I/O thread exiting, read up to log 'log-bin.NNNNNN', position MMMMMMMMM
Error reading relay log event: slave SQL thread was killed
Error writing file 'path-to-binlog/log-bin' (errno: 30)
mysqld: Incorrect key file for table './mysql/ndb_binlog_index.MYI'; try to repair it
NDB Binlog: Writing row (A,B,C) to ndb_binlog_index: N
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