ONLY_FULL_GROUP_BY in sql_mode MySql option

[GoogleCodeExporter]

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

Original issue reported on code.google.com by tda...@gmail.com on 12 Jun 2012 at 1:12