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

with Master/Slave replication from Galera4 node, MariaDB ignores replicate_do_table

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5.19
    • N/A
    • Replication
    • None

    Description

      on on Galera4 (master) node
      1. do the full backup with maria-backup

      on standalone (slave) node:
      2. maria-backup prepare backup
      3. create table, discard tablespace, import tablespace from backup
      4. set global replicate_do_db='ctac';
      5. SET GLOBAL replicate_do_table='ctac.writetest';
      6. CHANGE MASTER 'ppes' TO MASTER_HOST='ppes2', master_user='root', master_password='password', MASTER_PORT=3406, master_log_file='pes2-logbin.003137', master_log_pos=5789;
      7. check the error.log:
      2025-03-09 13:00:55 2743 [Note] Master 'ppes': Slave I/O thread: connected to master 'root@ppes2:3406',replication started in log 'pes2-logbin.003137' at position 5789
      2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Could not execute Update_rows_v1 event on table heartbeat.heartbeat; Can't find record in 'heartbeat', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log pes2-logbin.003137, end_log_pos 6171, Gtid 144-85-7041435, Internal MariaDB error code: 1032
      2025-03-09 13:00:55 2744 [ERROR] Master 'ppes': Slave SQL: Node has dropped from cluster, Gtid 144-85-7041435, Internal MariaDB error code: 1047
      2025-03-09 13:00:55 2744 [Note] Master 'ppes': Slave SQL thread exiting, replication stopped in log 'pes2-logbin.003137' at position 5789

      =================
      where ctac.writetest - table to be replicated, heartbeat.heartbeat - local to galera4 cluster (master) with pt-heartbeat manual emulation, which we don't want to replicate

      Attachments

        Activity

          People

            Unassigned Unassigned
            CTAC Stanislav Sukholet
            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.