Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/have_binlog_format_mixed.inc
4 --source include/master-slave.inc
5
6 --echo *** Testcase to show how a long-running SELECT can block replication from proceeding
7 --echo *** past a DDL. Intention to implement a timeout after which such SELECT can be
8 --echo *** killed.
9
10 --connection master
11 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
12 INSERT INTO t1 SELECT seq, 100+seq FROM seq_1_to_20;
13
14 --sync_slave_with_master
15
16 --source include/stop_slave.inc
17 SELECT @@GLOBAL.slave_abort_blocking_timeout;
18 SET @old_abort_timeout= @@slave_abort_blocking_timeout;
19 SET GLOBAL slave_abort_blocking_timeout= -1;
20 SELECT @@GLOBAL.slave_abort_blocking_timeout;
21 SET GLOBAL slave_abort_blocking_timeout= 1.0;
22 SELECT @@GLOBAL.slave_abort_blocking_timeout;
23 --connection server_2
24 # Start a SELECT that will run for long.
25 send SELECT X.a, SLEEP(IF((X.b MOD 2)=0, 0.4, 0.6)) FROM t1 X CROSS JOIN t1 Y;
26
27 --connection slave
28 # Wait for the SELECT to have started so it will block the coming DDL
29 # from replicating.
30 --let $wait_condition= SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE state = 'User sleep'
31 --source include/wait_condition.inc
32
33 --connection master
34 UPDATE t1 SET b=b+1000 WHERE a=1;
35 ALTER TABLE t1 ADD INDEX b_idx(b);
36 UPDATE t1 SET b=b+1000 WHERE a=20;
37
38 --save_master_pos
39 --connection slave
40 --source include/start_slave.inc
41 --sync_with_master
42
43 --connection server_2
44 --error ER_QUERY_INTERRUPTED
45 reap;
46
47 --connection slave
48 query_vertical SHOW CREATE TABLE t1;
49
50 # Do it again to test that a timeout of 0 also works to abort user queries.
51 --source include/stop_slave.inc
52 SET GLOBAL slave_abort_blocking_timeout= 0;
53 SELECT @@GLOBAL.slave_abort_blocking_timeout;
54 --connection server_2
55 send SELECT X.a, SLEEP(IF((X.b MOD 2)=0, 0.4, 0.6)) FROM t1 X CROSS JOIN t1 Y;
56
57 --connection slave
58 --let $wait_condition= SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE state = 'User sleep'
59 --source include/wait_condition.inc
60
61 --connection master
62 UPDATE t1 SET b=b+1000 WHERE a=1;
63 ALTER TABLE t1 DROP INDEX b_idx;
64 UPDATE t1 SET b=b+1000 WHERE a=20;
65
66 --save_master_pos
67 --connection slave
68 --source include/start_slave.inc
69 --sync_with_master
70
71 --connection server_2
72 --error ER_QUERY_INTERRUPTED
73 reap;
74
75 --connection slave
76 query_vertical SHOW CREATE TABLE t1;
77
78
79 --source include/stop_slave.inc
80 SET GLOBAL slave_abort_blocking_timeout= @old_abort_timeout;
81 --source include/start_slave.inc
82
83 --connection master
84 DROP TABLE t1;
85 --source include/rpl_end.inc