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

Circular replication breaks after upgrading

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.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            eric@geniqtech.com Eric Ang created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.11 [ 27614 ]
            serg Sergei Golubchik made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ]
            serg Sergei Golubchik made changes -
            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.             		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:
            {noformat}
            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.
            {noformat}
            Rolling back to 10.11.6 resolves the issue.
            janlindstrom Jan Lindström made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            eric@geniqtech.com Eric Ang made changes -
            Attachment mysqld.log [ 73255 ]
            alice Alice Sherepa made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            alice Alice Sherepa made changes -
            eric@geniqtech.com Eric Ang made changes -
            Attachment image-2024-05-20-12-57-53-002.png [ 73517 ]
            eric@geniqtech.com Eric Ang made changes -
            Attachment image-2024-05-20-12-57-53-002.png [ 73517 ]
            eric@geniqtech.com Eric Ang made changes -
            Affects Version/s 10.11.8 [ 29630 ]
            michaeldg Michaël de groot made changes -

            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.