Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL), 11.6(EOL)
-
None
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
|