Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9033

Incorrect statements binlogged on slave with do_domain_ids=(...)

Details

    • 10.1.9-3

    Description

      Problem originally reported by user rsevero on IRC FreeNode #maria.

      Attached test case rpl.rpl_gtid_rsevero produces output with spurious extra CREATE TABLE statements in slave binlogs, probably depends on exact timing. For example:

      master-bin.000001	314	Gtid	1	352	GTID 1-1-1
      		 
      master-bin.000001	352	Query	1	479	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB
      		 
      master-bin.000001	479	Gtid	1	517	BEGIN GTID 1-1-2
      		 
      master-bin.000001	517	Query	1	611	use `test`; INSERT INTO t1 VALUES (1, "m1")
      		 
      master-bin.000001	611	Xid	1	638	COMMIT /* xid=224 */
      		 
      master-bin.000001	638	Gtid	1	676	BEGIN GTID 1-1-3
      		 
      master-bin.000001	676	Query	1	792	use `test`; INSERT INTO t1 VALUES (2, "m2"), (3, "m3"), (4, "m4")
      		 
      master-bin.000001	792	Xid	1	819	COMMIT /* xid=226 */
      		 
      master-bin.000001	819	Gtid	1	857	GTID 3-1-1
      		 
      master-bin.000001	857	Query	1	984	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB
      		 
      master-bin.000001	984	Gtid	1	1022	GTID 2-1-1
      		 
      master-bin.000001	1022	Query	1	1149	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB
      		 
      master-bin.000001	1149	Gtid	1	1187	GTID 2-1-2
      		 
      master-bin.000001	1187	Query	1	1314	use `test`; CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB

      Note the wrong domain values in the GTIDs 3-1-1, 2-1-1, and 2-1-2; in the
      test case, no transaction is ever created with a domain id other than 1.

      In contrast, the same test using corresponding ignore_server_ids in place of
      do_domain_ids (rpl_gtid_rsevero2) does not exhibit this problem. So looks
      like a problem with the implementation of do_domain_ids, perhaps?

      Attachments

        1. rpl_gtid_rsevero.cnf
          0.3 kB
        2. rpl_gtid_rsevero.test
          2 kB
        3. rpl_gtid_rsevero2.cnf
          0.3 kB
        4. rpl_gtid_rsevero2.test
          2 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9113 Endless loop in multi-source replication with do_domain_ids

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9107 GTID Slave Pos of untrack domain ids being updated

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9108 "GTID not in master's binlog" error with {ignore|do}_domain_ids

          • Major - Major loss of function.
          • Open

          Activity

            People

              knielsen Kristian Nielsen
              knielsen Kristian Nielsen
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.