[MDEV-8552] Under load rpl.sec_behind_master-5114 'stmt' fails with seconds_behind_master mismatch Created: 2015-07-28  Updated: 2015-07-28  Resolved: 2015-07-28

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1.5
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Stewart Smith Assignee: Unassigned
Resolution: Duplicate Votes: 0
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



 Comments   
Comment by Elena Stepanova [ 2015-07-28 ]

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

Generated at Thu Feb 08 07:28:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.