SunshineYang / mycheckpoint

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

disable-bin-log produce SQL error on mariadb 5.5.28a #40

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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 

Original issue reported on code.google.com by Steph...@mariadb.com on 8 Jan 2013 at 9:33

GoogleCodeExporter commented 9 years ago
What is your AUTOCOMMIT? (I'm guessing = 0)
Do you get same behavior for AUTOCOMMIT=1?

Original comment by shlomi.n...@gmail.com on 10 Jan 2013 at 1:37

GoogleCodeExporter commented 9 years ago
was assuming that mycheckpoint was changing auto commit but also using 
mysql-proxy pool in front so may be he is the one changing the auto commit  

Original comment by Steph...@mariadb.com on 10 Jan 2013 at 1:56

GoogleCodeExporter commented 9 years ago
was assuming that mycheckpoint was changing auto commit but also using 
mysql-proxy pool in front so may be he is the one changing the auto commit  

Original comment by Steph...@mariadb.com on 10 Jan 2013 at 1:56