Debugging Percona Xtradb (Galera) Cluster node startup / SST errors
We were working on setting up Percona XtraDB (Galera) Cluster following the Documentation for version 5.6+. This blog post is a use-case of a debugging / troubleshooting & fixing different SSTÂ issues we faced while bringing-up the cluster nodes.
We already have a successfully bootstrapped node-1 and now we’re adding second node (node-2) which was causing following error.
"2015-01-15 17:33:19 24618 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'joiner' --address '10.10.10.1' --auth 'sstuser:xxx' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --parent '24618' '' : 32 (Broken pipe) 2015-01-15 17:33:19 24618 [ERROR] WSREP: Failed to read uuid:seqno from joiner script. 2015-01-15 17:33:19 24618 [ERROR] WSREP: SST failed: 32 (Broken pipe) 2015-01-15 17:33:19 24618 [ERROR] Aborting"