Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
When using MASTER_USE_GTID=Slave_Pos to connect to a primary with purged binary logs (such that it has a non-empty GTID List event in its oldest binlog), all GTIDs are compared from the replica's variable @@global.gtid_slave_pos against the primary's oldest GTID list event. This behavior will result in error code 1236 on the replica if 1) the primary's oldest GTID list event specifies transactions in a domain which the replica is configured to ignore (either specified in IGNORE_DOMAIN_IDS or inferred through DO_DOMAIN_IDS), and 2) the transactions are not accounted for in the replica's gtid_slave_pos.
Instead, domains which the replica doesn't care about should not be considered in the primary's initial GTID state validation check.