Replication_Error: Relay log write failure: cocould not queue event from master, eventqueue

Replication_Error: Relay log write failure: cocould not queue event from master, eventqueue

Mysql Version: 5.6.16

OS Version: CentOS release 6.4 (Final)

Replication: Master-Master

Just now I suddenly found that the DB Master1 (currently read/write) disk is full, and DB Master2 (currently not provided for external write) replication throws an exception: Relay log write failure: cocould not queue event from master, and Slave_IO_Running: No.

At that time, the first solution was to try to stop slave; start slave; refresh the replication thread on DB master2.

Then, try to query the binlog on Master1, find the corresponding binlog, find the next binlog pos point, and re-perform the change master operation to skip the error pos point. Try again, no. Error:

Finally, we can skip the entire binlog log and continue copying from the next binlog013048 (this operation depends on the environment, and we need to consider whether the following data may report errors ).

Then, verify the replication difference using the pt tool. If there is any difference, fix it ........

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.