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

Failed to add the second node into MariaDB galera-cluster, error info: [ERROR] WSREP: Application received wrong state:

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.7
    • Fix Version/s: 10.3.17
    • Component/s: Galera
    • Labels:
    • Environment:

      Description

      I get strange error when I new a MariaDB-Galera cluster. My environment is Mariadb-10.3.14 and galera3, I build 3 MariaDB instance on one machine.
      Next is the node1 and node2 config (mainly about wsrep)

      wsrep_cluster_address="gcomm://9.128.x.x:23021,9.128.x.x:23022,9.128.x.x:23023"
      #wsrep_cluster_address="gcomm://"
      wsrep_node_address=9.128.x.x:23021
      wsrep_sst_receive_address=9.128.x.x:9021
      innodb_doublewrite=1
      query_cache_size=0
      query_cache_type=0
      wsrep_node_name= node1
      wsrep_sst_auth="willtest:will123"
      binlog_format=row
      default_storage_engine=InnoDB
      innodb_autoinc_lock_mode=2
      wsrep_slave_threads=1
      innodb_flush_log_at_trx_commit=0
      wsrep_sst_method=rsync
      #wsrep_sst_method=xtrabackup
      #wsrep_causal_reads=ON
      wsrep_on=ON
      

      *This is my operation step: *

      for node1: cd /usr/local/mysql/ && ./scripts/mysql_install_db --defaults-file=/etc/my.cnf.25000 --user=mysql
      for node2: cd /usr/local/mysql/ && ./scripts/mysql_install_db --defaults-file=/etc/my.cnf.25000 --user=mysql
      for node1: ./bin/mysqld_safe --defaults-file=/etc/my.cnf.25000  --wsrep-new-cluster  --user=mysql &  
      for node2: ./bin/mysqld_safe --defaults-file=/etc/my.cnf.25001 --user=mysql &  
      

      Node1's status is all right, see annex 1.png
      But when I add node2 and some errors happend, see annex 2.png
      The annex node1.err/node2.err is the error log from instance 25000/25001

      The grastate.dat of node2:

      # GALERA saved state
      version: 2.1
      uuid:    00000000-0000-0000-0000-000000000000
      seqno:   0
      safe_to_bootstrap: 0
      

        Attachments

        1. 1.png
          1.png
          83 kB
        2. 2.png
          2.png
          16 kB
        3. node1.err
          14 kB
        4. node2.err
          12 kB

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            willhan willhan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration