search

shakedtom / mycheckpoint

Automatically exported from code.google.com/p/mycheckpoint
0 stars 1 forks source link

Doesn't work with MariaDB 10.0 #47

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Install MySQL 5.5. Install mycheckpoint.
2. Install MariaDB 10.0 over MySQL
3. run mycheckpoint

What is the expected output? What do you see instead?
Getting this error:
(1064, "You have an error in your SQL syntax; check the manual that corresponds 
to your MariaDB server version for the right syntax to use near 'pool(s) load 
completed at 150403  3:44:20, 2002160, 4393, 187680, 8026, 0, 13412' at line 3")

What is the output when running with the "--verbose --debug" options?
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi 
Noach
-- database is mycheckpoint
-- Global status & variables 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 MariaDB server version for the right syntax to use near 'pool(s) load 
completed at 150403  3:44:20, 2001855, 76, 192454, 8192, 0, 1342107' 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 MariaDB server version for the right syntax to 
use near 'pool(s) load completed at 150403  3:44:20, 2001855, 76, 192454, 8192, 
0, 1342107' at line 3")

What version of the mycheckpoint are you using?
231 from RPM

What version of the MySQL are you using? (SELECT VERSION())
10.0.17-MariaDB-log

What version of Python are you using? (python --version)
Python 2.6.6

On what operating system?
CentOS 6

What is your sql_mode? (SELECT @@global.sql_mode)
Got empty value from that query

Please provide any additional information below.

Apparently MariaDB 10 has a few string values in the SHOW STATUS output which 
confuse mycheckpoint. Namely, Innodb_buffer_pool_load_status has this value:
Buffer pool(s) load completed at 150403  3:44:20

mycheckpoint bails out at the processing of this value.

Original issue reported on code.google.com by m...@wourke.com on 3 Apr 2015 at 10:48

GoogleCodeExporter commented 8 years ago 
Sorry - this project is discontinued as indicated on the project main page. Its 
design was not suitable for larger installations and does not meet today's 
requirements.

Original comment by shlomi.n...@gmail.com on 3 Apr 2015 at 11:00