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

galera fails to replicate DDL queries when using binlog_checksum

    XMLWordPrintable

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
          Brad Jorgensen
        2. GRA_66_335743799.log
          0.1 kB
          Brad Jorgensen
        3. GRA_96_336539821.log
          0.3 kB
          Brad Jorgensen
        4. my.cnf
          2 kB
          Brad Jorgensen
        5. mysqld_checksum_errors.txt
          2 kB
          Brad Jorgensen

        Activity

          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.