Comment 16 for bug 1574999

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

So far so better, the "select 1" check isn't working while an xtrabackup-v2 SST is in progress. So the recent patches are still not fixing the race ...

mysql log:
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20160505 07:18:39.076)
160505 7:18:41 [Note] WSREP: (962a755b, 'tcp://10.10.10.5:4567') turning message relay requesting off
160505 7:18:51 [Note] WSREP: 0.0 (n2): State transfer to 3.0 (n4) complete.
160505 7:18:51 [Note] WSREP: Member 0.0 (n2) synced with group.
WSREP_SST: [INFO] NOTE: Joiner-Recv-SST took 17 seconds (20160505 07:18:56.743)
WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (20160505 07:18:56.751)

OCF RA debug:
+ echo 'ocf-mysql-wss: 2016/05/05_07:18:42' 'ERROR: p_mysql: mysql_status(): PIDFile /var/run/mysqld/mysqld.pid of MySQL server not found. Sleeping for 2 seconds. 1 retries left'
+ sleep 2
+ '[' 1 -gt 0 ']'
+ '[' -f /var/run/mysqld/mysqld.pid ']'
++ ps -C mysqld -o pid= -o args=
++ grep /var/lib/mysql
++ awk '!/wsrep.recover/ {print $1}'
+ pid=13258
+ '[' 13258 ']'
+ dummy_test
+ /usr/bin/mysql -S /var/run/mysqld/mysqld.sock --connect_timeout=10 --user=root --password=root -s -N -e 'select 1;'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")