Comment 0 for bug 1574999

Revision history for this message
Bogdan Dobrelya (bogdando) wrote : MySQL may fail to SST because of a ./ibdata1 race condition

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)