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

Cluster node failed to join primary node when using mysqldump SST

    XMLWordPrintable

Details

    Description

      Cluster node failed to join primary node when using mysqldump SST.

      Also could you please help to resolve mysqldump SST issue. SST is not trigger due to TLS handshake error
      2024-06-13  7:26:21 3 [ERROR] WSREP: Process completed with error: wsrep_sst_mysqldump --address '192.168.100.20:3306' --port '3306' --local-port '3306' --socket '/tmp/mysql.sock' --defaults-file '/home/vagrant/my.cnf' --gtid 'fc49462f-2955-11ef-90a1-e210b77fae52:5,0-1-3' --gtid-domain-id '0' --mysqld-args --defaults-file=/home/vagrant/my.cnf --wsrep-new-cluster: 1 (Operation not permitted)
      2024-06-13  7:26:21 3 [ERROR] WSREP: Try 1/3: 'wsrep_sst_mysqldump --address '192.168.100.20:3306' --port '3306' --local-port '3306' --socket '/tmp/mysql.sock' --defaults-file '/home/vagrant/my.cnf' --gtid 'fc49462f-2955-11ef-90a1-e210b77fae52:5,0-1-3' --gtid-domain-id '0' --mysqld-args --defaults-file=/home/vagrant/my.cnf --wsrep-new-cluster' failed: 1 (Operation not permitted)
      WSREP_SST: [INFO] mysqldump SST started on donor (20240613 07:26:22.674)
      ERROR 2002 (HY000): Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - 
      ERROR 2002 (HY000): Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - 
      ERROR 2002 (HY000): Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - 
      /home/vagrant/mariadb-10.11.8-linux-x86_64//bin/wsrep_sst_mysqldump: line 128: [: -gt: unary operator expected
      ERROR 2002 (HY000): Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      1130 - Received error packet before completion of TLS handshake. The authenticity of the following error cannot be verified:
      

      node1 cnf

      [mariadb]
       
      basedir=/home/vagrant/mariadb-10.11.8-linux-x86_64
      datadir=/home/vagrant/data
      log-warnings                    = 0
      skip-name-resolve
      bind-address                   = 0.0.0.0
       
      # GENERAL #
      socket                         = /tmp/mysql.sock
      pid-file                       = /tmp/mysql.pid
      log-error                      =/home/vagrant/data/mysqld.err
       
      innodb_autoinc_lock_mode = 2
      binlog_format=ROW
      default_storage_engine=InnoDB
       
      wsrep_on=ON
      wsrep_provider=/home/vagrant/mariadb-10.11.8-linux-x86_64/lib/libgalera_smm.so
      wsrep_cluster_address=gcomm://192.168.100.10,192.168.100.20
      #wsrep_sst_method = mariabackup
      wsrep_sst_method=mysqldump
      wsrep_sst_auth = mariabackup:mypassword
       
       
      # Galera Node Configuration
      wsrep_sst_receive_address=192.168.100.10
      wsrep_node_address=192.168.100.10
      wsrep_node_incoming_address=192.168.100.10
      wsrep_node_name="galera-node1"
      wsrep_slave_threads = 8
      wsrep_log_conflicts = 1
      server-id       = 1
      

      Node2 cnf

      [mariadb]
       
      basedir=/home/vagrant/mariadb-10.11.8-linux-x86_64
      datadir=/home/vagrant/data
      log-warnings                    = 0
      skip-name-resolve
      bind-address                   = 0.0.0.0
       
      # GENERAL #
      socket                         = /tmp/mysql.sock
      pid-file                       = /tmp/mysql.pid
      log-error                      = mysqld.err
       
      innodb_autoinc_lock_mode = 2
      binlog_format=ROW
      default_storage_engine=InnoDB
      wsrep_on=ON
      wsrep_provider=/home/vagrant/mariadb-10.11.8-linux-x86_64/lib/libgalera_smm.so
      wsrep_cluster_address=gcomm://192.168.100.10,192.168.100.20
      #wsrep_sst_method = mariabackup
      wsrep_sst_method=mysqldump
      wsrep_sst_auth = mariabackup:mypassword
       
       
      # Galera Node Configuration
      wsrep_sst_receive_address=192.168.100.20
      wsrep_node_address=192.168.100.20
      wsrep_node_incoming_address=192.168.100.20
      wsrep_node_name="galera-node2"
      wsrep_slave_threads = 8
      wsrep_debug = 1
      wsrep_log_conflicts = 1
       
      server-id       = 2
      

      Also fix variable parsing issue in wsrep_sst_mysqldump script

      /home/vagrant/mariadb-10.11.8-linux-x86_64//bin/wsrep_sst_mysqldump: line 128: [: -gt: unary operator expected
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.