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

rpl.rpl_mysqlbinlog_slave_consistency fails intermittently on tables comparison

Details

    Description

      rpl.rpl_mysqlbinlog_slave_consistency fails intermittently (retry-pass or retry-fail [but not necessarily for the same test case]):

      10.9 43fa8e0b8f3bae1ff8493cfd3adb3944
      https://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos73-ppc64le/builds/14215/steps/mtr/logs/stdio

      rpl.rpl_mysqlbinlog_slave_consistency 'stmt' w4 [ fail ]
              Test ended at 2022-04-26 22:41:54
       
      CURRENT_TEST: rpl.rpl_mysqlbinlog_slave_consistency
      mysqltest: In included file "/usr/share/mysql-test/suite/rpl/include/rpl_check_table_consistency.inc": 
      included from /usr/share/mysql-test/suite/rpl/include/mysqlbinlog_slave_consistency.inc at line 147:
      included from /usr/share/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 249:
      At line 36: "master had 3 tables but slave had 1 after binlog replay"
      

      Searching through cross-ref, this same error is seen randomly with the various test cases (see below).
      FWIW, I looked through most of the failures and could not see any cases fail where a --stop_position was specified.

      Below are collated fail messages from different builders:

      included from /buildbot/s390x-sles-15/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 73:
      At line 36: "master had 5 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/aarch64-debian-9/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 85:
      At line 36: "master had 2 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 97:
      At line 36: "master had 4 tables but slave had 0 after binlog replay"
       
      included from /buildbot/s390x-sles-15/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 108:
      At line 36: "master had 3 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 120:
      At line 36: "master had 1 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/aarch64-centos-7/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 131:
      At line 36: "master had 2 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 143:
      At line 36: "master had 2 tables but slave had 0 after binlog replay"
       
      included from /home/buildbot/s390x-ubuntu-2004/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 165:
      At line 36: "master had 4 tables but slave had 0 after binlog replay"
       
      included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 177:
      At line 36: "master had 1 tables but slave had 0 after binlog replay"
       
      included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 189:
      At line 36: "master had 1 tables but slave had 0 after binlog replay"
       
      included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 237:
      At line 36: "master had 1 tables but slave had 0 after binlog replay"
       
      included from /usr/share/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 249:
      At line 36: "master had 3 tables but slave had 1 after binlog replay"
       
      included from /buildbot/amd64-ubuntu-2004-fulltest/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 261:
      At line 36: "master had 2 tables but slave had 0 after binlog replay"
       
      included from /buildbot/s390x-rhel-8/build/mysql-test/suite/rpl/t/rpl_mysqlbinlog_slave_consistency.test at line 344:
      At line 36: "master had 1 tables but slave had 0 after binlog replay"
      

      First seen on 63a479e2e033cfe578040e1331efc1192413ee7c.

      Attachments

        1. mysqld.1.err.4
          8.47 MB
          Angelique Sklavounos
        2. mysqld.2.err.4
          3.21 MB
          Angelique Sklavounos

        Activity

          Transition Time In Source Status Execution Times
          Brandon Nesterenko made transition -
          Open In Progress
          5h 4m 1
          Brandon Nesterenko made transition -
          In Progress In Review
          1m 2s 1
          Andrei Elkin made transition -
          In Review Stalled
          44m 34s 1
          Brandon Nesterenko made transition -
          Stalled Closed
          2h 27m 1

          People

            bnestere Brandon Nesterenko
            angelique.sklavounos Angelique Sklavounos (Inactive)
            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.