early-plugin-load=keyring_file.sokeyring_file_data=/var/lib/mysql/keyring
ew ((empty))2020-08-14T09:32:34.194153Z 0 [Note] [MY-000000] [Galera] gcomm: closed2020-08-14T09:32:34.194177Z 0 [Note] [MY-000000] [Galera] Member 0.0 (pxc-cluster-node-2) synced with group.2020-08-14T09:32:34.194192Z 0 [Note] [MY-000000] [Galera] New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 12020-08-14T09:32:34.194224Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [100, 100]2020-08-14T09:32:34.194234Z 0 [Note] [MY-000000] [Galera] Received NON-PRIMARY.2020-08-14T09:32:34.194244Z 0 [Note] [MY-000000] [Galera] Shifting JOINER -> OPEN (TO: 8)2020-08-14T09:32:34.194255Z 0 [Note] [MY-000000] [Galera] New SELF-LEAVE.2020-08-14T09:32:34.194270Z 0 [Note] [MY-000000] [Galera] Flow-control interval: [0, 0]2020-08-14T09:32:34.194279Z 0 [Note] [MY-000000] [Galera] Received SELF-LEAVE. Closing connection.2020-08-14T09:32:34.194289Z 0 [Note] [MY-000000] [Galera] Shifting OPEN -> CLOSED (TO: -1)2020-08-14T09:32:34.194300Z 0 [Note] [MY-000000] [Galera] RECV thread exiting 0: Success2020-08-14T09:34:12.014179Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************2020-08-14T09:34:12.014233Z 0 [ERROR] [MY-000000] [WSREP-SST] Possible timeout in receving first data from donor in gtid/keyring stage2020-08-14T09:34:12.014250Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 11082020-08-14T09:34:12.014266Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************2020-08-14T09:34:12.014348Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:322020-08-14T09:34:12.021357Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep_sst_xtrabackup-v2 --role ‘joiner’ --address ‘192.168.1.129’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib64/mysql/plugin/’ --defaults-file ‘/etc/my.cnf’ --defaults-group-suffix ‘’ --parent ‘18402’ --mysqld-version ‘8.0.19-10’ ‘’ : 32 (Broken pipe)2020-08-14T09:34:12.021388Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script.2020-08-14T09:34:12.021402Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 32 (Broken pipe)2020-08-14T09:34:12.021474Z 3 [Note] [MY-000000] [Galera] Processing SST received2020-08-14T09:34:12.021496Z 3 [Note] [MY-000000] [Galera] SST received: 00000000-0000-0000-0000-000000000000:-12020-08-14T09:34:12.021518Z 3 [System] [MY-000000] [WSREP] SST completed2020-08-14T09:34:12.021549Z 2 [Note] [MY-000000] [Galera] str_proto_ver_: 3 sst_seqno_: -1 cc_seqno: 8 req->ist_len(): 642020-08-14T09:34:12.021576Z 2 [ERROR] [MY-000000] [Galera] Application received wrong state: Received: 00000000-0000-0000-0000-000000000000 Required: 8a0c2dfe-de0b-11ea-9075-7a0902ce80f12020-08-14T09:34:12.021593Z 2 [ERROR] [MY-000000] [Galera] Application state transfer failed. This is unrecoverable condition, restart required.2020-08-14T09:34:12.021610Z 2 [Note] [MY-000000] [Galera] ReplicatorSMM::abort()2020-08-14T09:34:12.021635Z 2 [Note] [MY-000000] [Galera] Closing send monitor…2020-08-14T09:34:12.021653Z 2 [Note] [MY-000000] [Galera] Closed send monitor.2020-08-14T09:34:12.021672Z 2 [Note] [MY-000000] [Galera] recv_thread() joined.2020-08-14T09:34:12.021693Z 2 [Note] [MY-000000] [Galera] Closing replication queue.2020-08-14T09:34:12.021709Z 2 [Note] [MY-000000] [Galera] Closing slave action queue.2020-08-14T09:34:12.021723Z 2 [Note] [MY-000000] [Galera] /usr/sbin/mysqld: Terminated.2020-08-14T09:34:12.021733Z 2 [Note] [MY-000000] [WSREP] Initiating SST cancellation
Can you share full mysql config file? Did you configure SSL parameters or pxc_encrypt_cluster_traffic and initially copied SSL certificates from bootstrapped node to joiner nodes?
[client]socket=/var/lib/mysql/mysql.sockssl-ca=/home/adminuser/srt/ca.pemssl-key=/home/adminuser/srt/client-key.pemssl-cert=/home/adminuser/srt/client-cert.pem
[mysqld]server-id=1datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socklog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid# Binary log expiration period is 604800 seconds, which equals 7 days
binlog_expire_logs_seconds=604800######## wsrep ###############
# Path to Galera librarywsrep_provider=/usr/lib64/galera4/libgalera_smm.so# Cluster connection URL contains IPs of nodes
#If no IP is found, this implies that a new cluster needs to be created,#in order to do that you need to bootstrap this nodewsrep_cluster_address=gcomm://192.168.1.129,192.168.1.157,192.168.1.164# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW# Slave thread to use
wsrep_slave_threads=8wsrep_log_conflicts
# This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2# Node IP address
wsrep_node_address=192.168.1.157# Cluster namewsrep_cluster_name=pxc-cluster#If wsrep_node_name is not specified, then system hostname will be used
wsrep_node_name=pxc-cluster-node-2#pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER
pxc_strict_mode=ENFORCINGwsrep_sst_method=xtrabackup-v2
wsrep_provider_options=”socket.ssl_key=/home/adminuser/srt/server-key.pem;socket.ssl_cert=/home/adminuser/srt/server-cert.pem;socket.ssl_ca=/home/adminuser/srt/ca.pem”
[sst]
encrypt=4ssl-key=/home/adminuser/srt/server-key.pemssl-ca=/home/adminuser/srt/ca.pemssl-cert=/home/adminuser/srt/server-cert.pem
Glad that the suggestion worked!