Last updated on MAY 05, 2016
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms