Unable to Start Second Node

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I am trying to setup Percona cluster, but ran into a issue trying to start the other nodes. When I issue “/etc/init.d/mysql start” the script fails. The error log indicates this as the error message:

2014-06-25 17:38:28 37491 [ERROR] WSREP: gcs/src/gcs_group.c:gcs_group_handle_join_msg():723: Will never receive state. Need to abort.

Anyone have any idea what it means or how to resolve? I initially thought it was due to the wsrep_sst_auth option, but I have that set on all three nodes.

2

I changed wsrep_sst_method=xtrabackup to wsrep_sst_method=xtrabackup-v2 and got a slightly different error message:

2014-06-25 17:54:34 38204 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (bb20590b-fc9e-11e3-94a8-2f6db7a0e599): 1 (Operation not permitted)
at galera/src/replicator_str.cpp:prepare_for_IST():447. IST will be unavailable.
2014-06-25 17:54:34 38204 [Note] WSREP: Member 0.0 (csg1zbecomdbm2) requested state transfer from ‘any’. Selected 1.0 (csg1zbecomdbm1)(SYNCED) as donor.

3

I was able to figure it out. The problem was the port socat was using to perform the transfer; 4444. I added this port to my iptables rules for all my nodes and it worked. Also, on the two secondary nodes I deleted everything in the data directory.