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

New cluster member leaves cluster when mysql replication started

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.12
    • Fix Version/s: None
    • Component/s: Galera
    • Labels:
      None

      Description

      Hello

      We have hit an issue where a new cluster member will drop from the cluster with a consistency error as soon as mysql asynchronous replication is started on the donor node.
      Another user has hit almost exactly the same problem and documented it here. The difference in our use case is the replication master (Percona XtraDB Cluster 5.7.27) rather than MySQL5.6 and our voting outcome is slightly different:

      2021-10-04 14:05:55 16 [ERROR] Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 42, event_type: -94
      2021-10-04 14:05:55 16 [ERROR] WSREP: applier could not read binlog event, seqno: 245339937, len: 109
      2021-10-04 14:05:55 0 [Note] WSREP: Member 1(new node - joiner) initiates vote on b28cc80b-1483-11ec-80bf-63be0f24e523:245339937,d697ce56d7e540c5:
      2021-10-04 14:05:55 0 [Note] WSREP: Votes over b28cc80b-1483-11ec-80bf-63be0f24e523:245339937:
         d697ce56d7e540c5:   1/2
      Waiting for more votes.
      2021-10-04 14:05:55 0 [Note] WSREP: Member 0(replication slave node - donor) responds to vote on b28cc80b-1483-11ec-80bf-63be0f24e523:245339937,0000000000000000: Success
      2021-10-04 14:05:55 0 [Note] WSREP: Votes over b28cc80b-1483-11ec-80bf-63be0f24e523:245339937:
         0000000000000000:   1/2
         d697ce56d7e540c5:   1/2
      Winner: 0000000000000000
      2021-10-04 14:05:55 16 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on b28cc80b-1483-11ec-80bf-63be0f24e523:245339937
               at /home/buildbot/buildbot/build/galera/src/replicator_smm.cpp:process_apply_error():1343
      

      We can't go into production with MariaDB until this is resolved.

      Thanks
      Justin.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            Justin Bennett Justin Bennett
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration