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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.1.5
    • N/A
    • Tests, MTR
    • None
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            stewart-ibm Stewart Smith
            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.