Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-3016

8.0 set persist binlog_format='STATEMENT' should not succeed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 8.0.18-internal
    • Fix Version/s: 8.0.18-9.3
    • Component/s: None
    • Labels:
      None
    • Needs Review:
      Yes

      Description

      My understanding is that binlog_format='STATEMENT' and binlog_format='MIXED' cannot be set in any way in 8.0, but it seems that we can set them with set persist command.

      node1:root@localhost> set session binlog_format='STATEMENT';
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
      
      node1:root@localhost> set global binlog_format='STATEMENT';
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'
      
      node1:root@localhost> set persist binlog_format='STATEMENT';
      Query OK, 0 rows affected (0,00 sec)
      
      node1:root@localhost> set session binlog_format='MIXED';
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'MIXED'
      
      node1:root@localhost> set global binlog_format='MIXED';
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'MIXED'
      
      node1:root@localhost> set persist binlog_format='MIXED';
      Query OK, 0 rows affected (0,00 sec)
      

      This is the error after restart:

      2020-02-28T11:38:54.228098Z 8 [ERROR] [MY-000000] [WSREP] Percona-XtraDB-Cluster prohibits setting binlog_format to STATEMENT or MIXED
      2020-02-28T11:38:54.229675Z 8 [ERROR] [MY-011268] [Server] Configuring persisted options failed: "Variable 'binlog_format' can't be set to the value of 'STATEMENT'".
      2020-02-28T11:38:54.229791Z 0 [ERROR] [MY-010175] [Server] Setting persistent options failed.
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                kamil.holubicki Kamil Holubicki
                Reporter:
                tomislav.plavcic@percona.com Tomislav Plavcic
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 hours, 10 minutes
                    3h 10m