My Oracle Support Banner

[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:

mysql> SELECT * from ndb_binlog_index;
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.