Debian Codegraph @

mysql-test/suite/rpl/r/slave_abort_blocking_timeout.result

raw
1 include/master-slave.inc
2 [connection master]
3 *** Testcase to show how a long-running SELECT can block replication from proceeding
4 *** past a DDL. Intention to implement a timeout after which such SELECT can be
5 *** killed.
6 connection master;
7 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
8 INSERT INTO t1 SELECT seq, 100+seq FROM seq_1_to_20;
9 connection slave;
10 include/stop_slave.inc
11 SELECT @@GLOBAL.slave_abort_blocking_timeout;
12 @@GLOBAL.slave_abort_blocking_timeout
13 31536000.000000
14 SET @old_abort_timeout= @@slave_abort_blocking_timeout;
15 SET GLOBAL slave_abort_blocking_timeout= -1;
16 Warnings:
17 Warning 1292 Truncated incorrect slave_abort_blocking_timeout value: '-1'
18 SELECT @@GLOBAL.slave_abort_blocking_timeout;
19 @@GLOBAL.slave_abort_blocking_timeout
20 0.000000
21 SET GLOBAL slave_abort_blocking_timeout= 1.0;
22 SELECT @@GLOBAL.slave_abort_blocking_timeout;
23 @@GLOBAL.slave_abort_blocking_timeout
24 1.000000
25 connection server_2;
26 SELECT X.a, SLEEP(IF((X.b MOD 2)=0, 0.4, 0.6)) FROM t1 X CROSS JOIN t1 Y;
27 connection slave;
28 connection master;
29 UPDATE t1 SET b=b+1000 WHERE a=1;
30 ALTER TABLE t1 ADD INDEX b_idx(b);
31 UPDATE t1 SET b=b+1000 WHERE a=20;
32 connection slave;
33 include/start_slave.inc
34 connection server_2;
35 ERROR 70100: Query execution was interrupted
36 connection slave;
37 SHOW CREATE TABLE t1;
38 Table t1
39 Create Table CREATE TABLE `t1` (
40 `a` int(11) NOT NULL,
41 `b` int(11) DEFAULT NULL,
42 PRIMARY KEY (`a`),
43 KEY `b_idx` (`b`)
44 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
45 include/stop_slave.inc
46 SET GLOBAL slave_abort_blocking_timeout= 0;
47 SELECT @@GLOBAL.slave_abort_blocking_timeout;
48 @@GLOBAL.slave_abort_blocking_timeout
49 0.000000
50 connection server_2;
51 SELECT X.a, SLEEP(IF((X.b MOD 2)=0, 0.4, 0.6)) FROM t1 X CROSS JOIN t1 Y;
52 connection slave;
53 connection master;
54 UPDATE t1 SET b=b+1000 WHERE a=1;
55 ALTER TABLE t1 DROP INDEX b_idx;
56 UPDATE t1 SET b=b+1000 WHERE a=20;
57 connection slave;
58 include/start_slave.inc
59 connection server_2;
60 ERROR 70100: Query execution was interrupted
61 connection slave;
62 SHOW CREATE TABLE t1;
63 Table t1
64 Create Table CREATE TABLE `t1` (
65 `a` int(11) NOT NULL,
66 `b` int(11) DEFAULT NULL,
67 PRIMARY KEY (`a`)
68 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
69 include/stop_slave.inc
70 SET GLOBAL slave_abort_blocking_timeout= @old_abort_timeout;
71 include/start_slave.inc
72 connection master;
73 DROP TABLE t1;
74 include/rpl_end.inc