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

GTID different between nodes

    XMLWordPrintable

Details

    Description

      Hi,

      I've configure a Galera Cluster between two sites (Site 1 and 2)
      First node of site 1 is a slave of the current production Master (Percona 5.5.14 with standard replication).

      Behind each nodes of the second site I've 3 RO replica with GTID method.

      My problem is that I have the same GTID between each nodes except the node 1 of site 1 - node who's replica of the Master production.
      I can switch a RO replica between each nodes except with the first one on site 1 because when I switch to it I've an error like this:

      Last_Error: Could not execute Write_rows_v1 event on table test.tes1; Duplicate entry '195001708' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000002, end_log_pos 40652604

      Need help to understand what happen.

      On each config file I have:

      log_bin=binlog
      binlog_format=ROW
      log_slave_updates=on
      wsrep_gtid_mode=on

      Regards

      Attachments

        Activity

          People

            Unassigned Unassigned
            jongo jongo
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.