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

warning about BINLOG_FORMAT = STATEMENT on galera cluster members

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Incomplete
    • 10.4.26
    • N/A
    • Galera, Replication
    • Linux 6.0.10-gentoo

    Description

      Noticed warnings written to mysqld.err log file:

      2022-12-05 18:49:34 33 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system variable that may have a different value on the slave Statement: OPTIMIZE TABLE `table1`
      

      According to the warning, it appears due to having "BINLOG_FORMAT = STATEMENT". However, in fact binlog_format = ROW is set in configuration file, also corresponding variable value is correct.

      mysql -e 'select @@binlog_format;'
      @@binlog_format
      ROW
      

      Since we don't use bin_log replication, this warning doesn't affect anything. However, it's a bit strange to get it on galera cluster members.

      Attachments

        Activity

          People

            janlindstrom Jan Lindström
            euglorg Eugene
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.