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")
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: 10.10.10. 5:4567' ) turning message relay requesting off mysql// .sst (20160505 07:18:56.751)
WSREP_SST: [INFO] Waiting for SST streaming to complete! (20160505 07:18:39.076)
160505 7:18:41 [Note] WSREP: (962a755b, 'tcp://
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/
OCF RA debug: 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' mysqld/ mysqld. pid ']' mysqld/ mysqld. sock --connect_ timeout= 10 --user=root --password=root -s -N -e 'select 1;' mysqld/ mysqld. sock' (111 "Connection refused")
+ echo 'ocf-mysql-wss: 2016/05/
+ sleep 2
+ '[' 1 -gt 0 ']'
+ '[' -f /var/run/
++ 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/
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/