[MDEV-13878] rpl.sec_behind_master-5114 failed in buildbot with wrong result Created: 2017-09-22  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-8518 rpl.sec_behind_master-5114 fails spor... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-amd64/builds/2012

rpl.sec_behind_master-5114 'stmt'        w4 [ fail ]
 
        Test ended at 2017-09-19 10:39:45
 
 
 
CURRENT_TEST: rpl.sec_behind_master-5114
 
--- /usr/share/mysql/mysql-test/suite/rpl/r/sec_behind_master-5114.result	2017-09-19 06:37:45.000000000 -0400
 
+++ /dev/shm/var/4/log/sec_behind_master-5114.reject	2017-09-19 10:39:45.401488324 -0400
 
@@ -4,7 +4,7 @@
 
 CREATE TABLE t1 (a int);
 
 INSERT INTO t1 VALUES(SLEEP(2));
 
 Seconds_Behind_Master_is_less_than_100
 
-1
 
+0
 
 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



 Comments   
Comment by Alice Sherepa [ 2020-09-11 ]

recenly on 10.2 http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles123-amd64/builds/5488/steps/mtr/logs/stdio

rpl.sec_behind_master-5114 'stmt'        w4 [ fail ]
 
        Test ended at 2020-09-04 12:13:22
 
 
 
CURRENT_TEST: rpl.sec_behind_master-5114
 
--- /usr/share/mysql-test/suite/rpl/r/sec_behind_master-5114.result	2020-09-04 09:15:39.000000000 +0000
 
+++ /dev/shm/var/4/log/sec_behind_master-5114.reject	2020-09-04 12:13:21.655672226 +0000
 
@@ -7,7 +7,7 @@
 
 INSERT INTO t1 VALUES(SLEEP(2));
 
 connection slave;
 
 Seconds_Behind_Master_is_less_than_100
 
-1
 
+0
 
 connection master;
 
 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
 
 
 
mysqltest: Result content mismatch

on 10.5 http://buildbot.askmonty.org/buildbot/builders/kvm-asan/builds/3972/steps/mtr_nm/logs/stdio

Generated at Thu Feb 08 08:09:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.