diff options
Diffstat (limited to 'mysql-test/suite/manual')
3 files changed, 0 insertions, 89 deletions
diff --git a/mysql-test/suite/manual/r/rpl_replication_delay.result b/mysql-test/suite/manual/r/rpl_replication_delay.result deleted file mode 100644 index 73dd77cc647..00000000000 --- a/mysql-test/suite/manual/r/rpl_replication_delay.result +++ /dev/null @@ -1,25 +0,0 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; -# Second_behind reports 0 -Seconds_Behind_Master 0 -drop table if exists t1; -Warnings: -Note 1051 Unknown table 't1' -create table t1 (f1 int); -flush logs /* contaminate rli->last_master_timestamp */; -lock table t1 write; -insert into t1 values (1); -# bug emulated: reports slave threads starting time about 3*3 not 3 secs -Seconds_Behind_Master 9 -unlock tables; -flush logs /* this time rli->last_master_timestamp is not affected */; -lock table t1 write; -insert into t1 values (2); -# reports the correct diff with master query time about 3+3 secs -Seconds_Behind_Master 7 -unlock tables; -drop table t1; diff --git a/mysql-test/suite/manual/t/rpl_replication_delay-slave.opt b/mysql-test/suite/manual/t/rpl_replication_delay-slave.opt deleted file mode 100644 index 24a4c5952fe..00000000000 --- a/mysql-test/suite/manual/t/rpl_replication_delay-slave.opt +++ /dev/null @@ -1 +0,0 @@ ---loose-debug=d,let_first_flush_log_change_timestamp diff --git a/mysql-test/suite/manual/t/rpl_replication_delay.test b/mysql-test/suite/manual/t/rpl_replication_delay.test deleted file mode 100644 index f2b2da6f53c..00000000000 --- a/mysql-test/suite/manual/t/rpl_replication_delay.test +++ /dev/null @@ -1,63 +0,0 @@ -# -# Testing replication delay reporting (bug#29309) -# there is an unavoidable non-determinism in the test -# please compare the results with the comments -# - - -source include/master-slave.inc; - -connection slave; - ---echo # Second_behind reports 0 -let $status_items= Seconds_Behind_Master; -source include/show_slave_status.inc; -sleep 3; - -### bug emulation - -connection master; -drop table if exists t1; -create table t1 (f1 int); -sleep 3; - -#connection slave; -sync_slave_with_master; -flush logs /* contaminate rli->last_master_timestamp */; - -connection slave; -lock table t1 write; - -connection master; -insert into t1 values (1); - -sleep 3; - -connection slave; ---echo # bug emulated: reports slave threads starting time about 3*3 not 3 secs -source include/show_slave_status.inc; -unlock tables; - -connection master; -sync_slave_with_master; - -### bugfix - - -connection slave; -flush logs /* this time rli->last_master_timestamp is not affected */; -lock table t1 write; - -connection master; -insert into t1 values (2); -sleep 3; - -connection slave; ---echo # reports the correct diff with master query time about 3+3 secs -source include/show_slave_status.inc; -unlock tables; - -connection master; -drop table t1; - ---source include/rpl_end.inc |