MySQL Cluster Replication : MYSQLD Stopped Writing to Binary Log (Doc ID 2065399.1)

Last updated on MARCH 18, 2016

Applies to:

MySQL Cluster - Version 7.2 to 7.4 [Release 7.2 to 7.4]
Information in this document applies to any platform.

Symptoms

The binlog stopped writing.

The SHOW MASTER STATUS shows the position of the binlog is not increasing, thus stopped:

+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000020 | 49524231 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+

Looking at the timestamp of the last update on the binlog, and comparing to the current date, can be confirmed is not being updated:

[root@host ~]# ls -alrt /product/mysql-cluster/mcm_data/clusters/mycluster/49/data/mysql-bin.000020
-rw-rw---- 1 mysql mysql 49524231 Jan 16 16:21 /product/mysql-cluster/mcm_data/clusters/mycluster/49/data/mysql-bin.000020

From SHOW ENGINE NDB STATUS the latest_epoch are also seen frozen:

MYSQL01 | ndbcluster | binlog | latest_epoch=12016674249113608, latest_trans_epoch=12369325423853571, latest_received_binlog_epoch=12016674249113608, latest_handled_binlog_epoch=12016674249113608, latest_applied_binlog_epoch=12016674249113607 |

The SHOW PROCESSLIST appeared like this:

+---------+-------------+----------------------+------+---------+--------+--------------------------+------------------+
| Id      | User        | Host                 | db   | Command | Time   | State                    | Info             |
+---------+-------------+----------------------+------+---------+--------+--------------------------+------------------+
| 1       | system user |                      |      | Daemon  | 561648 | Waiting for schema epoch | NULL             |
| 4076547 | mysql       | 192.168.10.101:53388 | NULL | Query   | 0      | NULL                     | show processlist |
+---------+-------------+----------------------+------+---------+--------+--------------------------+------------------+
2 rows in set (0.00 sec)

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