Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_stop_on_con_kill.result

raw
1 *** MDEV-8031: Parallel replication stops on "connection killed" error (probably incorrectly handled deadlock kill) ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
6 include/stop_slave.inc
7 SET GLOBAL slave_parallel_threads=10;
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 include/start_slave.inc
10 connection server_1;
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 CREATE TABLE t3 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
13 INSERT INTO t3 VALUES (201,0), (202,0);
14 include/save_master_gtid.inc
15 connection server_2;
16 include/sync_with_master_gtid.inc
17 include/stop_slave.inc
18 SET @old_dbug= @@GLOBAL.debug_dbug;
19 SET GLOBAL debug_dbug= '+d,inject_mdev8031';
20 connection server_1;
21 SET @old_dbug= @@SESSION.debug_dbug;
22 SET SESSION debug_dbug="+d,binlog_force_commit_id";
23 SET @commit_id= 10200;
24 INSERT INTO t3 VALUES (203, 1);
25 INSERT INTO t3 VALUES (204, 1);
26 INSERT INTO t3 VALUES (205, 1);
27 UPDATE t3 SET b=b+1 WHERE a=201;
28 UPDATE t3 SET b=b+1 WHERE a=201;
29 UPDATE t3 SET b=b+1 WHERE a=201;
30 UPDATE t3 SET b=b+1 WHERE a=202;
31 UPDATE t3 SET b=b+1 WHERE a=202;
32 UPDATE t3 SET b=b+1 WHERE a=202;
33 UPDATE t3 SET b=b+1 WHERE a=202;
34 UPDATE t3 SET b=b+1 WHERE a=203;
35 UPDATE t3 SET b=b+1 WHERE a=203;
36 UPDATE t3 SET b=b+1 WHERE a=204;
37 UPDATE t3 SET b=b+1 WHERE a=204;
38 UPDATE t3 SET b=b+1 WHERE a=204;
39 UPDATE t3 SET b=b+1 WHERE a=203;
40 UPDATE t3 SET b=b+1 WHERE a=205;
41 UPDATE t3 SET b=b+1 WHERE a=205;
42 SET SESSION debug_dbug=@old_dbug;
43 SELECT * FROM t3 WHERE a>=200 ORDER BY a;
44 a b
45 201 3
46 202 4
47 203 4
48 204 4
49 205 3
50 include/save_master_gtid.inc
51 connection server_2;
52 include/start_slave.inc
53 include/sync_with_master_gtid.inc
54 SELECT * FROM t3 WHERE a>=200 ORDER BY a;
55 a b
56 201 3
57 202 4
58 203 4
59 204 4
60 205 3
61 include/stop_slave.inc
62 SET GLOBAL debug_dbug= @old_dbug;
63 include/start_slave.inc
64 *** Check getting deadlock killed inside open_binlog() during retry. ***
65 connection server_2;
66 include/stop_slave.inc
67 SET @old_dbug= @@GLOBAL.debug_dbug;
68 SET GLOBAL debug_dbug= '+d,inject_retry_event_group_open_binlog_kill';
69 SET @old_max= @@GLOBAL.max_relay_log_size;
70 SET GLOBAL max_relay_log_size= 4096;
71 connection server_1;
72 SET @old_dbug= @@SESSION.debug_dbug;
73 SET SESSION debug_dbug="+d,binlog_force_commit_id";
74 SET @commit_id= 10210;
75 Omit long queries that cause relaylog rotations and transaction retries...
76 SET SESSION debug_dbug=@old_dbug;
77 SELECT * FROM t3 WHERE a>=200 ORDER BY a;
78 a b
79 201 6
80 202 8
81 203 7
82 204 7
83 205 5
84 include/save_master_gtid.inc
85 connection server_2;
86 include/start_slave.inc
87 include/sync_with_master_gtid.inc
88 SELECT * FROM t3 WHERE a>=200 ORDER BY a;
89 a b
90 201 6
91 202 8
92 203 7
93 204 7
94 205 5
95 include/stop_slave.inc
96 SET GLOBAL debug_dbug= @old_debg;
97 SET GLOBAL max_relay_log_size= @old_max;
98 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
99 include/start_slave.inc
100 connection server_1;
101 DROP TABLE t3;
102 include/rpl_end.inc