# Xtradb cluster: WSREP\_SST error **URL:** \ **Category:** Percona XtraDB Cluster 5.x\ **Created:** [May 20, 2015, 9:58am UTC](https://forums.percona.com/t/xtradb-cluster-wsrep-sst-error/4234 "2015-05-20T09:58:29Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sutefu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sutefu/32/1071_2.png) [@sutefu](https://forums.percona.com/u/sutefu)\ **Post date:** [May 20, 2015, 9:58am UTC](https://forums.percona.com/t/xtradb-cluster-wsrep-sst-error/4234/1 "2015-05-20T09:58:29Z")
Hi all, I’m trying to add a new node to my db cluster, and encountering an error I can’t solve. Context: The cluster currently has 3 active servers (nodes: db1, db3, db4) , 1 down with a filesystem issue (db2) I’ve updated db1 and db3 config (new ip in the wsrep\_cluster\_address), but not db4 since it’s under heavy load at the moment (it’s taking db2 load). So I’m trying to add a new node db5 to replace db2 with the following config: [mysqld] log-error = /var/log/mysql.log wsrep\_provider = /usr/lib64/libgalera\_smm.so wsrep\_cluster\_address = gcomm://xxx.xxx.xxx.3,xxx.xxx.xxx.6,xxx.xxx.xxx.7,xxx.xxx. xxx.23,xxx.xxx.xxx.54 binlog\_format = ROW default\_storage\_engine = InnoDB innodb\_autoinc\_lock\_mode = 2 log\_slave\_updates = 1 innodb\_locks\_unsafe\_for\_binlog = 1 innodb\_buffer\_pool\_size = 12G datadir = /db-data/mysql server\_id = 5 sql\_mode = NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES wsrep\_sst\_method = xtrabackup wsrep\_cluster\_name = live\_cluster wsrep\_node\_name = db5 log\_bin = mysql-bin wsrep\_sst\_auth = “user:password” sort\_buffer\_size = 4M join\_buffer\_size = 128M expire\_logs\_days = 7 max\_connections = 200 //Test: tried to specify a donor wsrep\_sst\_donor = db1 An now the error I get when I start the server: […] 2015-05-20 14:59:35 4466 [Note] WSREP: 1.0 (db1): State transfer to 3.0 (db5) complete. 2015-05-20 14:59:35 4466 [Note] WSREP: Member 1.0 (db1) synced with group. WSREP\_SST: [INFO] Preparing the backup at /db-data/mysql/ (20150520 14:59:57.972) WSREP\_SST: [INFO] Evaluating innobackupex --no-version-check --apply-log $rebuildcmd ${DATA} &\>${DATA}/innobackup.prepare.log (20150520 14:59:57.975) WSREP\_SST: [ERROR] Cleanup after exit with status:2 (20150520 14:59:58.231) WSREP\_SST: [INFO] Removing the sst\_in\_progress file (20150520 14:59:58.233) 2015-05-20 14:59:58 4466 [ERROR] WSREP: Process completed with error: wsrep\_sst\_xtrabackup --role ‘joiner’ --address ‘xxx.xxx.xxx.54’ --auth 'user: password --datadir ‘/db-data/mysql/’ --defaults-file ‘/etc/my.cnf’ --parent ‘4466’ ‘’ : 2 (No such file or directory) 2015-05-20 14:59:58 4466 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. 2015-05-20 14:59:58 4466 [ERROR] WSREP: SST failed: 2 (No such file or directory) 2015-05-20 14:59:58 4466 [ERROR] Aborting 2015-05-20 15:00:00 4466 [Note] WSREP: Closing send monitor… 2015-05-20 15:00:00 4466 [Note] WSREP: Closed send monitor. 2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: terminating thread 2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: joining thread 2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: closing backend 2015-05-20 15:00:00 4466 [Note] WSREP: gcomm: closed 2015-05-20 15:00:00 4466 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my\_idx = 0, memb\_num = 1 2015-05-20 15:00:00 4466 [Note] WSREP: Flow-control interval: [16, 16] 2015-05-20 15:00:00 4466 [Note] WSREP: Received NON-PRIMARY. 2015-05-20 15:00:00 4466 [Note] WSREP: Shifting JOINER -\> OPEN (TO: 39533446) 2015-05-20 15:00:00 4466 [Note] WSREP: Received self-leave message. 2015-05-20 15:00:00 4466 [Note] WSREP: Flow-control interval: [0, 0] 2015-05-20 15:00:00 4466 [Note] WSREP: Received SELF-LEAVE. Closing connection. 2015-05-20 15:00:00 4466 [Note] WSREP: Shifting OPEN -\> CLOSED (TO: 39533446) 2015-05-20 15:00:00 4466 [Note] WSREP: RECV thread exiting 0: Success 2015-05-20 15:00:00 4466 [Note] WSREP: recv\_thread() joined. 2015-05-20 15:00:00 4466 [Note] WSREP: Closing replication queue. 2015-05-20 15:00:00 4466 [Note] WSREP: Closing slave action queue. 2015-05-20 15:00:00 4466 [Note] WSREP: Service disconnected. 2015-05-20 15:00:00 4466 [Note] WSREP: rollbacker thread exiting 2015-05-20 15:00:01 4466 [Note] WSREP: Some threads may fail to exit. 2015-05-20 15:00:01 4466 [Note] Binlog end 2015-05-20 15:00:01 4466 [Note] /usr/sbin/mysqld: Shutdown complete Error in my\_thread\_global\_end(): 1 threads didn’t exit 150520 15:00:06 mysqld\_safe mysqld from pid file /db-data/mysql/db5.pid ended Could anyone please give me a hand. Thank you. ​ ---
**Author:** ![umarzuki](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/umarzuki/32/1064_2.png) [@umarzuki](https://forums.percona.com/u/umarzuki)\ **Post date:** [May 20, 2015, 7:53pm UTC](https://forums.percona.com/t/xtradb-cluster-wsrep-sst-error/4234/2 "2015-05-20T19:53:26Z")
“bind-address = IP-db5” ? ---
**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\ **Post date:** [May 21, 2015, 3:51pm UTC](https://forums.percona.com/t/xtradb-cluster-wsrep-sst-error/4234/3 "2015-05-21T15:51:18Z")
change wsrep\_sst\_method to xtrabackup-v2, cleanup /db-data/mysql/\* and then start mysql. see if that works