xtrabackup SST netcat "-d" option not available on Debian Squeeze

[Chris Boulton]

When using the xtrabackup SST on a Debian Squeeze based system, the SST will error out with an error similar to the below:
--
120320 2:19:18 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup 'joiner' '192.168.0.2' '' '/var/lib/mysql/' '/etc/mysql/my.cnf' '31891' 2>sst.err: 2 (No such file or directory)
--

sst.err contains the actual error message:
--
~$# cat /var/lib/mysql/sst.err
nc: invalid option -- 'd'
nc -h for help
tar: This does not look like a tar archive
tar: Exiting with failure status due to previous errors
--

A quick look at the man page for nc on Debian Squeeze shows the -d flag does not exist.

(I've removed -d from the SST script, but the transfer still doesn't seem to want to work. Have not investigated why yet)

[Chris Boulton (chris.boulton)]

Looks like netcat on Debian (squeeze - 1.10) also requires the listening port to be specified with -p, instead of just passing it to nc.

I've still not got the xtrabackup SST working, but am still digging.

[Chris Boulton (chris.boulton)]

So it looks like we just need to make sure we're using the OpenBSD version of netcat. Once it's installed and update-alternative'd, SST transfers are happening.

[Chris Boulton (chris.boulton)]

(as in netcat-openbsd on Debian/Ubuntu)

[Ignacio Nin (ignacio-nin)]

Percona-XtraDB-Cluster-server changed to depend on netcat-openbsd in debian and ubuntu. Bug #960569 created to make it compatible with any netcat, which is more desirable.

[guly (guly)]

bzr branch lp:percona-xtradb-cluster two hours ago, bug still present. could you please link the commit?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-941