Not the answer you need?
Register and ask your own question!

Setting up Percona Xtrabackup with MariaDB 10.1 - sync on donor fails

KajKaj EntrantCurrent User Role Beginner
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
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.