It really looks like connection timed out though:
2017/03/02 09:42:22 socat[73325] E write(3, 0x104f1b0, 8192): Broken pipe 2017-03-02T09:42:22.434796Z 692394 [Note] Aborted connection 692394 to db: 'unconnected' user: 'sstuser' host: 'localhost' (Got an error reading communication packets) WSREP_SST: [ERROR] xtrabackup finished with error: 1. Check /data/mysql//innobackup.backup.log (20170302 09:42:22.436)
And also:
xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe) xb_stream_write_data() failed. xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe) [01] xtrabackup: Error: xtrabackup_copy_datafile() failed. [01] xtrabackup: Error: failed to copy datafile.
And then:
WSREP_SST: [ERROR] Parent mysqld process (PID:88236) terminated unexpectedly. (20170302 09:41:54.098) WSREP_SST: [ERROR] Cleanup after exit with status:32 (20170302 09:41:54.100)
Can you retry starting node2 again for SST, fwiw I've used your mysql wsrep config and it worked for me without editing the systemd file.
I suggest you open a forum post in percona.com/forums and we can continue there. If we really determine that it's a bug we can then confirm this one.
It really looks like connection timed out though:
2017/03/02 09:42:22 socat[73325] E write(3, 0x104f1b0, 8192): Broken pipe 02T09:42: 22.434796Z 692394 [Note] Aborted connection 692394 to db: 'unconnected' user: 'sstuser' host: 'localhost' (Got an error reading communication packets) /innobackup. backup. log (20170302 09:42:22.436)
2017-03-
WSREP_SST: [ERROR] xtrabackup finished with error: 1. Check /data/mysql/
And also:
xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe) write_data( ) failed. copy_datafile( ) failed.
xb_stream_
xtrabackup: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe)
[01] xtrabackup: Error: xtrabackup_
[01] xtrabackup: Error: failed to copy datafile.
And then:
WSREP_SST: [ERROR] Parent mysqld process (PID:88236) terminated unexpectedly. (20170302 09:41:54.098)
WSREP_SST: [ERROR] Cleanup after exit with status:32 (20170302 09:41:54.100)
Can you retry starting node2 again for SST, fwiw I've used your mysql wsrep config and it worked for me without editing the systemd file.
I suggest you open a forum post in percona.com/forums and we can continue there. If we really determine that it's a bug we can then confirm this one.