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

Problematic BINLOG events from master

Details

    Description

      Had a master, within the same binary log, start generating BINLOG events that had no effect on the slaves. By default for a new session, binlog_format=ROW and tx_isolation='READ COMMITTED'

      Creating new slaves, they would see the same problem - BINLOG events that ran did not affect rows or cause an error. The same would occur in a PITR scenario, piping mysqlbinlog to `mysql` with or without --binary-mode.

      The simplest statement which did not replicate, was:

      mysql <<< "replace into replmon.hb (id, hb) values (1, now())"

      If I created a session and, before issuing the above, changed tx_isolation to repeatable with binlog_format=statement, the command would correctly replicate.

      I suspect a simple restart would have helped, but the packages were upgraded from 10.0.25 to 10.0.32 in hopes of avoiding the issue again.

      It may be a second bug, beyond strange events being created, that slaves did not modify rows or error on these BINLOG commands. I tried 10.0 slaves of course, but had the same experience with 10.2.13 (non-enterprise) in replication or PITR via mysqlbinlog.

      Attachments

        1. master-bin.sql
          2 kB
        2. slave-bin.sql
          1 kB
        3. slave-relay-bin.sql
          2 kB

        Issue Links

          Activity

            Elkin Andrei Elkin added a comment -

            reinder, yes, it's the slave side as you can see from patches committed to the parent bug. Although
            the patch also fixes a relating issue of the 32bit platform which is on master. I am about to push the two part patch.

            Elkin Andrei Elkin added a comment - reinder , yes, it's the slave side as you can see from patches committed to the parent bug. Although the patch also fixes a relating issue of the 32bit platform which is on master. I am about to push the two part patch.

            We didn't succeed in building an installable rpm-package for our CentOS7 machines. When you have a release candidate build of the 10.3-series, I'd like to test it.

            In the meantime we have succeeded in eliminating a few causes for wildly increasing table_ids, and see no more replication-problems.

            reinder Reinder Cuperus added a comment - We didn't succeed in building an installable rpm-package for our CentOS7 machines. When you have a release candidate build of the 10.3-series, I'd like to test it. In the meantime we have succeeded in eliminating a few causes for wildly increasing table_ids, and see no more replication-problems.
            Elkin Andrei Elkin added a comment -

            reinder, the bugfix is upcoming soon with a new releases, see https://jira.mariadb.org/secure/Dashboard.jspa.

            Thank you for practical recommendation of yours

            So increasing the variable table_open_cache should prevent the bug from manifesting itself on this server (and help a little in performance).

            Elkin Andrei Elkin added a comment - reinder , the bugfix is upcoming soon with a new releases, see https://jira.mariadb.org/secure/Dashboard.jspa . Thank you for practical recommendation of yours So increasing the variable table_open_cache should prevent the bug from manifesting itself on this server (and help a little in performance).
            Elkin Andrei Elkin added a comment -

            Closed as duplicate.

            Elkin Andrei Elkin added a comment - Closed as duplicate.
            Elkin Andrei Elkin added a comment -

            Fixes cce2b45c8f5 are pushed.

            Elkin Andrei Elkin added a comment - Fixes cce2b45c8f5 are pushed.

            People

              Elkin Andrei Elkin
              mg MG
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.