Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
Linux
Description
Hi Team,
We have setup the GTID based Replication between 4 DB Servers and then after some time we observed that my replication breaked connections breaked are as follow:
- DB 1 --> DB 3
- DB 2 --> DB 3
- DB 1 --> DB 4
- DB 2 --> DB 4
and vice versa.
We can see the SQL error as mentioned below:
- Last_SQL_Errno: 1032
Last_SQL_Error: Could not execute Update_rows_v1 event on table aaadb.activesessions; Can't find record in 'activesessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db2-binary.005151, end_log_pos 4978
- Last_SQL_Errno: 1032
Last_SQL_Error: Could not execute Update_rows_v1 event on table aaadb.activesessions; Can't find record in 'activesessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log db1-binary.004968, end_log_pos 141985000
Please provide the resolution or steps to restore these nodes only instead of setting up GTID Replication from scratch.