ngonsol / mycheckpoint Goto Github PK

What steps will reproduce the problem?
1. Install 208-1 on Ubuntu
2. /usr/bin/mycheckpoint --defaults-file=/etc/mycheckpoint.cnf 
--skip-check-replication

What is the expected output? What do you see instead?

I get an error:

expected a character buffer object
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--


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

root@mysql:~# /usr/bin/mycheckpoint --defaults-file=/etc/mycheckpoint.cnf 
--skip-check-replication --debug
expected a character buffer object
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 4864, in <module>
    write_status_variables_hour_aggregation(status_variables_insert_timestamp)
  File "/usr/bin/mycheckpoint", line 4322, in write_status_variables_hour_aggregation
    query = query.replace("${aggregation_timestamp}", aggregation_timestamp)
TypeError: expected a character buffer object
--
-- Re-execute with --verbose --debug for detailed message and strack trace.


What version of the mycheckpoint are you using?

208-1 (deb - form Ubuntu)

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

5.1.57-rel12.8-log 

On what operating system?


Please provide any additional information below.

Ubuntu Linux
Linux mysql 2.6.32-30-server #59-Ubuntu SMP Tue Mar 1 22:46:09 UTC 2011 x86_64 
GNU/Linux


many thanks for any help here in advance,



Niels.

Syndicat IT & Internet
http://www.syndicat.com

What steps will reproduce the problem?
1. Use a different monitoring host then write host
2. Run mycheckpoint <parameters> -v
3. Mysql-problem: (1146, "Table 'mycheckpoint.custom_query_view' doesn't exist")

What is the expected output? Full creation of 58 tables in database 
mycheckpoint_HOST
What do you see instead? Only 5 tables are created, python script stops after 
that one.

What version of the mycheckpoint are you using? revision 174
What version of the MySQL are you using?  5.1.37
On what operating system? SLES 11

I think the problem is the use of the wrong connection-parameter in the 
get_rows call (no connection is defined so it uses the monitor-connection. For 
this query, it should use the write_conn instead). Problem was fixed when 
replacing:
query = """SELECT custom_query_id, chart_name FROM %s.custom_query_view""" % 
database_name
rows = get_rows(query) 
with:
query = """SELECT custom_query_id, chart_name FROM %s.custom_query_view""" % 
database_name
rows = get_rows(query,write_conn)

Also, I think it is strange that no parameters can be defined for the user and 
password on the monitored mysql database. Now it needs to be the same one of 
both servers...

mycheckpoint --verbose --debug deploy

-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
(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 'OR REPLACE\n     
   ALGORITHM = TEMPTABLE\n        DEFINER = CURRENT_USER\n        ' at line 2")



What version of the mycheckpoint are you using?
208
What version of the MySQL are you using? (SELECT VERSION())
4.1.22
On what operating system?
Red Hat Enterprise Linux Server release 5.3 (Tikanga)


Please provide any additional information below.

Can improve this tool to support mysql 4.X ?

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

I'm sure I'm not the only one that has a monitoring specific server that 
everything funnels down to. This causes the OS graphs to be entirely blank. It 
would be handy to be able to disable rendering them entirely from the UI.

Hi,

Again, I'm filing here in the absence of a mailing list - is there an IRC room 
or something that I could use instead?

I'm after a guide to writing custom reports.  I've got a number of servers that 
will (hopefully!) be reporting into a central server (see issue 13) and I want 
to create a report that only shows certain metrics but for multiple servers on 
the same page.

Is there a way of integrating the system_report queries into custom reports?

Thanks,

Matt

As discussed: 

I'd like to be able to pull data from one source and insert/log to another, in 
order to facilitate 
centralized storage for the historical data. 

Using different schemas would work great, as long as there's something like 
--source-host and --
target-host (same for credentials etc as well of course) 

This is a feature request. 

What steps will reproduce the problem?
1. Shutdown mysqld
2. tty 1: ncat -l dev-gnt-2.int.linuxvoid.org 3306
3. tty 2: time mycheckpoint --host=sysserver1.int.linuxvoid.org 
--monitored-host=dev-gnt-2.int.linuxvoid.org --database=mycheckpoint_devgnt2 -v

What is the expected output? What do you see instead?
Time-out expected within 1 or 2 minutes. But it runs to infinity and back.


What is the output when running with the "--verbose --debug" options?
On ^C in ncat:
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint_devgnt2
-- monitored host is: dev-gnt-2.int.dirkzwager.com
-- monitored host credentials undefined; using write host credentials
-- ERROR: Cannot connect to database
-- Sending cannot access message from [email protected] 
to: [email protected] via: smtp.int.dirkzwager.com
-- + Sent
(2013, "Lost connection to MySQL server at 'reading initial communication 
packet', system error: 0")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--

real    65m3.434s
user    0m0.100s
sys     0m0.000s


On ^C in mycheckpoint followed by ^C in ncat:
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint_devgnt2
-- monitored host is: dev-gnt-2.int.dirkzwager.com
-- monitored host credentials undefined; using write host credentials
^C
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 4845, in <module>
    monitored_conn, write_conn = open_connections()
KeyboardInterrupt

real    0m10.904s
user    0m0.100s
sys     0m0.000s


What version of the mycheckpoint are you using?
rev. 208

What version of the MySQL are you using? (SELECT VERSION())
mysql  Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (x86_64) using readline 5.1

On what operating system?
Linux dev-gnt-2 2.6.34-gentoo-r6 #1 SMP Tue Sep 28 10:16:39 CEST 2010 x86_64 
Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz GenuineIntel GNU/Linux


Please provide any additional information below.
As requested in issue 23.

What steps will reproduce the problem?
1. Install with maria 5.5.22 Ubuntu 11.04
2.
3.

What is the expected output? What do you see instead?

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

(1060, "Duplicate column name 'handler_icp_attempts'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--
root@aqua:/opt/Suneese/utilities/housekeeping# /usr/local/bin/mycheckpoint 
--debug --verbose --defaults-file=/root/.my-checkpoint.cnf
-- Using /root/.my-checkpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- Global status & variables recorded
-- Master and slave status recorded
-- Non-local monitoring; will not read OS data
-- status_variables table exists
-- Will add the following columns to status_variables: handler_icp_attempts
(1060, "Duplicate column name 'handler_icp_attempts'")
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 4854, in <module>
    deploy_schema()
  File "/usr/local/bin/mycheckpoint", line 4763, in deploy_schema
    upgrade_status_variables_table()
  File "/usr/local/bin/mycheckpoint", line 1926, in upgrade_status_variables_table
    act_query(query)
  File "/usr/local/bin/mycheckpoint", line 246, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1060, "Duplicate column name 'handler_icp_attempts'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--

What version of the mycheckpoint are you using? 308
What version of the MySQL are you using? (SELECT VERSION()) maria 5.5.22
On what operating system? Ubuntu 11.04


Please provide any additional information below.

From our email thread, this is a tracking ticket for creating custom charts of 
multiple metrics.

Some thoughts:

If code is the easiest way, perhaps supporting 'plugins' that define the 
charts? Place a .py file with a chart define in /etc/mycheckpoint/charts and 
have it load them and create the chart that is defined in the .py file?

Looking at the code, it seems pretty simple to define graphs, so perhaps they 
don't even need to be .py files.

Thoughts?

Background:
I installed mycheckpoint couple months ago, it worked very well on 5.1.42. 
Recently I upgraded to MySQL 5.5.13, and 'mycheckpiont' collapsed.  

What is the expected output? What do you see instead?
-- See below the error...
What is the output when running with the "--verbose --debug" options?
---------------
[root@dbh1 ~]# mycheckpoint -uroot -pxxxxxxxxx --skip-disable-bin-log 
--skip-check-replication --socket=/var/lib/mysql/mysql.sock --verbose --debug
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 22, in ?
    import MySQLdb
  File "/usr/lib64/python2.4/site-packages/MySQLdb/__init__.py", line 19, in ?
    import _mysql
ImportError: libmysqlclient_r.so.15: cannot open shared object file: No such 
file or directory


-------------
What version of the mycheckpoint are you using?
-- 208
What version of the MySQL are you using? (SELECT VERSION())
-- 5.5.13
On what operating system?
-- Red Hat Enterprise Linux Server release 5.5 (Tikanga)


Please provide any additional information below.

Thanks,
[email protected]

I'm having issues trying remote monitoring to work either in r174 or r190.

I'm trying a basic setup, 2 production databases and one monitoring database 
which would store the various monitorings.

Either cases 1 or 2 of the manual didn't work for me (from monitored to 
monitoring, or from monitoring to monitored).

use case 1. from the production database (sql1) to the monitoring database 
(sql-monitor).

[root@sql1 mycheckpoint-190]# mycheckpoint --host=sql-monitor --user=dbmonitor 
--password=mypassword --port=3306 --monitored-host=localhost 
--monitored-socket=/var/lib/mysql/mysql.sock --database=mycheckpoint_sql1 
--skip-defaults -v --debug
-- mycheckpoint rev 190, build 201009020925. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint_sql1
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- 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
-- New entry added
-- Collecting custom data
(1146, "Table 'mycheckpoint_sql1.custom_query' doesn't exist")
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 4407, in ?
    collect_custom_data()
  File "/usr/bin/mycheckpoint", line 1291, in collect_custom_data
    for custom_query in get_rows(query):
  File "/usr/bin/mycheckpoint", line 306, in get_rows
    cursor.execute(query)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'mycheckpoint_sql1.custom_query' doesn't exist")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last 
install/update.upgrade
--  If not, run again with same configuration, and add 'deploy'. e.g.:
--  mycheckpoint --host=my_host deploy

If I check, the given table is existing on sql-monitor, though empty:
mysql> select * from mycheckpoint_sql1.custom_query;
Empty set (0.00 sec)

If I skip-custom, I get same error but on different table:
ProgrammingError: (1146, "Table 'mycheckpoint_sql1.alert_condition' doesn't 
exist")

From my point of view, looks like mycheckpoint is trying to do 
custom_collect_data() on localhost, hence the table not existing.

Eventually, it worked with both --skip-custom and --skip-alerts parameters.

Also I had some issues while the prod used r174 and the schema was r190. Maybe 
a warning could be in order like something saying that the client version is 
inferior to the server (I don't know if you store the version number somewhere 
in the database, but it could definitely be a plus!)

Thanks in advance, cause I'd really like to have the alert feature back up!

G.

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.

What is the feature request?
Currently myCheckPoint documentation explain that we can generate parameter 
change tracking report as a simple query "SELECT * FROM sv_param_change;" who 
generate a one row sql result. Documentation show us a formatted result :
+---------------------+-----------------+-----------+-----------+
| ts                  | variable_name   | old_value | new_value |
+---------------------+-----------------+-----------+-----------+
| 2009-11-04 13:00:01 | max_connections |       500 |       200 |
+---------------------+-----------------+-----------+-----------+

In real case, this query ran from command line given us a flat result like this:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM 
sv_param_change" --silent > paramchange.html
  ts      variable_name   old_value       new_value
  2012-06-18 11:35:01     max_connections 200     100

Redirecting this result to a file isn't exploitable as human report easily.

Solution: In documentation, insert following code to explain how to export 
directly result to html code:
> mysql -umycheckpoint -pmycheckpoint dbname --execute="SELECT * FROM 
sv_param_change" --silent --html > paramchange.html
<TABLE 
BORDER=1><TR><TH>ts</TH><TH>variable_name</TH><TH>old_value</TH><TH>new_value</T
H></TR><TR><TD>2012-06-18 
11:35:01</TD><TD>max_connections</TD><TD>200</TD><TD>100</TD></TR></TABLE>


How will this change current behavior?
Just export result formated in html code


What parameters/options will be required?
--html in mysql command line


What version of the mycheckpoint are you using?
r223


What version of the MySQL are you using?
5.5.16-log


On what operating system?
Linux RedHat 5 Enterprise


Thanks

What steps will reproduce the problem?
1.running mycheckpoint http
2.when open url in browser ,report error:

Exception happened during processing of request from ('172.16.153.1', 52752)
Traceback (most recent call last):
  File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
    self.process_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
    self.finish_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
    self.handle()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
    self.handle_one_request()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
    method()
  File "/usr/bin/mycheckpoint", line 4238, in do_GET
    html = http_embed_code(html, '<div class="header">', html_embed)
  File "/usr/bin/mycheckpoint", line 4186, in http_embed_code
    html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'

mycheckpoint revsion 192
rhel 5.4
mysql-pyhon 1.2.1-1
python2.4
mysql 5.1.48

What steps will reproduce the problem?
1. Just launch mycheckpoint

What is the expected output? What do you see instead?
Expected : "New entry added"
See instead : (1054, "Unknown column 'mysql' in 'field list'")

What is the output when running with the "--verbose --debug" options?
-- Using /etc/mycheckpoint.conf as defaults file
-- mycheckpoint rev 231, build 201305231510. Copyright (c) 2009-2013 by Shlomi 
Noach
-- database is mycheckpoint_test_sd_03
-- monitored host is: 127.0.0.1
-- 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
(1054, "Unknown column 'mysql' in 'field list'")
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/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'mysql' in 'field list'")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--

What version of the mycheckpoint are you using?
mycheckpoint rev 231, build 201305231510

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

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

On what operating system?
DEBIAN 6.0.7

What is your sql_mode? (SELECT @@global.sql_mode)
Empty

What steps will reproduce the problem?
1.Rhel5
2.mysql  Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using
readline 5.0
3.Config file
[client]
host=localhost
socket=/var/lib/mysql/mysql.sock
user=root
password=<>
port=3306


What is the expected output? What do you see instead?
Deploy...

ericfe@[root]~/rds-work>mycheckpoint --defaults=./mycheckpoint.defaults -v
deploy
-- mycheckpoint rev 119, build 201003300820. Copyright (c) 2009-2010 by
Shlomi Noach
-- database is mycheckpoint
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- 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
-- status_variables table exists
-- Will add the following columns to status_variables: custom_16, custom_17
-- status_variables table upgraded
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report custom views created
-- 24/7 report view created
-- recent reports views created
(2013, 'Lost connection to MySQL server during query')
--
-- Make sure `mycheckpoint` schema exists, e.g.
--   CREATE DATABASE `mycheckpoint`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint` schema. e.g.
--   GRANT ALL ON `mycheckpoint`.* TO 'my_user'@'my_host' IDENTIFIED BY
'my_password'
-- The user will have to have the SUPER privilege in order to disable
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves
replicate this server's status)
-- In order to read master and slave status, the user must also be granted
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication


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

What version of the mycheckpoint are you using? 119
What version of the MySQL are you using? (SELECT VERSION())
mysql  Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (i686) using readline 5.0

On what operating system?
rhel 5

What steps will reproduce the problem?
1. mycheckpoint [...] deploy

What is the expected output? What do you see instead?
-- mycheckpoint. Copyright (c) 2009 by Shlomi Noach
-- numbers table created
-- charts_api table created
-- status_variables table exists
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report custom views created
-- recent reports views created
-- recent reports minmax views created
-- report_human custom views created
(1140, 'Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP 
columns is illegal if there is no GROUP BY clause')
--
-- Make sure `mycheckpoint` schema exists, e.g.
--   CREATE DATABASE `mycheckpoint`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint` schema. e.g.
--   GRANT ALL ON `mycheckpoint`.* TO 'my_user'@'my_host' IDENTIFIED BY 
'my_password'
-- The user will have to have the SUPER privilege in order to disable 
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves 
replicate this server's status)
-- In order to read master and slave status, the user must also be granted 
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication
--


What version of the product are you using? On what operating system?
Latest Debian package and svn's trunk have both the issue. OS: Debian Linux 
/ stable

Please provide any additional information below.

What steps will reproduce the problem?
1. Put ONLY_FULL_GROUP_BY in sql_mode variable in my.ini ([mysqld] section)
2. Restart MySQL server
3. Run mycheckpoint


What is the expected output? What do you see instead?
Regular run messages, no error


What is the output when running with the "--verbose --debug" options?
[dba@frlusv112 ~]$ ./mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 
--user=mycheckpoint --password=mycheckpoint --database=mcp_webprod 
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock --verbose --debug 
--rebuild-aggregation
-- mycheckpoint rev 0, build 0. Copyright (c) 2009-2010 by Shlomi Noach
-- database is mcp_webprod
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- 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
-- New entry added: id=7; ts=2012-06-12 15:05:43
-- Collecting custom data
(1055, "'mcp_webprod.status_variables2.ts' isn't in GROUP BY")
Traceback (most recent call last):
  File "./mycheckpoint_r223.py", line 4960, in ?
    write_status_variables_hour_aggregation(status_variables_insert_timestamp)
  File "./mycheckpoint_r223.py", line 4404, in write_status_variables_hour_aggregation
    num_affected_rows = act_query(query)
  File "./mycheckpoint_r223.py", line 247, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1055, "'mcp_webprod.status_variables2.ts' isn't in GROUP BY")
--
-- Re-execute with --verbose --debug for detailed message and stack trace.
--


What version of the mycheckpoint are you using?
r223


What version of the MySQL are you using? (SELECT VERSION())
mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.16-log |
+------------+
1 row in set (0.00 sec)


What version of Python are you using? (python --version)
[dba@frlusv112 ~]$ python -V
Python 2.4.3


On what operating system?
Linux RedHat 5 Enterprise

Please provide any additional information below.


Thanks

What is the feature request?

custom_query.custom_query_id should be an auto increment. This would make it 
easier to add custom_queries to a set of different hosts.

How will this change current behavior?

Remove the need to calculate the value by hand

What parameters/options will be required?

ALTER TABLE custom_query MODIFY custom_query_id int(10) unsigned NOT NULL 
auto_increment;

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.

What steps will reproduce the problem?
1.
/usr/local/skysql/mycheckpoint/bin/mycheckpoint -o  --database=mon_node10 
--monitored-user=root --monitored-password=skyvodka 
--monitored-socket=/tmp/mysql_sandbox5010.sock --user=skysql 
--password=skyvodka --host="10.0.0.102" --port=5010  --disable-bin-log 
--purge-days=1

2.
3.

What is the expected output? What do you see instead?

SQL Error 


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


What version of the mycheckpoint are you using?
8.4
What version of the MySQL are you using? (SELECT VERSION())
What version of Python are you using? (python --version)
On what operating system?
What is your sql_mode? (SELECT @@global.sql_mode)


Please provide any additional information below.


It is required that the connection is free of transaction.
commit the connection fixe the issue or just move disable bin log before the 
first query 
    SELECT COUNT(*) AS same_deploy 
            FROM mon_node10.metadata 
            WHERE 
              revision = 208 
              AND build = 201011041330 
              AND mysql_version = '5.5.28a-MariaDB-log'
              AND database_name = 'mon_node10'
              AND custom_queries = (SELECT IFNULL(GROUP_CONCAT(custom_query_id ORDER BY chart_order, custom_query_id SEPARATOR ','), '') FROM mon_node10.custom_query)
              AND last_deploy_successful = 1

Good work 

What steps will reproduce the problem?
1. Install on a system where InnoDB Storage engine is not installed/running

What is the expected output? What do you see instead?
Unable to install, "deploy" throws error

What is the output when running with the "--verbose --debug" options?
[root@m-sysmon2 bin]# mycheckpoint-119
--monitored-host=sbk-sysmon1.production.bigcharts.com
--defaults-file=/usr/share/mycheckpoint/.my-checkpoint.cnf
--database=mycheckpoint_sbk deploy -v --debug
-- mycheckpoint rev 119, build 201003300820. Copyright (c) 2009-2010 by
Shlomi Noach
-- database is mycheckpoint_sbk
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Master and slave status recorded
-- Non-local monitoring; will not read OS data
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
(1054, "Unknown column 'innodb_buffer_pool_pages_free' in 'field list'")
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint-119", line 3235, in <module>
    deploy_schema()
  File "/usr/bin/mycheckpoint-119", line 3149, in deploy_schema
    create_status_variables_views()
  File "/usr/bin/mycheckpoint-119", line 2843, in create_status_variables_views
    """)
  File "/usr/bin/mycheckpoint-119", line 2711, in create_custom_views
    act_query(custom_query)
  File "/usr/bin/mycheckpoint-119", line 143, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib/python2.6/site-packages/MySQLdb/cursors.py", line 173, in
execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.6/site-packages/MySQLdb/connections.py", line 36,
in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'innodb_buffer_pool_pages_free' in
'field list'")
--
-- Make sure `mycheckpoint_sbk` schema exists, e.g.
--   CREATE DATABASE `mycheckpoint_sbk`
-- Make sure the user has ALL PRIVILEGES on the `mycheckpoint_sbk` schema. e.g.
--   GRANT ALL ON `mycheckpoint_sbk`.* TO 'my_user'@'my_host' IDENTIFIED BY
'my_password'
-- The user will have to have the SUPER privilege in order to disable
binary logging
-- - Otherwise, use --skip-disable-bin-log (but then be aware that slaves
replicate this server's status)
-- In order to read master and slave status, the user must also be granted
with REPLICATION CLIENT or SUPER privileges
-- - Otherwise, use --skip-check-replication
--
[root@m-sysmon2 bin]#


What version of the mycheckpoint are you using? 88,118,119
What version of the MySQL are you using? 5.1.37-community-log
On what operating system? Script running on 2.6.30.9-96.fc11.i686.PAE
Remote hosts are Win2003 R2 x86 w/ SP2


Please provide any additional information below.
If I comment out all the INnoDB references i can install, but using new
versions it's a pain :|

mycheckpoint mails appear in one's client as having been sent the moment they 
are fetched from server, as opposed to presenting the actual time at which they 
have been sent.
So a mail client waking up after a couple days may present a dozen alert mails 
as though all have been sent just now.

What steps will reproduce the problem?
1. run mysqlcheckpoint against MySQL 5.5.4
2.
3.

What is the expected output? What do you see instead?


Output received:
mycheckpoint --verbose --skip-check-replication
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 170, build 201007152036. Copyright (c) 2009-2010 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
(1054, "Unknown column 'auto' in 'field list'")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last 
install/update.upgrade
--  If not, run again with same configuration, and add 'deploy'. e.g.:
--  mycheckpoint --host=my_host deploy
--





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


What version of the mycheckpoint are you using?

rev 170, build 201007152036

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

5.5.4-m3-log

On what operating system?

Linux - Debian


Please provide any additional information below.

mysql> SHOW GLOBAL VARIABLES LIKE 'concurrent_insert';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| concurrent_insert | AUTO  |
+-------------------+-------+
1 row in set (0.00 sec)

In MySQL 5.0 and 5.1 concurrent_insert accepts value 0, 1 or 2.
In MySQL 5.5 also the values NEVER and AUTO are valid.

The insert on mycheckpoint.status_variables looks like :
INSERT INTO status_variables (......) VALUES ( .... , auto , .....)
Resulting in an error.

Fix:

 diff mycheckpoint mycheckpoint.orig 
4078c4078
<     variable_values = ", ".join(["'%s'" % status_dict[column_name] for 
column_name in sorted_list(status_dict.keys())])

---
>     variable_values = ", ".join(["%s" % status_dict[column_name] for 
column_name in sorted_list(status_dict.keys())])

After installing mycheckpoint, creating mycheckpoint schema and granting 
privileges, mycheckpoint is not recording any data. All tables are created, but 
remain empty. Any idea what I am missing here?

Output with -v --debug:
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- 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
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
-- status_variables_aggregated_day table exists
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
(1054, "Unknown column 'innodb_rows_read_psec' in 'field list'")
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 4854, in ?
    deploy_schema()
  File "/usr/bin/mycheckpoint", line 4767, in deploy_schema
    create_status_variables_views_and_aggregations()
  File "/usr/bin/mycheckpoint", line 3864, in create_status_variables_views_and_aggregations
    create_report_views("""
  File "/usr/bin/mycheckpoint", line 3842, in create_report_views
    act_query(custom_query)
  File "/usr/bin/mycheckpoint", line 246, in act_query
    num_affected_rows = cursor.execute(query)
  File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in execute
  File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
OperationalError: (1054, "Unknown column 'innodb_rows_read_psec' in 'field 
list'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--

Additional information:
OS: Centos 5.6
Mycheckpoint version: 208
MySQL version: 5.1.57
Python version: 2.4.3
MySQL-python: 1.2.3

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

Hi,

I can't find a mailing list so I thought I'd file a bug! :)

I'm trying to configure MyCheckpoint to talk to a master MySQL server from 
about 100 nodes across various datacentres.

The links are already in place (we're using them for replication) however I 
can't get MyCheckpoint to use a "read_only" user to connect to the clients and 
send the reports using a different user to the master.

Is this possible?

I'm hoping that there might be a way of adding something such as the following 
to the config file:

[server]
host=<master_host_name>
port=<master_host_port>
database=<master_host_database>
user=<user_with_write_privs_on_master>
pass=<password_for_above_user>

I'm also interested in knowing if I can have all clients write to the same 
database on the master (I'm not keen on the idea of having to maintain 100 
databases and then writing the reports for each server!)

Thanks in advance,

Matt

As stated in the release notes:
"
mycheckpoint now has a version recognition mechanism. There is no need to call 
mycheckpoint 
with the “deploy” argument on first install or after upgrade. mycheckpoint 
will recognize a 
change of version and will auto-deploy before moving on to monitoring your 
system."

This is great, although I don't quite like how it is so verbose. 
Perhaps avoid printing out that the table doesn't exist (i.e.: 

/usr/bin/mycheckpoint:109: Warning: Unknown table 'metadata'
  num_affected_rows = cursor.execute(query)

)

This is of course from the DROP TABLE IF EXISTS..  Perhaps a create table if 
not exists instead? 
Or do I have the wrong idea and you prefer having verbose output as default? 

What steps will reproduce the problem?

1. FreeBSD 8.0
2. MySQL 5.3.2
3. mycheckpoint rev 132, build 201006041210

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

 from sets import ImmutableSet
-- mycheckpoint rev 132, build 201006041210. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Cannot read /proc/stat. Skipping
-- Cannot read /proc/loadavg. Skipping
-- Cannot read /proc/meminfo. Skipping
-- OS mountpoints info recorded
-- status_variables table created
-- custom_query table created
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report views created
-- 24/7 report view created
-- recent reports views created
-- sv_report_sample_recent_aggregated view created
-- reports minmax views created
-- report human views created
-- sv_report_chart_sample_timeseries view created
-- sv_report_chart_hour_timeseries view created
-- sv_report_chart_day_timeseries view created
-- report charts labels views created
-- dycharts views created
(1271, "Illegal mix of collations for operation 'concat'")
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 3670, in <module>
    deploy_schema()
  File "/usr/local/bin/mycheckpoint", line 3584, in deploy_schema
    create_status_variables_views()
  File "/usr/local/bin/mycheckpoint", line 3327, in create_status_variables_views
    create_report_google_chart_views(report_chart_views)
  File "/usr/local/bin/mycheckpoint", line 2332, in 
create_report_google_chart_views
    act_query(query)
  File "/usr/local/bin/mycheckpoint", line 147, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/local/lib/python2.6/site-packages/MySQLdb/cursors.py", line 166, in 
execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.6/site-packages/MySQLdb/connections.py", line 35, 
in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1271, "Illegal mix of collations for operation 'concat'")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last 
install/update.upgrade
--  If not, run again with same configuration, and add 'deploy'. e.g.:
--  mycheckpoint --host=my_host deploy
--

What steps will reproduce the problem?
1. [myuser@mycomputer ~]$ mycheckpoint --host=centralserver --port=3306 
--user=mycheckpoint --password=mycheckpoint --database=mcp_centralserver 
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock
(1146, "Table 'mcp_webprod.status_variables_aggregated_hour' doesn't exist")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--

2. In mysql database we can find 13 just created tables :
mysql> show tables;
+-----------------------+
| Tables_in_mcp_webprod |
+-----------------------+
| alert                 |
| alert_condition       |
| alert_pending         |
| charts_api            |
| custom_query          |
| custom_query_view     |
| html_components       |
| metadata              |
| numbers               |
| status_variables      |
| sv_diff               |
| sv_latest             |
| sv_sample             |
+-----------------------+
13 rows in set (0.01 sec)

3.

What is the expected output? What do you see instead?

What is the output when running with the "--verbose --debug" options?
1. [myuser@mycomputer ~]$ mycheckpoint --host=centralserver --port=3306 
--user=mycheckpoint --password=mycheckpoint --database=mcp_centralserver 
--monitored-host=localhost --monitored-socket=/tmp/mysql.sock --verbose --debug
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mcp_centralserver
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- 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
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
(1146, "Table 'mcp_centralserver.status_variables_aggregated_hour' doesn't 
exist")
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 4854, in ?
    deploy_schema()
  File "/usr/local/bin/mycheckpoint", line 4767, in deploy_schema
    create_status_variables_views_and_aggregations()
  File "/usr/local/bin/mycheckpoint", line 3856, in create_status_variables_views_and_aggregations
    upgrade_status_variables_hour_aggregation_table()
  File "/usr/local/bin/mycheckpoint", line 1968, in upgrade_status_variables_hour_aggregation_table
    return upgrade_status_variables_aggregation_table("status_variables_aggregated_hour")
  File "/usr/local/bin/mycheckpoint", line 1941, in upgrade_status_variables_aggregation_table
    existing_columns = [row["Field"] for row in get_rows(query, write_conn)]
  File "/usr/local/bin/mycheckpoint", line 267, in get_rows
    cursor.execute(query)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 
'mcp_centralserver.status_variables_aggregated_hour' doesn't exist")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.
--


What version of the mycheckpoint are you using?
mycheckpoint-208
I made some try with Python simple script and noarch.rpm archive. Both are same


What version of the MySQL are you using? (SELECT VERSION())
mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.16-log |
+------------+
1 row in set (0.00 sec)


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


On what operating system?
Linux RedHat 5 Enterprise - Kernel 2.6.18-164.el5


Please provide any additional information below.
Any idea ?? Thanks

What is the feature request?

MyCheckpoint should produce aggregate charts summarising certain metrics from 
multiple servers.

How will this change current behavior?

The system currently only produces charts on a per-server basis.

What parameters/options will be required?

Unknown

What version of the mycheckpoint are you using?

170

What version of the MySQL are you using?

5

On what operating system?

Centos

What steps will reproduce the problem?
1. install mycheckpint from svn as well as latest tgz (208)
2. mysql -uusernmae -p mycp_stage_worker --silent --raw --execute="SELECT html 
FROM sv_report_html_24_7"  > /var/www/mysql/mycp_stage_worker/report24_7.html
3. as well as mysql -uusernmae -p mycp_stage_worker --silent --raw 
--execute="SELECT html FROM sv_report_html_24_7"  | sed "s/\&/\&/g" > 
/var/www/mysql/mycp_stage_worker/report24_7.html

What is the expected output? What do you see instead?

I expect to see the charts; I do not see the charts

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

NA. the reports are generated and are stored in the db, but no charts are 
displayed when viewing the rendered html


What version of the mycheckpoint are you using?
What version of the MySQL are you using? (SELECT VERSION())
What version of Python are you using? (python --version)
On what operating system?
What is your sql_mode? (SELECT @@global.sql_mode)


Please provide any additional information below.

What steps will reproduce the problem?
1. install mycheckpoint debian package
2. create the following /etc/mycheckpoint.cnf file
[mycheckpoint]
smtp_host = localhost
smtp_from = [email protected]
smtp_to = [email protected]

[client]
host=localhost
socket=/var/run/mysqld/mysqld.sock
user=root
password=
port=3306

3. try to run mycheckpoint

What is the expected output? What do you see instead?
# mycheckpoint   
-- ERROR: Cannot connect to database
-- ERROR: Failed sending email
(2002, "Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysql.sock' (2)")

If I run "mycheckpoint --defaults-file=/etc/mycheckpoint.cnf" then it will run 
correctly. 

What is the output when running with the "--verbose --debug" options?
# mycheckpoint --verbose --debug
-- Will assume /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 132, build 201006041210. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- ERROR: Cannot connect to database
-- Sending cannot access message from [email protected] to: 
[email protected] via: localhost
-- ERROR: Failed sending email
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 3454, in send_email_message
    s = smtplib.SMTP(smtp_host)
  File "smtplib.py", line 244, in __init__
    (code, msg) = self.connect(host, port)
  File "smtplib.py", line 310, in connect
    raise socket.error, msg
error: (111, 'Connection refused')
(2002, "Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysql.sock' (2)")
Traceback (most recent call last):
  File "/usr/bin/mycheckpoint", line 3661, in ?
    monitored_conn, write_conn = open_connections()
  File "/usr/bin/mycheckpoint", line 109, in open_connections
    db = database_name)
  File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 75, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 164, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2002, "Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysql.sock' (2)")
--
-- Make sure you have executed mycheckpoint with 'deploy' after last 
install/update.upgrade
--  If not, run again with same configuration, and add 'deploy'. e.g.:
--  mycheckpoint --host=my_host deploy
--

Looks like the socket option is not parsed correctly... The email stuff looks 
to be OK. Besides, it would be cool if the default socket would be equivalent 
to what debian uses (mysqld.sock, not mysql.sock)

What version of the mycheckpoint are you using?
mycheckpoint 132-1

What version of the MySQL are you using? (SELECT VERSION())
5.0.51a

On what operating system?
Debian Etch and Lenny


Thanks in advance

What is the feature request?
(1054, "Unknown column 'mysql' in 'field list'")
How will this change current behavior?

What parameters/options will be required?

What version of the mycheckpoint are you using?
mycheckpoint-231 
What version of the MySQL are you using?
percona 5.6
On what operating system?
centos 6.x



hey,Shlomi Noach!
i love the mycheckpoint.i have use the mycheckpoint very long time,and it run 
very good!!but now i update my mysql to 5.6,and some change to percona 5.6,i 
also used the tokudb for new system,that have some bugs!
i just give the error info!

1.
percona 5.6 with tokudb engine
(1166, "Incorrect column name 
'tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_by_diff'")

2.
percona 5.6
(1054, "Unknown column 'mysql' in 'field list'")

3.
mysql 5.6 
(1166, "Incorrect column name 
'tokudb_nonleaf_nodes_flushed_to_disk_checkpoint_uncompressed_by_diff'")

tkx,wait for your reply!!!mycheckpint big fan.

What steps will reproduce the problem?
1. status_variables_aggregated_hour table exists
2.
3.

What is the expected output? What do you see instead?
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")

What is the output when running with the "--verbose --debug" options?
Traceback (most recent call last):
  File "mycheckpoint.py", line 2260, in create_status_variables_hour_aggregation_table
    act_query(query)
  File "mycheckpoint.py", line 247, in act_query
    num_affected_rows = cursor.execute(query)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1005, "Can't create table 
'mycheckpoint.status_variables_aggregated_hour' (errno: 139)")
-- status_variables_aggregated_hour table exists
(1146, "Table 'mycheckpoint.status_variables_aggregated_hour' doesn't exist")
Traceback (most recent call last):
  File "mycheckpoint.py", line 4950, in <module>
    deploy_schema()
  File "mycheckpoint.py", line 4847, in deploy_schema
    create_status_variables_views_and_aggregations()
  File "mycheckpoint.py", line 3914, in create_status_variables_views_and_aggregations
    upgrade_status_variables_hour_aggregation_table()
  File "mycheckpoint.py", line 2021, in upgrade_status_variables_hour_aggregation_table
    return upgrade_status_variables_aggregation_table("status_variables_aggregated_hour")
  File "mycheckpoint.py", line 1994, in upgrade_status_variables_aggregation_table
    existing_columns = [row["Field"] for row in get_rows(query, write_conn)]
  File "mycheckpoint.py", line 268, in get_rows
    cursor.execute(query)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'mycheckpoint.status_variables_aggregated_hour' 
doesn't exist")


What version of the mycheckpoint are you using? 231
What version of the MySQL are you using? (SELECT VERSION())5.5.33a-MariaDB-log
What version of Python are you using? (python --version) Python 2.6.8

On what operating system? SUSE Linux Enterprise Server 11 (x86_64)
What is your sql_mode? (SELECT @@global.sql_mode)  NO_AUTO_CREATE_USER


Please provide any additional information below.

While generating a human report, I get to see values such as: 
DML:
    SELECT:  0.01/sec  4.4%
    INSERT:  3.59/sec  2873.3%
    UPDATE:  0.00/sec  0.0%
    DELETE:  0.01/sec  6.7%
    REPLACE: 0.00/sec  0.0%
    SET:     0.03/sec  20.0%
    COMMIT:  0.03/sec  26.7%
    slow:    0.00/sec  0.0% (slow time: 10sec)


And also: 

Selects:
    Full scan: 0.06/sec  1100.0%
    Full join: 0.00/sec  0.0%
    Range:     0.00/sec  0.0%
    Sort merge passes: 0.00/sec

It seems to me that doing 1100% full scans or 2873.3% of INSERTs would be 
amazing, but not 
really possible :) 

What steps will reproduce the problem?

1.  When running "select * from db\G" you will notice on a default installation 
there are two blank user entries:
*************************** 1. row ***************************
                 Host: %
                   Db: test
                 User: 
*************************** 2. row ***************************
                 Host: %
                   Db: test\_%
                 User: 

2.  lets say I have two users with two different databases that start with 
"test_".  Both users will be able to see the others database with these 
defaults in place.

3.  Here is the test:
-- as root
create database test_user1;
create database test_user2;
grant select on `test_user1`.* to 'user1'@'localhost';
grant select on `test_user2`.* to 'user2'@'localhost'; 

-- as user1
mysql -uuser1

[Wed Apr 13 14:33:35 2011] (user1@localhost) [(none)]> show databases; 
+--------------------+
| Database           |
+--------------------+
| information_schema |
| test               |
| test_user1         |
| test_user2         | <-- user1 should NOT be able to see this database
+--------------------+
4 rows in set (0.00 sec)

[Wed Apr 13 14:33:40 2011] (user1@localhost) [(none)]> show grants; 
+-------------------------------------------------------+
| Grants for user1@localhost                            |
+-------------------------------------------------------+
| GRANT USAGE ON *.* TO 'user1'@'localhost'             |
| GRANT SELECT ON `test_user1`.* TO 'user1'@'localhost' |
+-------------------------------------------------------+

What version of the secure are you using?
This was from the MySQL Conference

On what operating system?
Any OS, any version of MySQL.

Please provide any additional information below.

Please let me know if you need anything else.

best,

Chris Schneider

What steps will reproduce the problem?
1. Startup http mode
2. browse to page
3. crash

What is the expected output? What do you see instead?
Exception happened during processing of request from ('10.11.1.1', 59995)
Traceback (most recent call last):
  File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
    self.process_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
    self.finish_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
    self.handle()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
    self.handle_one_request()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
    method()
  File "/usr/local/bin/mycheckpoint", line 4730, in do_GET
    html = http_embed_code(html, '<div class="header">', html_embed)
  File "/usr/local/bin/mycheckpoint", line 4535, in http_embed_code
    html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'

What is the output when running with the "--verbose --debug" options?
[root@mon001 ~]# /usr/local/bin/mycheckpoint http --verbose --debug
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- Will not monitor the database
read databases
started httpserver on port 12306...
----------------------------------------
Exception happened during processing of request from ('10.11.1.1', 60042)
Traceback (most recent call last):
  File "/usr/lib64/python2.4/SocketServer.py", line 222, in handle_request
    self.process_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 241, in process_request
    self.finish_request(request, client_address)
  File "/usr/lib64/python2.4/SocketServer.py", line 254, in finish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib64/python2.4/SocketServer.py", line 521, in __init__
    self.handle()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 316, in handle
    self.handle_one_request()
  File "/usr/lib64/python2.4/BaseHTTPServer.py", line 310, in handle_one_request
    method()
  File "/usr/local/bin/mycheckpoint", line 4730, in do_GET
    html = http_embed_code(html, '<div class="header">', html_embed)
  File "/usr/local/bin/mycheckpoint", line 4535, in http_embed_code
    html = html.replace(anchor, "%s%s" % (anchor, code))
AttributeError: 'array.array' object has no attribute 'replace'
----------------------------------------

What version of the mycheckpoint are you using? mycheckpoint rev 208, build 
201011041330
What version of the MySQL are you using? (SELECT VERSION()) 5.0.77
On what operating system? CentOS 5


Please provide any additional information below.

What steps will reproduce the problem?
1.I get errors with mycheckpoint crash tables
2.
3.

What is the expected output? What do you see instead?
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110816 21:00:05 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110816 21:00:07 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110816 21:05:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110816 21:05:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110819 12:40:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110819 12:40:13 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110819 12:40:19 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110819 12:45:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110819 12:45:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:05:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110820 10:15:02 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110825 14:20:05 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110825 14:20:13 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110825 14:21:07 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired
110826 12:50:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:03 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables' is marked as crashed and should be repaired
110826 12:50:10 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_hour' is marked as crashed and 
should be repaired
110826 12:50:15 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/status_variables_aggregated_day' is marked as crashed and 
should be repaired
110826 12:55:01 [ERROR] /usr/libexec/mysqld: Table './mycheckpoint/alert' is 
marked as crashed and should be repaired
110826 12:55:02 [ERROR] /usr/libexec/mysqld: Table 
'./mycheckpoint/alert_pending' is marked as crashed and should be repaired

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

What version of the mycheckpoint are you using?
208
What version of the MySQL are you using? (SELECT VERSION())
5.5.13
On what operating system?
Linux

Please provide any additional information below.

To complete the remote monitoring scheme, add to the existing --monitored-host, 
--monitored-port and --monitored-socket the user & password details.

Hi I tried to install mycheckpoint via rpm but getting an error. I use MariaDB 
5.2.x with yum exclude for mysql, so manually compiled MySQL-python but not 
getting any where ?

* CentOS 6.0 64bit
* MariaDB 5.2.10 64bit
* Python 2.7.2

Server version          5.2.10-MariaDB-mariadb107
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 1 day 3 hours 49 min 9 sec

Threads: 1  Questions: 7  Slow queries: 0  Opens: 15  Flush tables: 1  Open 
tables: 8  Queries per second avg: 0.0

which python
alias python='/opt/python2.7.2/bin/python'
        /opt/python2.7.2/bin/python

mycheckpoint --help
Traceback (most recent call last):
  File "/usr/local/bin/mycheckpoint", line 22, in <module>
    import MySQLdb
ImportError: No module named MySQLdb

MySQL-python install
wget 
http://sourceforge.net/projects/mysql-python/files/mysql-python/1.2.3/MySQL-pyth
on-1.2.3.tar.gz/download
tar xvzf MySQL-python-1.2.3.tar.gz 
cd MySQL-python-1.2.3
/opt/python2.7.2/bin/python setup.py build
/opt/python2.7.2/bin/python setup.py install

output

#######################
[root@host MySQL-python-1.2.3]# /opt/python2.7.2/bin/python setup.py build
running build
running build_py
creating build
creating build/lib.linux-x86_64-2.7
copying _mysql_exceptions.py -> build/lib.linux-x86_64-2.7
creating build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/__init__.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/converters.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/connections.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/cursors.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
copying MySQLdb/times.py -> build/lib.linux-x86_64-2.7/MySQLdb
creating build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/__init__.py -> 
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> 
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> 
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/REFRESH.py -> 
build/lib.linux-x86_64-2.7/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> 
build/lib.linux-x86_64-2.7/MySQLdb/constants
running build_ext
building '_mysql' extension
creating build/temp.linux-x86_64-2.7
gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG -g -fwrapv -O3 -Wall 
-Wstrict-prototypes -fPIC -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3 
-I/usr/include/mysql -I/opt/python2.7.2/include/python2.7 -c _mysql.c -o 
build/temp.linux-x86_64-2.7/_mysql.o -fno-omit-frame-pointer -g -pipe 
-Wp,-D_FORTIFY_SOURCE=2 -fstack-protector --param=ssp-buffer-size=4 -m64 
-DUNIV_LINUX
In file included from _mysql.c:36:
/usr/include/mysql/my_config.h:1217:1: warning: "HAVE_WCSCOLL" redefined
In file included from /opt/python2.7.2/include/python2.7/Python.h:8,
                 from pymemcompat.h:10,
                 from _mysql.c:29:
/opt/python2.7.2/include/python2.7/pyconfig.h:887:1: warning: this is the 
location of the previous definition
gcc -pthread -shared build/temp.linux-x86_64-2.7/_mysql.o -L/usr/lib64/mysql 
-L/opt/python2.7.2/lib -lmysqlclient_r -lz -lnsl -lrt -lresolv -lpthread 
-lcrypt -lnsl -lm -lpthread -lrt -lpython2.7 -o 
build/lib.linux-x86_64-2.7/_mysql.so

#######################
[root@host MySQL-python-1.2.3]# /opt/python2.7.2/bin/python setup.py install
running install
running bdist_egg
running egg_info
writing MySQL_python.egg-info/PKG-INFO
writing top-level names to MySQL_python.egg-info/top_level.txt
writing dependency_links to MySQL_python.egg-info/dependency_links.txt
reading manifest file 'MySQL_python.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching 'MANIFEST'
warning: no files found matching 'ChangeLog'
warning: no files found matching 'GPL'
writing manifest file 'MySQL_python.egg-info/SOURCES.txt'
installing library code to build/bdist.linux-x86_64/egg
running install_lib
running build_py
copying MySQLdb/release.py -> build/lib.linux-x86_64-2.7/MySQLdb
running build_ext
creating build/bdist.linux-x86_64
creating build/bdist.linux-x86_64/egg
creating build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/times.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/connections.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/cursors.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/converters.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
creating build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CLIENT.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FIELD_TYPE.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/FLAG.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/REFRESH.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/CR.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/__init__.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/constants/ER.py -> 
build/bdist.linux-x86_64/egg/MySQLdb/constants
copying build/lib.linux-x86_64-2.7/MySQLdb/__init__.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/MySQLdb/release.py -> 
build/bdist.linux-x86_64/egg/MySQLdb
copying build/lib.linux-x86_64-2.7/_mysql_exceptions.py -> 
build/bdist.linux-x86_64/egg
copying build/lib.linux-x86_64-2.7/_mysql.so -> build/bdist.linux-x86_64/egg
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/times.py to times.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/connections.py to 
connections.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/cursors.py to cursors.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/converters.py to 
converters.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CLIENT.py to 
CLIENT.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FIELD_TYPE.py to 
FIELD_TYPE.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/FLAG.py to 
FLAG.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/REFRESH.py to 
REFRESH.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/CR.py to CR.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/__init__.py to 
__init__.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/constants/ER.py to ER.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/__init__.py to __init__.pyc
byte-compiling build/bdist.linux-x86_64/egg/MySQLdb/release.py to release.pyc
byte-compiling build/bdist.linux-x86_64/egg/_mysql_exceptions.py to 
_mysql_exceptions.pyc
creating stub loader for _mysql.so
byte-compiling build/bdist.linux-x86_64/egg/_mysql.py to _mysql.pyc
creating build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/SOURCES.txt -> 
build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/dependency_links.txt -> 
build/bdist.linux-x86_64/egg/EGG-INFO
copying MySQL_python.egg-info/top_level.txt -> 
build/bdist.linux-x86_64/egg/EGG-INFO
writing build/bdist.linux-x86_64/egg/EGG-INFO/native_libs.txt
zip_safe flag not set; analyzing archive contents...
creating dist
creating 'dist/MySQL_python-1.2.3-py2.7-linux-x86_64.egg' and adding 
'build/bdist.linux-x86_64/egg' to it
removing 'build/bdist.linux-x86_64/egg' (and everything under it)
Processing MySQL_python-1.2.3-py2.7-linux-x86_64.egg
Removing 
/opt/python2.7.2/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_
64.egg
Copying MySQL_python-1.2.3-py2.7-linux-x86_64.egg to 
/opt/python2.7.2/lib/python2.7/site-packages
MySQL-python 1.2.3 is already the active version in easy-install.pth

Installed 
/opt/python2.7.2/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-linux-x86_
64.egg
Processing dependencies for MySQL-python==1.2.3
Finished processing dependencies for MySQL-python==1.2.3

What steps will reproduce the problem?
1. take a sample every 2 minutes
2. the chart can not display
3. The google chart return the error "The requested URL /chart... is too 
large to process."

What version of the mycheckpoint are you using?
revision 76

What version of the MySQL are you using?
MySQL-5.1.41

On what operating system?
CentOS 5.3

Please provide any additional information below.
the chart URL:
http://chart.apis.google.com/chart?
cht=lc&chs=400x200&chts=303030,12&chtt=Latest+13+hours:+Jan+11,+00:19++-
++Jan+11,+13:08&chdl=com_select_psec|com_insert_psec|com_delete_psec|com_up
date_psec|com_replace_psec&chdlp=b&chco=ff8c00,4682b4,9acd32,dc143c,9932cc&
chd=s:NMMLLLLKJJIHHHHGGGGGGGFFFFFFFFFEFFFFFEEEEEEEEFEEDDDEDDDDDDEDDDDDDDDDD
DDDDDDCDCDDDDCCDDCCDCCCCCCCCDCCCCDCCCCCCCCCCCCCCCCCDCCCCCDCCCCCCDCCDCDDDDDD
DDDDDDDDDEEEEEEEFFFFFFGGFFGGGGGHHHHHHHHIIHIIJJJJJKJKKKKKKLJLMLMMMNNONOOPQRR
SSSSUUUUVVVVWWWYYXYYYZYYZdihhhheeedcccbcbZZZadbbZYYZbaaZZZaZYZZYZZZYZZZZYYY
ZZYYYYYXZaYZYYXXXYYYYZYXXYYYZXXXXXYYYYXZZYYZYZZXYaZYZYZZaZYYaaaaaaZZaZZZZZ,
DDDCCCCCCCCBCBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBABBBBABA
ABBBBBBABBBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAABBAAAAAAAAAB
BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBCCCCCCCCCCCCCCCCCCCCCCCCDCDDDDDDDDDDDEEEEEEEE
FEFFFFFFFFFFGFGFFFGIJIIIIHHHHHHHGHGGGGGHGGGGFGGGGGFGGFFFGFFFFFFFFGFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFEFEFFFFFFFFFFFFFFFFFFFFFFFFFFGFFFFFFFFFFFFF,AAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA,aaZWVWVUSRQO
PNONNMMMMNMLLKKLLMKJKJJJJIJIJIIJJLJIHHHHHGGHHHIHHGHHGHHHGGGHGGGFGFGHHGGGGFF
FFEDEFFFEFFFEFFFFEFEEEEEEEEEEEEFFFEEEFFGFFFFFFFFFFFFFGFFFGGGFFGFGHHHIIJJKKK
KKKKMMLLLLMNNONNOOPPPQQQPRSTSSSTSSUUTUVUSXWVYYYZYaZabccghhiiiklkkklnnoopssq
srssrruz97787310zyyzxxwutsuyvusrrsutututsssttstusqtrtrprtssqqrrqqtursrrpqpq
ssqtrqprrrsppopqrrrqpturqsrtsqpvtqsrsswssswuvwvxtuvtsttt,AAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA&chxt=x,y&chxr=1,0,3740.1
7&chxl=0:||||04:00||||08:00||||12:00||&chxs=0,505050,10&chg=7.81,25,1,2,5.3
4,0&chxp=0,5.34,13.15,20.96,28.77,36.58,44.39,52.20,60.01,67.82,75.63,83.44
,91.25,99.06

What steps will reproduce the problem?
1.install and run on a server with existing data
2.i have ran this on two servers same results
3.percona 5.5.29

What is the expected output? What do you see instead?

What is the output when running with the "--verbose --debug" options?
[root@vagrant-ci]:~$ mycheckpoint --defaults-file=/z/dbscripts/vagrant-ci.cnf 
--verbose
-- Using /z/dbscripts/vagrant-ci.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is rladmin
-- Non matching deployed revision. Will auto-deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- html_components table created
-- custom_query table created
-- custom_query_view created
-- 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
-- status_variables table exists
-- alert_condition table created
-- alert table created
-- alert_pending table created
-- sv_latest view created
-- sv_diff view created
-- sv_sample view created
-- status_variables_aggregated_hour table exists
-- status_variables_aggregated_day table exists
-- sv_hour view created
-- sv_day view created
-- sv_param_change view created
-- report views created
-- 24/7 report view created
-- recent reports views created
-- sv_report_sample_recent_aggregated view created
-- reports minmax views created
-- report human views created
-- sv_report_chart_sample_timeseries view created
-- sv_report_chart_hour_timeseries view created
-- sv_report_chart_day_timeseries view created
-- report charts labels views created
-- report charts views created
-- report 24/7 chart view created
-- custom chart views created
(1267, "Illegal mix of collations (utf8_bin,NONE) and (binary,IGNORABLE) for 
operation 'case'")
--
-- Re-execute with --verbose --debug for detailed message and strack trace.

What version of the mycheckpoint are you using? 208
What version of the MySQL are you using? (SELECT VERSION())5.5.29-29.4-log
What version of Python are you using? (python --version)Python 2.6.6
On what operating system? centos 6.3
What is your sql_mode? (SELECT @@global.sql_mode)
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

mysql> 


Please provide any additional information below.

What steps will reproduce the problem?
1. Set up mycheckpoint to monitor a live server remotely, as follows:
/etc/mycheckpoint.cnf:

[mycheckpoint]
#smtp_host = mail.my-server-company.com
#smtp_from = [email protected]
#smtp_to = [email protected]
monitored_port=3306
monitored_host=livedbserver.com
monitored_user=monitoring_user
monitored_password=[*****]
purge_days = 60

[client]
user=monitoring_user
password=[*****]
socket=/var/run/mysqld/mysqld.sock
port=3306
host=localhost
database=mycheckpoint
skip_check_replication=True

2. Deploy and run:

user@monitoringhost$ mycheckpoint deploy
Add the following row to crontab:
*/5 * * * * mycheckpoint

What is the expected output? What do you see instead?

While mycheckpoint is logging rows into the status_variables table, I'm not 
getting any rows from the sv_diff view:

mysql> SELECT questions, uptime, warning_count, ts FROM status_variables;
+-----------+---------+---------------+---------------------+
| questions | uptime  | warning_count | ts                  |
+-----------+---------+---------------+---------------------+
| 241039414 | 1281504 |             0 | 2012-11-02 16:20:01 |
| 241101176 | 1281804 |             0 | 2012-11-02 16:25:01 |
| 241152461 | 1282105 |             0 | 2012-11-02 16:30:01 |
| 241205392 | 1282405 |             0 | 2012-11-02 16:35:01 |
| 241258591 | 1282705 |             0 | 2012-11-02 16:40:01 |
| 241307251 | 1283005 |             0 | 2012-11-02 16:45:02 |
| 241354124 | 1283305 |             0 | 2012-11-02 16:50:01 |
| 241409544 | 1283605 |             0 | 2012-11-02 16:55:01 |
| 241459330 | 1283905 |             0 | 2012-11-02 17:00:01 |
| 241501222 | 1284205 |             0 | 2012-11-02 17:05:01 |
+-----------+---------+---------------+---------------------+
10 rows in set (0.00 sec)

mysql> SELECT * FROM sv_diff;
Empty set (0.00 sec)

mysql>

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

user@monitoringhost$ mycheckpoint --verbose --debug
-- Using /etc/mycheckpoint.cnf as defaults file
-- mycheckpoint rev 208, build 201011041330. Copyright (c) 2009-2010 by Shlomi 
Noach
-- database is mycheckpoint
-- monitored host is: livedbserver.com
-- Global status & variables recorded
-- Non-local monitoring; will not read OS data
-- New entry added: id=22; ts=2012-11-02 17:08:32
-- Collecting custom data
-- No alert conditions defined
-- Status variables checkpoint complete


What version of the mycheckpoint are you using?
Revision 208

What version of the MySQL are you using? (SELECT VERSION())
livedbserver.com:
mysql> SELECT VERSION();
+----------------+
| VERSION()      |
+----------------+
| 5.1.65-ius-log |
+----------------+
1 row in set (0.00 sec)


Monitoring host:
mysql> SELECT VERSION();
+-----------------------------+
| VERSION()                   |
+-----------------------------+
| 5.1.61-0ubuntu0.10.10.1-log |
+-----------------------------+
1 row in set (0.00 sec)



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

user@monitoringhost$ python --version
Python 2.6.6


On what operating system?
livedbserver.com:
CentOS

Monitoring host:
Ubuntu



What is your sql_mode? (SELECT @@global.sql_mode)
livedbserver.com:

mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

Monitoring host:

mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)

What is the feature request?
Run once, to prevent from running more than once from crond.

How will this change current behavior?
Not much, see included patch.

What parameters/options will be required?
None, but one could prefer a "force_run" parameter to bypass run_once

What version of the mycheckpoint are you using?
208

What version of the MySQL are you using?
5.x

On what operating system?
Linux (Gentoo, RH, SuSE)

What steps will reproduce the problem?
1. With crontab each 5 minutes, generate mycheckpoint records from localmachine 
stored to remote database
mycheckpoint_r223.py --host=xxx.xxx.xxx.xxx --port=3306 --user=mycheckpoint 
--password=mycheckpoint --database=mcp_webprod --monitored-host=localhost 
--monitored-socket=/tmp/mysql.sock --verbose --debug
-- mycheckpoint rev 0, build 0. Copyright (c) 2009-2010 by Shlomi Noach
-- database is mcp_webprod
-- monitored host is: localhost
-- monitored host credentials undefined; using write host credentials
-- 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
-- New entry added: id=252; ts=2012-06-13 11:05:16
-- Collecting custom data
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_hour
-- 2012-06-13 11:05:16 Entry aggregated into status_variables_aggregated_day
-- No alert conditions defined
-- Status variables checkpoint complete

2. Check that some datas are recorded in mcp_webprod database as wanted for 
more than 12 hours

3. On remote computer (host of remote database), with crontab each hour 
generate mycheckpoint reports in html manner and store it in apache web server 
space
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM 
sv_report_html"       --silent --raw > /data/www/mycheckpoint/webprod.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT html FROM 
sv_report_html_brief" --silent --raw > /data/www/mycheckpoint/webprod_brief.html
mysql -umycheckpoint -pmycheckpoint mcp_webprod --execute="SELECT *    FROM 
sv_param_change"      --silent --raw > 
/data/www/mycheckpoint/webprod_paramchange.html

4. Check that files are well generated
[dba@frlusv113 mycheckpoint]$ ll
-rwxrwx--- 1 webservd webservd 197682 Jun 13 10:53 webprod.html
-rwxrwx--- 1 webservd webservd 110227 Jun 13 10:53 webprod_brief.html
-rwxrwx--- 1 webservd webservd      0 Jun 13 10:53 webprod_paramchange.html
Note that webprod_paramchange.html file size is zero bytes because no parameter 
chage have occur since mycheckpoint is running ;)

5. Watch with your favorite browser (chrome 19.0 or firefox 13.0 for me) these 
generate html reports
Note that reports are well formatted but there is no graph in it, only empty 
gray boxes - see attached pdfs.

6. Click on [url] link (in my example innodb_buffer_pool_pages graph box)
It open a graph centric web page holding a single graph (from 
chart.apis.google.com). And graph is there  !!


What is the expected output? What do you see instead?
Generated web page full of graphics


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


What version of the mycheckpoint are you using?
r223


What version of the MySQL are you using? (SELECT VERSION())
Monitored database  : mysql> 5.5.16-log
Remote mcp database : mysql> 5.5.16-log


What version of Python are you using? (python --version)
Monitored database  : Python 2.4.3


On what operating system?
Both Linux RedHat 5 Enterprise


What is your sql_mode? (SELECT @@global.sql_mode)
Monitored database  :
mysql> SELECT @@global.sql_mode;
+-------------------+
| @@global.sql_mode |
+-------------------+
|                   |
+-------------------+
1 row in set (0.00 sec)


Remote mcp database :
mysql> SELECT @@global.sql_mode;
+-------------------------------------------------------------------------------
-------------------------------------------+
| @@global.sql_mode                                                             
                                           |
+-------------------------------------------------------------------------------
-------------------------------------------+
| 
NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO
_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------
-------------------------------------------+
1 row in set (0.00 sec)


Please provide any additional information below.
Please find attached pdfs:
 * mcp_webprod.monitoring_full report.pdf
 * mcp_webprod.monitoring_latest 24 hours report.pdf
 * mcp_webprod.monitoring_full report - innodb_buffer_pool_pages.pdf