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

Circular replication breaks after upgrading

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11.7, 10.11.8
    • 10.11
    • Replication
    • None
    • RockyLinux 8.9

    Description

      We have a circular replication between a 3 node Galera Cluster and a standalone MariaDB node. Replication in both direction was working well in 10.11.6.

      After upgrading to 10.11.7, the following error occur and 1 of the cluster node was automatically removed from the cluster:

      2024-03-06 13:34:19 792 [Note] Slave I/O thread: Start asynchronous replication to master 'repl_user@sunny:3306' in log 'mysql-bin.000302' at position 752714051
      		 
      2024-03-06 13:34:19 793 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000302' at position 752714051, relay log './rezel-relay-bin.000001' position: 4
      		 
      2024-03-06 13:34:19 793 [Note] WSREP: ready state reached
      		 
      2024-03-06 13:34:19 792 [Note] Slave I/O thread: connected to master 'repl_user@sunny:3306',replication started in log 'mysql-bin.000302' at position 752714051
      		 
      2024-03-06 13:34:20 0 [Note] WSREP: Member 2(unicorn) initiates vote on e171100d-322d-11e8-9957-624639ca8561:397983341,cb28eb6c0c3860ee:  Duplicate entry '0-121295558' for key 'PRIMARY', Error_code: 1062;
      		 
      2024-03-06 13:34:20 0 [Note] WSREP: Votes over e171100d-322d-11e8-9957-624639ca8561:397983341:
      		 
         cb28eb6c0c3860ee:   1/3
      		 
      Waiting for more votes.
      		 
      2024-03-06 13:34:20 2 [Note] WSREP: Got vote request for seqno e171100d-322d-11e8-9957-624639ca8561:397983341
      		 
      2024-03-06 13:34:20 0 [Note] WSREP: Member 0(phenex) initiates vote on e171100d-322d-11e8-9957-624639ca8561:397983341,cb28eb6c0c3860ee:  Duplicate entry '0-121295558' for key 'PRIMARY', Error_code: 1062;
      		 
      2024-03-06 13:34:20 0 [Note] WSREP: Votes over e171100d-322d-11e8-9957-624639ca8561:397983341:
      		 
         cb28eb6c0c3860ee:   2/3
      		 
      Winner: cb28eb6c0c3860ee
      		 
      2024-03-06 13:34:20 0 [Note] WSREP: Recovering vote result from history: e171100d-322d-11e8-9957-624639ca8561:397983341,cb28eb6c0c3860ee
      		 
      2024-03-06 13:34:20 2 [ERROR] WSREP: Vote 0 (success) on e171100d-322d-11e8-9957-624639ca8561:397983341 is inconsistent with group. Leaving cluster.

      Rolling back to 10.11.6 resolves the issue.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31905 WSREP GTID MODE is inconsistent

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35447 Multi-layered replication does not work from 10.4 -> 10.11 -> 10.11

          • Major - Major loss of function.
          • Open

          Activity

            People

              janlindstrom Jan Lindström
              eric@geniqtech.com Eric Ang
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.