SST step failing for Percona Xtradb Cluster 5.7

Skip to first unread message

Subhajit Saha

Dec 21, 2018, 9:40:10 AM12/21/18
to Percona Discussion
I'm getting below error while trying to join the 2nd node. Please help.

2018-12-21T13:13:01.399496Z 1 [Warning] WSREP: Gap in state sequence. Need state transfer.
2018-12-21T13:13:01.399508Z 1 [Note] WSREP: Setting wsrep_ready to false
2018-12-21T13:13:01.399694Z 0 [Note] WSREP: Initiating SST/IST transfer on JOINER side (wsrep_sst_xtrabackup-v2 --role 'joiner' --address '' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '310' --mysqld-version '5.7.23-23-57'  --binlog '/var/lib/mysql/mysql-bin' )
2018-12-21T13:13:01.400456Z 0 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '310' --mysqld-version '5.7.23-23-57'  --binlog '/var/lib/mysql/mysql-bin'
        Read: '(null)'
2018-12-21T13:13:01.400530Z 0 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '310' --mysqld-version '5.7.23-23-57'  --binlog '/var/lib/mysql/mysql-bin' : 2 (No such file or directory)
2018-12-21T13:13:01.400625Z 1 [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable.
2018-12-21T13:13:01.400649Z 1 [ERROR] Aborting

George Chilumbu

Jan 2, 2019, 10:17:06 PM1/2/19
to Percona Discussion
Your best bet would be to re-install Percona XtraDB on the second node, delete everything in the MySQl datadir, and try ti start the node again to join the PXC.

James Wang

Jan 3, 2019, 4:58:36 AM1/3/19
to Percona Discussion
delete everything in the MySQL datadir and then give rsync a try 
Reply all
Reply to author
0 new messages