wsrep_sst_xtrabackup default-file /root/.my.cnf post update

[David Busby]

yum.log:

---
Sep 04 10:33:59 Installed: 1:Percona-XtraDB-Cluster-shared-5.5.24-23.6.340.rhel6.x86_64
Sep 04 10:34:10 Installed: 1:Percona-XtraDB-Cluster-client-5.5.24-23.6.340.rhel6.x86_64
Sep 04 10:34:12 Installed: Percona-XtraDB-Cluster-galera-2.0-1.113.rhel6.x86_64
Sep 04 10:34:20 Installed: 1:Percona-XtraDB-Cluster-server-5.5.24-23.6.340.rhel6.x86_64
Sep 04 11:06:50 Installed: Percona-SQL-shared-compat-5.0.92-b23.85.rhel6.x86_64
Sep 20 13:41:39 Updated: 1:Percona-XtraDB-Cluster-shared-5.5.27-23.6.356.rhel6.x86_64
Sep 20 13:41:49 Updated: Percona-XtraDB-Cluster-galera-2.0-1.114.rhel6.x86_64
Sep 20 13:42:34 Updated: 1:Percona-XtraDB-Cluster-server-5.5.27-23.6.356.rhel6.x86_64
Sep 20 13:42:39 Updated: 1:Percona-XtraDB-Cluster-client-5.5.27-23.6.356.rhel6.x86_64
Nov 19 11:11:37 Updated: 1:Percona-XtraDB-Cluster-shared-5.5.28-23.7.369.rhel6.x86_64
Nov 19 11:11:45 Updated: Percona-XtraDB-Cluster-galera-2.0-1.117.rhel6.x86_64
Nov 19 11:12:26 Updated: 1:Percona-XtraDB-Cluster-server-5.5.28-23.7.369.rhel6.x86_64
Nov 19 11:12:32 Updated: 1:Percona-XtraDB-Cluster-client-5.5.28-23.7.369.rhel6.x86_64
---

Post update to: -5.5.28-23.7.369

.err file on donor
---
121119 11:22:38 [Note] WSREP: Flow-control interval: [23, 23]
121119 11:22:38 [Note] WSREP: New cluster view: global state: 47fb6147-2a3a-11e2-0800-d513010d5a28:62
4223, view# 6: Primary, number of nodes: 2, my index: 0, protocol version 2
121119 11:22:38 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
121119 11:22:38 [Note] WSREP: Assign initial position for certification: 624223, protocol version: 2
121119 11:22:40 [Note] WSREP: Node 1 (nova-2) requested state transfer from '*any*'. Selected 0 (nova
-1)(SYNCED) as donor.
121119 11:22:40 [Note] WSREP: Shifting SYNCED -> DONOR/DESYNCED (TO: 624223)
121119 11:22:40 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
121119 11:22:40 [Note] WSREP: Running: 'wsrep_sst_xtrabackup --role 'donor' --address 'AAA.BBB.CCC.DDD:4444/xtrabackup_sst' --auth '******:******' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/root/.my.cnf' --gtid '47fb6147-2a3a-11e2-0800-d513010d5a28:624223''
121119 11:22:40 [Note] WSREP: sst_donor_thread signaled with 0
WSREP_SST: [ERROR] innobackupex finished with error: 255. Check /var/lib/mysql//innobackup.backup.log (20121119 11:22:42.369)
121119 11:22:42 [ERROR] WSREP: Failed to read from: wsrep_sst_xtrabackup --role 'donor' --address 'AAA.BBB.CCC.DDD:4444/xtrabackup_sst' --auth '******:******' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/root/.my.cnf' --gtid '47fb6147-2a3a-11e2-0800-d513010d5a28:624223'
121119 11:22:42 [ERROR] WSREP: Process completed with error: wsrep_sst_xtrabackup --role 'donor' --address 'AAA.BBB.CCC.DDD:4444/xtrabackup_sst' --auth '******:******' --socket '/var/lib/mysql/mysql.sock' --datadir '/var/lib/mysql/' --defaults-file '/root/.my.cnf' --gtid '47fb6147-2a3a-11e2-0800-d513010d5a28:624223': 22 (Invalid argument)
121119 11:22:42 [Warning] WSREP: 0 (nova-1): State transfer to 1 (nova-2) failed: -1 (Operation not permitted)
---

innobackup.backup.log file on donor post update
---

121119 11:22:40 innobackupex: Starting mysql with options: --defaults-file='/root/.my.cnf' --password=xxxxxxxx --user='******' --socket='/var/lib/mysql/mysql.sock' --unbuffered --
121119 11:22:40 innobackupex: Connected to database with mysql child process (pid=15967)
innobackupex: Error: mysql child process has died: Could not open required defaults file: /root/.my.cnf
Fatal error in defaults handling. Program aborted

---

wsrep_sst_xtrabackup pre update

---
121119 11:12:27 [Note] WSREP: Running: 'wsrep_sst_xtrabackup 'donor' 'AAA.BBB.CCC.DDD:4444/xtrabackup_sst' '******:******' '/var/lib/mysql/' '/etc/my.cnf' '47fb6147-2a3a-11e2-0800-d513010d5a28' '624033' '1''
---

A downgrade is impossible as the .356 packages are no longer available on the repo.

I am presently looking into work arounds, trying to acertain why the defaults-file has changed to /root/.my.cnf over /etc/my.cnf

note wsrep config within my.cnf
---
wsrep_cluster_address=gcomm://AAA.BBB.CCC.DDD
wsrep_provider=/usr/lib64/libgalera_smm.so
wsrep_node_address=AAA.BBB.CCC.DDD
wsrep_sst_receive_address=AAA.BBB.CCC.DDD
wsrep_slave_threads=2
wsrep_cluster_name=XtraDB
wsrep_node_name=NODE-1
wsrep_sst_method=xtrabackup
wsrep_sst_auth=******:******
---

[David Busby (d-busby)]

percona-xtrabackup yum.log
---
Sep 04 10:34:11 Installed: percona-xtrabackup-2.0.2-461.rhel6.x86_64
Oct 08 10:56:30 Updated: percona-xtrabackup-2.0.3-470.rhel6.x86_64
---

Perhaps an issue within this package, as apposed to XtraDB cluster?

[Alex Yurchenko (ayurchen)]

duplicate of lp:1079892