# Problem with join second node

**URL:** https://forums.percona.com/t/problem-with-join-second-node/3858
**Category:** Percona XtraDB Cluster 5.x
**Created:** [November 6, 2014, 9:40am UTC](https://forums.percona.com/t/problem-with-join-second-node/3858 "2014-11-06T09:40:08Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![finderom](https://avatars.discourse-cdn.com/v4/letter/f/bb73d2/32.png) [@finderom](https://forums.percona.com/u/finderom)
#### Post date: [November 6, 2014, 9:40am UTC](https://forums.percona.com/t/problem-with-join-second-node/3858/1 "2014-11-06T09:40:08Z")

</div>

on the second node

```auto

...
2014-11-06 18:07:08 31639 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 2,
last_appl. = -1,
protocols = 0/6/3 (gcs/repl/appl),
group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:08 31639 [Note] WSREP: Flow-control interval: [23, 23]
2014-11-06 18:07:08 31639 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 2)
2014-11-06 18:07:08 31639 [Note] WSREP: State transfer required:
Group state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2
Local state: ebf70b75-6598-11e4-a137-bfaf04127fe1:2
2014-11-06 18:07:08 31639 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 2: Primary, number of nodes: 2, my index: 1, protocol version 3
2014-11-06 18:07:08 31639 [Warning] WSREP: Gap in state sequence. Need state transfer.
2014-11-06 18:07:08 31639 [Note] WSREP: Running: 'wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysql/' --defaults-file '
/etc/mysql/my.cnf' --parent '31639' '' '
[B]2014-11-06 18:07:08 31639 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/li
b/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '31639' ''
Read: '(null)'
2014-11-06 18:07:08 31639 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role 'joiner' --address '192.168.1.104' --auth 'sstuser:s3cretPass' --datadir '/var/lib/mysq
l/' --defaults-file '/etc/mysql/my.cnf' --parent '31639' '' : 2 (No such file or directory)[/B]
2014-11-06 18:07:08 31639 [ERROR] WSREP: Failed to prepare for 'xtrabackup-v2' SST. Unrecoverable.
2014-11-06 18:07:08 31639 [ERROR] Aborting

2014-11-06 18:07:10 31639 [Note] WSREP: Closing send monitor...
...

```

on the first donor

```auto
2014-11-06 18:07:04 14322 [Note] WSREP: (2386c901, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers:
2014-11-06 18:07:05 14322 [Note] WSREP: declaring 31bf04dc at tcp://192.168.1.104:4567 stable
2014-11-06 18:07:05 14322 [Note] WSREP: Node 2386c901 state prim
2014-11-06 18:07:05 14322 [Note] WSREP: save pc into disk
2014-11-06 18:07:05 14322 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 2
2014-11-06 18:07:05 14322 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 301ac1d6-65be-11e4-90a5-e21a08d488d0
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: sent state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0 from 0 (UbuntuServer003)
2014-11-06 18:07:05 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 301ac1d6-65be-11e4-90a5-e21a08d488d0 from 1 (UbuntuServer002)
2014-11-06 18:07:05 14322 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 1,
members = 1/2 (joined/total),
act_id = 2,
last_appl. = 0,
protocols = 0/6/3 (gcs/repl/appl),
group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:05 14322 [Note] WSREP: Flow-control interval: [23, 23]
2014-11-06 18:07:05 14322 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 2: Primary, number of nodes:
2, my index: 0, protocol version 3
2014-11-06 18:07:05 14322 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-11-06 18:07:05 14322 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-11-06 18:07:05 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:05 14322 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
2014-11-06 18:07:05 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:08 14322 [Note] WSREP: (2386c901, 'tcp://0.0.0.0:4567') turning message relay requesting off
2014-11-06 18:07:08 14322 [Note] WSREP: forgetting 31bf04dc (tcp://192.168.1.104:4567)
2014-11-06 18:07:08 14322 [Note] WSREP: Node 2386c901 state prim
2014-11-06 18:07:08 14322 [Note] WSREP: save pc into disk
2014-11-06 18:07:08 14322 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2014-11-06 18:07:08 14322 [Note] WSREP: forgetting 31bf04dc (tcp://192.168.1.104:4567)
2014-11-06 18:07:08 14322 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 31e4e5d0-65be-11e4-93e6-de91cc2fe202
2014-11-06 18:07:08 14322 [Note] WSREP: STATE EXCHANGE: sent state msg: 31e4e5d0-65be-11e4-93e6-de91cc2fe202
2014-11-06 18:07:08 14322 [Note] WSREP: STATE EXCHANGE: got state msg: 31e4e5d0-65be-11e4-93e6-de91cc2fe202 from 0 (UbuntuServer003)
2014-11-06 18:07:08 14322 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 2,
members = 1/1 (joined/total),
act_id = 2,
last_appl. = 0,
protocols = 0/6/3 (gcs/repl/appl),
group UUID = 2229ae6f-6595-11e4-8b6c-e71853b84023
2014-11-06 18:07:08 14322 [Note] WSREP: Flow-control interval: [16, 16]
2014-11-06 18:07:08 14322 [Note] WSREP: New cluster view: global state: 2229ae6f-6595-11e4-8b6c-e71853b84023:2, view# 3: Primary, number of nodes:
1, my index: 0, protocol version 3
2014-11-06 18:07:08 14322 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2014-11-06 18:07:08 14322 [Note] WSREP: REPL Protocols: 6 (3, 2)
2014-11-06 18:07:08 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:08 14322 [Note] WSREP: Assign initial position for certification: 2, protocol version: 3
2014-11-06 18:07:08 14322 [Note] WSREP: Service thread queue flushed.
2014-11-06 18:07:13 14322 [Note] WSREP: cleaning up 31bf04dc (tcp://192.168.1.104:4567)

```

---

<div class="post-metadata">

### Author: ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)
#### Post date: [November 10, 2014, 7:58am UTC](https://forums.percona.com/t/problem-with-join-second-node/3858/2 "2014-11-10T07:58:42Z")

</div>

Is /var/lib/mysql/ present on the joiner and having correct ownership? Can you share my.cnf?
