MYSQLD Got Signal 11 After Being Disconnected From Cluster With Warning "Disconnecting node ### because it has exceeded MaxBufferedEpochs (100 > 100)" (Doc ID 1955787.1)

Last updated on FEBRUARY 10, 2017

Applies to:

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

Symptoms

Performance decreasing on a MySQL Cluster with MCM.

Checking the status, it can be seen 2 of SQL nodes restarting.

The mysqld node disconnects from the cluster:

2014-11-28 03:36:06 [MgmtSrvr] INFO -- Node 1: Disconnecting lagging nodes '0000000000000000000000000000000000000000000000000010000000000000',
2014-11-28 03:36:06 [MgmtSrvr] WARNING -- Node 1: Disconnecting node 52 because it has exceeded MaxBufferedEpochs (100 > 100), epoch 977615/10

To then crash with signal 11:

2014-11-28 03:36:06 42177 [Note] NDB Binlog: Node: 1, unsubscribe from node 52, Subscriber bitmask 7e000000
2014-11-28 03:36:06 42177 [Note] NDB Binlog: Node: 2, unsubscribe from node 52, Subscriber bitmask 7e000000
2014-11-28 03:36:07 42177 [Note] NDB Binlog: Node: 1, down, Subscriber bitmask 00
2014-11-28 03:36:07 42177 [Note] NDB Binlog: Node: 2, down, Subscriber bitmask 00
2014-11-28 03:36:07 42177 [Note] NDB Binlog: cluster failure for ./mysql/ndb_schema at epoch 977631/7.
2014-11-28 03:36:07 42177 [Note] NDB Binlog: cluster failure for ./mysql/ndb_apply_status at epoch 977631/7.
2014-11-28 03:36:07 42177 [Note] Restarting Cluster Binlog
2014-11-28 03:36:07 42177 [ERROR] Error 4009 in ::get_auto_increment(): Cluster Failure
2014-11-28 03:36:08 42177 [Note] NDB Binlog: DISCOVER TABLE Event: REPL$mysql/ndb_schema
2014-11-28 03:36:08 42177 [ERROR] NDB Binlog: Creating NdbEventOperation failed for REPL$mysql/ndb_schema
2014-11-28 03:36:08 42177 [ERROR] NDB Binlog:FAILED CREATE (DISCOVER) EVENT OPERATIONS Event: REPL$mysql/ndb_schema
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
2014-11-28 03:36:08 42177 [ERROR] Got error 157 when reading table './current/radonline'
20:36:08 UTC - mysqld got signal 11 ;

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