Skip to content

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

@GoogleCodeExporter

Description

@GoogleCodeExporter
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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions