Illegal mix of collations (utf8_bin,NONE) and (binary,IGNORABLE) for operation 'case'"

[GoogleCodeExporter]

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.

Original issue reported on code.google.com by bigji...@gmail.com on 30 Jan 2013 at 7:41

[GoogleCodeExporter]

So the server I put this on blew up on it's backup. The issue is on 
sv_custom_chart_day
desc sv_custom_chart_day
    -> ;
ERROR 1267 (HY000): Illegal mix of collations (utf8_bin,NONE) and 
(binary,IGNORABLE) for operation 'case'

Original comment by bigji...@gmail.com on 31 Jan 2013 at 1:20

[GoogleCodeExporter]

Could you please paste output of:

show global variables like '%char%';

?

Original comment by shlomi.n...@gmail.com on 3 Feb 2013 at 6:13

[GoogleCodeExporter]

Close this bug. It was a UTF8 issue on the server it's self. Once I fixed all 
the encoding issues on the server it installs and runs fine.

Original comment by bigji...@gmail.com on 3 Jun 2013 at 5:40

[GoogleCodeExporter]

I'm curious. Can you describe the server issue?

Original comment by shlomi.n...@gmail.com on 3 Jun 2013 at 7:35

• Changed state: NotABug