Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12017

Unclear error with flashback: Variable 'binlog_format' can't be set to the value of 'statement'

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2(EOL)
    • 10.2.6
    • Replication
    • None

    Description

      When flashback is enabled, the local value of binlog_format can still be set to STATEMENT or MIXED, and an informative warning is produced:

      MariaDB [test]> show warnings;
      		 
      +---------+------+------------------------------------------------------------------+
      		 
      | Level   | Code | Message                                                          |
      		 
      +---------+------+------------------------------------------------------------------+
      		 
      | Warning | 1105 | MariaDB Galera and flashback do not support binlog format: MIXED |
      		 
      +---------+------+------------------------------------------------------------------+
      		 
      1 row in set (0.01 sec)

      However, when one attempts to set the global value, it produces a generic error:

      MariaDB [test]> set global binlog_format=mixed;
      		 
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'mixed'

      Maybe there is a reason why a local value can be set and global can not, but then the error message should at least say why it is not possible, referring to flashback.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik added a comment -

          sachin.setiya.007, what's the state of it? where's the patch?

          serg Sergei Golubchik added a comment - sachin.setiya.007 , what's the state of it? where's the patch?
          sachin.setiya.007 Sachin Setiya (Inactive) added a comment -

          patch
          Pushed

          sachin.setiya.007 Sachin Setiya (Inactive) added a comment - patch Pushed
          ccounotte COUNOTTE CEDRIC added a comment -

          I'm having the same error reported when I try to set global binlog_format back to mixed.

          Why is that and how can I switch to mixed binlog format dynamically or is it required to restart server?

          ccounotte COUNOTTE CEDRIC added a comment - I'm having the same error reported when I try to set global binlog_format back to mixed. Why is that and how can I switch to mixed binlog format dynamically or is it required to restart server?

          People

            sachin.setiya.007 Sachin Setiya (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.