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

galera fails to replicate DDL queries when using binlog_checksum

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.14-galera
        • Fix Version/s: 5.5.43-galera, 10.0.19-galera
        • Component/s: Galera
        • Labels:
        • Environment:
          CentOS 6.5

          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.

            Gliffy Diagrams

              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

                Activity

                Hide
                Permalink
                nirbhay_c Nirbhay Choubey added a comment -

                https://github.com/MariaDB/server/commit/d7445ea6dfbd3be390792c636f755d3bb40d5fbf

                Show
                nirbhay_c Nirbhay Choubey added a comment - https://github.com/MariaDB/server/commit/d7445ea6dfbd3be390792c636f755d3bb40d5fbf

                  People

                  • Assignee:
                    nirbhay_c Nirbhay Choubey
                    Reporter:
                    bradjorgensen Brad Jorgensen
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: