Hi,
I am trying to setup a mysql cluster with two machines. Setting up the donor works just as expected, however if I restart mysql on the joiner I do get the following log entry on the donor:
WSREP_SST: [INFO] Logging all stderr of SST/Innobackupex to syslog (20161114 17:21:59.971)
Nov 14 17:21:59 hostname -wsrep-sst-donor: Streaming with xbstream
Nov 14 17:21:59 hostname -wsrep-sst-donor: Using socat as streamer
Nov 14 17:21:59 hostname -wsrep-sst-donor: Using /tmp/tmp.skLia96dpY as innobackupex temporary directory
Nov 14 17:21:59 hostname -wsrep-sst-donor: Streaming GTID file before SST
[COLOR=#FF0000]Nov 14 17:21:59 hostname -wsrep-sst-donor: Evaluating xbstream -c ${INFO_FILE} | socat -u stdio TCP:127.0.0.1:4444; RC=( ${PIPESTATUS[@]} )
Nov 14 17:21:59 hostname -wsrep-sst-donor: 2016/11/14 17:21:59 socat[23738] E connect(12, AF=2 127.0.0.1:4444, 16): Connection refused
Nov 14 17:21:59 hostname -wsrep-sst-donor: Error while getting data from donor node: exit codes: 141 1
Nov 14 17:21:59 hostname -wsrep-sst-donor: Cleanup after exit with status:32
Nov 14 17:21:59 hostname -wsrep-sst-donor: Cleaning up temporary directories
Nov 14 17:21:59 hostname mysqld[16906]: 2016-11-14 17:21:59 139679923865344 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup-v2 --role ‘donor’ --address ‘127.0.0.1:4444/xtrabackup_sst//1’ --socket ‘/var/run/mysqld/mysqld.sock’ --datadir ‘/var/lib/mysql/’ --binlog ‘/var/log/mysql/mariadb-bin’ --gtid ‘3446d879-aa8e-11e6-9f87-ae867f6719f6:0’ --gtid-domain-id ‘0’
Nov 14 17:21:59 hostname mysqld[16906]: 2016-11-14 17:21:59 139679923865344 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup-v2 --role ‘donor’ --address ‘127.0.0.1:4444/xtrabackup_sst//1’ --socket ‘/var/run/mysqld/mysqld.sock’ --datadir ‘/var/lib/mysql/’ --binlog ‘/var/log/mysql/mariadb-bin’ --gtid ‘3446d879-aa8e-11e6-9f87-ae867f6719f6:0’ --gtid-domain-id ‘0’: 32 (Broken pipe)
Nov 14 17:21:59 hostname mysqld[16906]: 2016-11-14 17:21:59 139679923865344 [ERROR] WSREP: Command did not run: wsrep_sst_xtrabackup-v2 --role ‘donor’ --address ‘127.0.0.1:4444/xtrabackup_sst//1’ --socket ‘/var/run/mysqld/mysqld.sock’ --datadir ‘/var/lib/mysql/’ --binlog ‘/var/log/mysql/mariadb-bin’ --gtid ‘3446d879-aa8e-11e6-9f87-ae867f6719f6:0’ --gtid-domain-id ‘0’
Nov 14 17:22:00 hostname mysqld[16906]: 2016-11-14 17:22:00 139680953546496 [Warning] WSREP: 0.0 (hostname): State transfer to 1.0 (mariadb2-stg-aws-eu-west-1b) failed: -32 (Broken pipe)
Nov 14 17:22:00 hostname mysqld[16906]: 2016-11-14 17:22:00 139680953546496 [Note] WSREP: Shifting DONOR/DESYNCED → JOINED (TO: 0)
I am using the xtrabackup-version of the percona repository. However I am not able to proceed behind the log message above.
Any help is greatly appreciated,
Kaj