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

Under load rpl.sec_behind_master-5114 'stmt' fails with seconds_behind_master mismatch

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Duplicate
        • Affects Version/s: 10.1.5
        • Fix Version/s: N/A
        • Component/s: Tests
        • Labels:
          None
        • Environment:
          Ubuntu vivid ppc64el

          Description

          rpl.sec_behind_master-5114 'stmt' w3 [ fail ]
          Test ended at 2015-07-28 08:41:12

          CURRENT_TEST: rpl.sec_behind_master-5114
          — /var/lib/jenkins/workspace/mariadb-10.1/mysql-test/suite/rpl/r/sec_behind_master-5114.result 2015-06-03 13:25:21.157409877 +1000
          +++ /var/lib/jenkins/workspace/mariadb-10.1/mysql-test/suite/rpl/r/sec_behind_master-5114.reject 2015-07-28 08:41:10.950099036 +1000
          @@ -3,7 +3,7 @@
          call mtr.add_suppression("Unsafe statement written to the binary log");
          CREATE TABLE t1 (a int);
          INSERT INTO t1 VALUES(SLEEP(2));
          -Seconds_Behind_Master: 1
          +Seconds_Behind_Master: 5
          Warnings:
          Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave.
          drop table t1;

          mysqltest: Result content mismatch

          At the time, the VM doing this build+test was rather loaded, as likely was the machine the KVM guest was on. This is likely due to load more than anything else, but the test should handle that

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Indeed, it should... We already have this one filed: MDEV-8518.

                Show
                elenst Elena Stepanova added a comment - Indeed, it should... We already have this one filed: MDEV-8518 .

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    stewart-ibm Stewart Smith
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: