Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mdev8193.test

raw
1 --source include/have_binlog_format_statement.inc
2 --source include/master-slave.inc
3
4 --connection slave
5
6 --source include/stop_slave_sql.inc
7
8 --connection master
9
10 CALL mtr.add_suppression("Statement is unsafe because it uses a system function that may return a different value on the slave");
11 create table t1 (i int);
12 insert into t1 values (1),(2);
13 insert into t1 values (3),(4);
14 # This sleep() helps trigger the failure more reliably.
15 insert into t1 select i+20+0*sleep(1) from t1 where i=1;
16 flush logs;
17 insert into t1 values (5),(6);
18 insert into t1 values (7),(8);
19 insert into t1 values (9),(10);
20
21 --let $master_file = query_get_value(show master status,File,1)
22 --let $master_pos = query_get_value(show master status,Position,1)
23
24 insert into t1 values (11),(12);
25 insert into t1 values (13),(14);
26 insert into t1 values (15),(16);
27
28 --connection slave
29
30 set global slave_parallel_threads = 1;
31 --replace_result $master_file MASTER_FILE $master_pos MASTER_POS
32 eval start slave until master_log_file='$master_file', master_log_pos=$master_pos;
33
34 --let $show_statement = SHOW SLAVE STATUS
35 --let $field = Slave_SQL_Running
36 --let $condition = = 'No'
37 --let $wait_timeout = 10
38
39 --source include/wait_show_condition.inc
40
41 if (`select COUNT(*) > 11 from t1`)
42 {
43 query_vertical show slave status;
44 SELECT * FROM t1;
45 die "Wrong number of rows in the table";
46 }
47
48 drop table t1;
49 --source include/stop_slave_io.inc
50 set global slave_parallel_threads = DEFAULT;
51
52 --connection master
53 drop table t1;
54
55 --let $rpl_only_running_threads= 1
56 --source include/rpl_end.inc