Replication breaks repeatedly
Hi,
we've setted up a replicated Master<->Master Scenario with 5.7.13 on Centos6.
Traffic is ususally directed to just one instance.
Our problem is that once in a while the inactive node stops the slave process with error messages like this:
Last_SQL_Error: Could not execute Update_rows event on table nagios.nagios_servicestatus; Can't find record in 'nagios_servicestatus', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000001, end_log_pos 974
For sure I can tell 2 situations when this problem appears:
1) A dumpfile is created on the active database
2) The inactive database is rebooted
The GID Information then states something like:
Retrieved_Gtid_Set: 33b67877-2183-11e6-b1ff-a0d3c1f0bf30:1-29933578
Executed_Gtid_Set: 33b67877-2183-11e6-b1ff-a0d3c1f0bf30:323326-29657147,
da671ab8-2183-11e6-a53a-a0d3c1f0bbcc:1-2
Subject
Views
Written By
Posted
Replication breaks repeatedly
1931
July 11, 2016 10:22AM
989
July 11, 2016 10:33AM
751
July 11, 2016 10:35AM
872
July 12, 2016 04:53AM
785
July 12, 2016 07:31AM
834
July 12, 2016 09:18AM
718
August 04, 2016 07:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.