rpl_replication_delay.test 1.47 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
#
# 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 master;
#connection slave;
sync_slave_with_master;
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
--replace_column 1 # 8 # 9 # 23 #
--query_vertical show slave status /* Second_behind reports 0 */;
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;
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
--replace_column 1 # 8 # 9 # 23 #
--query_vertical show slave status /* bug emulated: reports slave threads starting time about 3*3 not 3 secs */;
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;
--replace_result $DEFAULT_MASTER_PORT DEFAULT_MASTER_PORT
--replace_column 1 # 8 # 9 # 23 #
--query_vertical show slave status /* reports the correct diff with master query time about 3+3 secs */;
unlock tables;

connection master;
drop table t1;

#connection slave;
sync_slave_with_master;


# End of tests