Announcement

Announcement Module
Collapse
No announcement yet.

sql_log_bin not supported in new pt-online-schema-change?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql_log_bin not supported in new pt-online-schema-change?

    We often use --set-vars="sql_log_bin=0" in our OSC's in order to only perform schema changes on master due to issues with replication, then do the OSC's again on the slaves after the master has been completed.

    Since updating to percona-toolkit 2.2 I'm getting an error when trying to use sql_log_bin in that it's not a supported --set-vars option, has this changed in the new version? Is there another way to stop OSC from binlogging?

  • #2
    Hi,

    Are you still facing the same issue? Can you please provide command line that how you are running pt-osc and the error message which you are getting?

    Comment


    • #3
      I'm still seeing the same issue in the latest version of pt-online-schema-change (2.2.2). The command I'm using is:

      Code:
      $ pt-online-schema-change --progress time,10 --no-drop-old-table --recursion-method=none --no-check-replication-filters D=mydb,t=mytable --alter "ADD mydatetime DATETIME NULL DEFAULT NULL" --set-vars="SQL_LOG_BIN=0" --dry-run
      Invalid --set-vars value: SQL_LOG_BIN=0
      Code:
      $ pt-online-schema-change --version
      pt-online-schema-change 2.2.2

      Comment


      • #4
        This is actually a bug, I get the same error when I try to assign 0 to any variable. I've reported it here:
        https://bugs.launchpad.net/percona-toolkit/+bug/1182856

        As a workaround, you may just use


        --set-vars="SQL_LOG_BIN=OFF"

        Comment

        Working...
        X