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

LP #1263991: Session binlog_format cannot be changed to STATEMENT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Wait for Subtasks
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Ovais Tariq last update 17-11-2015 10:27:30

      PXC version:
      Server version: 5.6.15-62.0-log Percona XtraDB Cluster (GPL), Release 62.0, wsrep_25.2.r4027

      Setting session binlog_format to STATEMENT fails:
      mysql> SET SESSION binlog_format=STATEMENT;
      ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'STATEMENT'

      This is for example needed by pt-table-checksum to perform data consistency checks.

      The user has necessary privileges:
      mysql> show grants;
      ----------------------------------------------------------------------------------------------------------------------------------------

      Grants for root@localhost

      ----------------------------------------------------------------------------------------------------------------------------------------

      GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*xxx' WITH GRANT OPTION
      GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION

      ----------------------------------------------------------------------------------------------------------------------------------------
      2 rows in set (0.00 sec)

      Configuration is as follows:
      [mysqld]

      1. DOWNGRADE
        log_bin_use_v1_row_events = 1
        gtid_mode = 0
        binlog_checksum = NONE
      1. GENERAL
        datadir = /var/lib/mysql
        user = mysql
        default_storage_engine = InnoDB
      1. LOGGING
        log-error = /var/lib/mysql/mysql-error.log
        slow-query-log = 1
        slow-query-log-file = /var/lib/mysql/mysql-slow.log
      1. MyISAM
        key-buffer-size = 32M
        myisam-recover = FORCE,BACKUP
      1. SAFETY
        max-allowed-packet = 16M
        max-connect-errors = 1000000
        skip-name-resolve
        sysdate-is-now = 1
        innodb = FORCE
        innodb-strict-mode = 1
      1. BINARY LOGGING
        log-bin = /var/lib/mysql/mysql-bin
        expire-logs-days = 14
        binlog_format = ROW
      1. CACHES AND LIMITS
        tmp-table-size = 32M
        max-heap-table-size = 32M
        query-cache-type = 0
        query-cache-size = 0
        max-connections = 1000
        thread-cache-size = 50
        open-files-limit = 65535
        table-definition-cache = 1024
        table-open-cache = 2048
      1. INNODB
        innodb_flush_method = O_DIRECT
        innodb_log_files_in_group = 2
        innodb_log_file_size = 128M
        innodb_flush_log_at_trx_commit = 2
        innodb_file_per_table = 1
        innodb_buffer_pool_size = 1280M
        innodb_file_per_table
        innodb_locks_unsafe_for_binlog = 1
        innodb_autoinc_lock_mode = 2
      1. GALERA
        wsrep_provider = /usr/lib/libgalera_smm.so
        wsrep_cluster_address = gcomm://10.38.11.106,10.38.11.107,10.38.11.108
        wsrep_cluster_name = some_cluster
        wsrep_node_address = 10.38.81.196
        wsrep_sst_method = xtrabackup
        wsrep_replicate_myisam = 1

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: