initial run fails on PXC

[GoogleCodeExporter]

What steps will reproduce the problem?
1. On a Percona Xtra Cluster running centos 6.3, install the rpm
2. Do the initial run

What is the expected output? What do you see instead?
Erros on inserting status variables

What is the output when running with the "--verbose --debug" options?
[SAC][root@ussacpxc-test-cluster-1]:/tmp$ /usr/local/bin/mycheckpoint --verbose 
--debug --defaults-file=/etc/mycheckpoint.cnf
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi 
Noach
-- database is rladmin
-- Global status & variables recorded
-- Master and slave status recorded
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- OS page io activity recorded
(1064, "You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'primary, 
0.000000, 0.000000, 0.000000, 1, 0.000000, 0, 0, 172.20.28.160:3306,172' at 
line 3")
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 5055, in <module>
    collect_status_variables()
  File "/usr/local/bin/mycheckpoint", line 4446, in collect_status_variables
    num_affected_rows = act_query(query)
  File "/usr/local/bin/mycheckpoint", line 254, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near 'primary, 0.000000, 0.000000, 0.000000, 1, 0.000000, 0, 0, 
172.20.28.160:3306,172' at line 3")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--

What version of the mycheckpoint are you using? Happens in both 208 and 231

What version of the MySQL are you using? (SELECT VERSION())
Server version: 5.5.30-log Percona XtraDB Cluster (GPL), wsrep_23.7.4.r3843
What version of Python are you using? (python --version)
Python 2.6.6
On what operating system?
CentOS release 6.3 (Final)
What is your sql_mode? (SELECT @@global.sql_mode)
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

Please provide any additional information below.

I think the issue is the wsrep values in the status_variables table are not 
correct. 

I have attached the wsrep status and variables from my test server.

Allen

Original issue reported on code.google.com by bigji...@gmail.com on 3 Jun 2013 at 5:33

[GoogleCodeExporter]

Allen,

You must be right in your diagnosis. However I do need the SHOW GLOBAL STATUS 
output, it is not attached.

Thanks

Original comment by shlomi.n...@gmail.com on 3 Jun 2013 at 7:34

[GoogleCodeExporter]

Hello, I've the same problem...
could you solve the problem?

Original comment by javjur...@gmail.com on 25 Nov 2014 at 3:58