Percona XtraDB Cluster - HA scalable solution for MySQL

pyclustercheck doesn't work as expected when available when donor is enabled

Reported by Frederic Descamps on 2013-08-12
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraDB Cluster
Undecided
Raghavendra D Prabhu

Bug Description

see https://github.com/Oneiroi/clustercheck/issues/2

When it's started with -a 1 like this:

pyclustercheck -a 1

the result is not ok when the server is donor:

mysql -e "show global status like 'wsrep_local_sta%';"; curl 127.0.0.1:8000
+---------------------------+--------------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------------+
| wsrep_local_state_uuid | 347f0730-fe88-11e2-b09c-4b2817e98824 |
| wsrep_local_state | 2 |
| wsrep_local_state_comment | Donor/Desynced |
+---------------------------+--------------------------------------+
CACHED: Percona XtraDB Cluster Node is not synced

Changing the if condition like bellow (addind int( ) )works:

    elif res[0]['Value'] == '4' or (int(opts.available_when_donor) == 1 and res[0]['Value'] == '2'):

example:

 mysql -e "show global status like 'wsrep_local_sta%';"; curl 127.0.0.1:8000
+---------------------------+--------------------------------------+
| Variable_name | Value |
+---------------------------+--------------------------------------+
| wsrep_local_state_uuid | 347f0730-fe88-11e2-b09c-4b2817e98824 |
| wsrep_local_state | 2 |
| wsrep_local_state_comment | Donor/Desynced |
+---------------------------+--------------------------------------+
Percona XtraDB Cluster Node is synced

Frederic Descamps (lefred) wrote :

#32811

Thanks for reporting, fixed it now.

Changed in percona-xtradb-cluster:
assignee: nobody → Raghavendra D Prabhu (raghavendra-prabhu)
status: New → Triaged
milestone: none → 5.5.33-23.7.6
tags: added: i32811
Changed in percona-xtradb-cluster:
status: Triaged → Fix Committed
Changed in percona-xtradb-cluster:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers