3

I am attaching a database to a master and after a while, I get the following error when I run show slave status, I get the following error:

An attempt was made to binlog GTID 1-XXX-XXXXXXXXX which would create an out-of-order sequence number with existing GTID 1-YYY-YYYYYYYYY, and gtid strict mode is enabled.

I would appreciate not just steps on how to fix it, but perhaps an explanation of why this error is happening in the first place.

Thanks!

Finlay Weber
  • 2,989
  • 3
  • 17
  • 37
  • I have quite the same issue, did you find a solution for that? I couldn't do anything except setting up the replication again from a backup – user6329530 Jul 06 '21 at 18:47
  • This is probably more suited to [dba.se]. See also this question: https://dba.stackexchange.com/questions/189844/sql-slave-skip-counter-1-fails-setting-gtid-slave-pos-used-to-skip-a-given – miken32 Jan 26 '23 at 20:04

0 Answers0