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

galera fails to replicate DDL queries when using binlog_checksum

Details

    Description

      When using binlog_checksum = 'CRC32', galera fails to replicate DDL events. I don't currently have an environment where I can test this more so I'm going off binlogs and error logs from when I had binlog_checksum set and not.

      When binlog_checksum was set, I saw errors like in mysqld_checksum_errors.txt. The errors on the analyze queries aren't critical but the error when creating the table caused two of my three nodes to kill themselves since the originating node then proceeded to load data into the table. Having set binlog_checksum to 'NONE' (the default) my cluster handles DDL queries normally now. I looked in the galera cache file on the surviving node and the queries did have the extra bytes after them just as in the error log.

      I also attached the GRA log files from the queries mentioned in the log file.

      Attachments

        1. GRA_41_335743798.log
          0.1 kB
        2. GRA_66_335743799.log
          0.1 kB
        3. GRA_96_336539821.log
          0.3 kB
        4. my.cnf
          2 kB
        5. mysqld_checksum_errors.txt
          2 kB

        People

          nirbhay_c Nirbhay Choubey (Inactive)
          bradjorgensen Brad Jorgensen
          Votes:
          0 Vote for this issue
          Watchers:
          1 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.