[Error] Mysqld: Incorrect Key File For Table './mysql/ndb_binlog_index.myi'; Try To Repair It (Doc ID 1359881.1)

Last updated on MAY 05, 2016

Applies to:

MySQL Cluster - Version 6.3 and later
Information in this document applies to any platform.

Symptoms

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
[...]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms