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

A slave's ignored domain ids should not be validated when connecting to a master

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      When using MASTER_USE_GTID=Slave_Pos to connect to a master with purged binary logs (such that it has a non-empty GTID List event in its oldest binlog), all GTIDs are compared from the slave's variable @@global.gtid_slave_pos against the master's oldest GTID list event. This behavior will result in error code 1236 on the slave if 1) the master's oldest GTID list event specifies transactions in a domain which the slave 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 slave's gtid_slave_pos.

      Instead, domains which the slave doesn't care about should not be considered in the master's initial GTID state validation check.

      Attachments

        Issue Links

          Activity

            People

              susil.behera Susil Behera
              bnestere Brandon Nesterenko
              Brandon Nesterenko Brandon Nesterenko
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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