Comment 7 for bug 1669323

Revision history for this message
Jericho Rivera (jericho-rivera) wrote :

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.