When a Percona MySQL 3.6 node is starting by OCF RA, it may fail to finish an xtrabackup-v2 SST because there is a race condition with accessing and removing the ./ibdata1 file. A logs snippet example:
2016-04-26 07:21:57 5036 [Note] WSREP: Requesting state transfer: success, donor: 3 WSREP_SST: [INFO] Proceeding with SST (20160426 07:21:58.143) WSREP_SST: [INFO] Cleaning the existing datadir (20160426 07:21:58.144) removed '/var/lib/mysql/ib_logfile0' removed '/var/lib/mysql/ib_logfile1' removed '/var/lib/mysql/ibdata1' removed '/var/lib/mysql/backup-my.cnf' removed '/var/lib/mysql/auto.cnf' WSREP_SST: [INFO] Cleaning the binlog directory /var/log/mysql as well (20160426 07:21:58.178) WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20160426 07:21:58.183) 2016-04-26 07:22:00 5036 [Note] WSREP: (8efee881, 'tcp://10.10.10.4:4567') turning message relay requesting off ^Gxbstream: Can't create/write to file './ibdata1' (Errcode: 17 - File exists)
When a Percona MySQL 3.6 node is starting by OCF RA, it may fail to finish an xtrabackup-v2 SST because there is a race condition with accessing and removing the ./ibdata1 file. A logs snippet example:
2016-04-26 07:21:57 5036 [Note] WSREP: Requesting state transfer: success, donor: 3 mysql/ib_ logfile0' mysql/ib_ logfile1' mysql/ibdata1' mysql/backup- my.cnf' mysql/auto. cnf' 4444,reuseaddr stdio | xbstream -x; RC=( ${PIPESTATUS[@]} ) (20160426 07:21:58.183) 10.10.10. 4:4567' ) turning message relay requesting off
WSREP_SST: [INFO] Proceeding with SST (20160426 07:21:58.143)
WSREP_SST: [INFO] Cleaning the existing datadir (20160426 07:21:58.144)
removed '/var/lib/
removed '/var/lib/
removed '/var/lib/
removed '/var/lib/
removed '/var/lib/
WSREP_SST: [INFO] Cleaning the binlog directory /var/log/mysql as well (20160426 07:21:58.178)
WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:
2016-04-26 07:22:00 5036 [Note] WSREP: (8efee881, 'tcp://
^Gxbstream: Can't create/write to file './ibdata1' (Errcode: 17 - File exists)