search

nvidhive / mycheckpoint

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

delay_key_write is not numeric #22

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. delay_key_write = all
2. mycheckpoint --monitored-host=db-slave --database=mycheckpoint_slave

What is the output when running with the "--verbose --debug" options?

(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 'all, 0, 100, 0, 
300, 1000, 0, 954839, 7, 1, 1, 1024, 4395, 34, 0, 0, 3847, 5205,' at line 3")
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 4861, in <module>
    collect_status_variables()
  File "/usr/local/bin/mycheckpoint", line 4275, in collect_status_variables
    num_affected_rows = act_query(query)
  File "/usr/local/bin/mycheckpoint", line 246, 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 'all, 0, 100, 0, 300, 1000, 0, 954839, 7, 1, 1, 1024, 4395, 34, 0, 0, 
3847, 5205,' at line 3")

What version of the mycheckpoint are you using?

mycheckpoint-208-1.noarch

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

On what operating system?
CentOS Linux release 6.0 (Final)

Please provide any additional information below.

Original issue reported on code.google.com by j.fa...@elevate.nl on 29 Aug 2011 at 9:54

GoogleCodeExporter commented 8 years ago 
OK, seems like I know where the trouble is. I'm just wondering: are you by any 
chance using the "ALL" value for delay_key_write?

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 10:08

GoogleCodeExporter commented 8 years ago 
See step one of "What steps will reproduce the problem?" :P

Original comment by j.fa...@elevate.nl on 30 Aug 2011 at 10:58

GoogleCodeExporter commented 8 years ago 
:P

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 11:11

GoogleCodeExporter commented 8 years ago 
This error occurred because of the accursed way of MySQL to translate "OFF" to 
0, "ON" to 1, etc.
I never set value to "ALL" in this case. I'll do so.

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 11:12

GoogleCodeExporter commented 8 years ago 
This issue was closed by revision r217.

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 11:18

GoogleCodeExporter commented 8 years ago 
Yeah I could totally picture what you were doing with ON and OFF, without 
looking at the code. :)

I have no idea what other variables might have similar problems (ALL or other 
values).

Good luck.

[off topic: even beside this issue, I do get empty graphs (first time I'm 
trying mycheckpoint). I'll try some more and may come back with another issue.]

Original comment by j.fa...@elevate.nl on 30 Aug 2011 at 11:21

GoogleCodeExporter commented 8 years ago 
empty graphs: try again in a couple hours...

Original comment by shlomi.n...@gmail.com on 30 Aug 2011 at 11:50

GoogleCodeExporter commented 8 years ago 
Yeah been a couple of days now. Will have to debug some more when I have time. 
To be continued.

Thanks for this fix. I prefer using rpm files, are those built automatically?

Original comment by j.fa...@elevate.nl on 30 Aug 2011 at 12:04