mycheckpoint deploy fails with error 1140

[GoogleCodeExporter]

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.

Original issue reported on code.google.com by scho...@gmail.com on 21 Dec 2009 at 8:44

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

noting down details from email correspondence:
mysql> select @@sql_mode
    -> ;
+------------+
| @@sql_mode |
+------------+
|            |
+------------+

mysql> select version();
+-----------------------+
| version()             |
+-----------------------+
| 5.0.51a-24+lenny2-log |
+-----------------------+

Original comment by shlomi.n...@gmail.com on 21 Dec 2009 at 3:27

[GoogleCodeExporter]

I can't reproduce this on recent MySQL 5.0 and 5.1 versions.

Original comment by shlomi.n...@gmail.com on 21 Dec 2009 at 3:28

[GoogleCodeExporter]

Same here for ubuntu hardy ( 5.0.51a-3ubuntu5.4-log  )

$ mycheckpoint --defaults=/etc/mycheckpoint -v deploy
-- mycheckpoint rev 88, build 201002031552. Copyright (c) 2009 by Shlomi Noach
-- Deploy requested. Will deploy
-- metadata table created
-- numbers table created
-- charts_api table created
-- Global status & variables recorded
-- Cannot show master & slave status. Skipping
-- OS CPU info recorded
-- OS load average info recorded
-- OS mem info recorded
-- OS mountpoints info recorded
-- 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
-- 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
(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
--

Thanks!

Udi

Original comment by udi.cort...@gmail.com on 21 Feb 2010 at 11:01

[GoogleCodeExporter]

Attaching the query that did not run.

Original comment by udi.cort...@gmail.com on 21 Feb 2010 at 11:10

Attachments:

• mycp.sql

[GoogleCodeExporter]

Thank you,

I will look further into this.

Original comment by shlomi.n...@gmail.com on 21 Feb 2010 at 11:22

[GoogleCodeExporter]

Hi everyone,
I believe this issue is now fixed in r119.
Can you please verify this?

I have tested with mysql 5.0.51 (32 bit) on an Ubuntu 9.10 (32 bit) install.

I'm sorry it took so long. I was originally mistaken as for the source of the
problem. Apparently the fix was very simple...

Original comment by shlomi.n...@gmail.com on 30 Mar 2010 at 5:24

• Changed state: Fixed

[GoogleCodeExporter]

r119 works for me with 5.0.51a-3ubuntu5.5 (Ubuntu 8.04.0) 64 bit.

Original comment by jacob.elder on 30 Mar 2010 at 7:42