-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
What steps will reproduce the problem?
/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 mycheckpoint
-- 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 '06:15:47, 60, 0,
1, 0, 1, 10, 0, 2, 3, 1, 3145716, 0, 607, 700896, 10566, 0, 1, ' 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 '06:15:47, 60, 0, 1, 0, 1, 10, 0, 2, 3, 1, 3145716, 0, 607, 700896,
10566, 0, 1, ' at line 3")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--
What is the expected output? What do you see instead?
See error above
What is the output when running with the "--verbose --debug" options?
See error above
What version of the mycheckpoint are you using? rev 231, build 201305231510
What version of the MySQL are you using? (SELECT VERSION()) 5.6.12-log
What version of Python are you using? (python --version) Python 2.6.6
On what operating system? Linux
What is your sql_mode? (SELECT @@global.sql_mode) NO_ENGINE_SUBSTITUTION
Please provide any additional information below.
If I change the "is_neglectable_variable" routine as follows it works:
def is_neglectable_variable(variable_name):
if variable_name.startswith("ssl_"):
return True
if variable_name.startswith("ndb_"):
return True
if variable_name == "last_query_cost":
return True
if variable_name == "rpl_status":
return True
if variable_name == "slave_last_heartbeat":
return True
return False
Original issue reported on code.google.com by clive.le...@gmail.com on 31 Jul 2013 at 11:43
Reactions are currently unavailable