Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 create table t1 (a int) engine=innodb;
5 create table t2 (a int) engine=innodb;
6 insert into t1 values (1);
7 include/save_master_gtid.inc
8 connection slave;
9 call mtr.add_suppression("Slave: Commit failed due to failure of an earlier commit on which this one depends");
10 include/sync_with_master_gtid.inc
11 include/stop_slave.inc
12 set @save.slave_parallel_threads= @@global.slave_parallel_threads;
13 set @save.slave_parallel_mode= @@global.slave_parallel_mode;
14 set @@global.slave_parallel_threads= 3;
15 set @@global.slave_parallel_mode= CONSERVATIVE;
16 connection slave1;
17 BEGIN;
18 update t1 set a=2 where a=1;
19 connection master;
20 SET @old_dbug= @@SESSION.debug_dbug;
21 SET @@SESSION.debug_dbug="+d,binlog_force_commit_id";
22 SET @commit_id= 10000;
23 update t1 set a=2 where a=1;
24 insert into t2 values (1);
25 SET @commit_id= 10001;
26 insert into t1 values (3);
27 connection slave;
28 include/start_slave.inc
29 kill $t3_tid;
30 connection slave1;
31 commit;
32 connection slave;
33 include/wait_for_slave_sql_error.inc [errno=1032]
34 update t1 set a=1 where a=2;
35 set @@global.slave_parallel_threads = @save.slave_parallel_threads;
36 set @@global.slave_parallel_mode = @save.slave_parallel_mode;
37 include/start_slave.inc
38 #
39 # Cleanup
40 connection master;
41 DROP TABLE t1, t2;
42 include/save_master_gtid.inc
43 connection slave;
44 include/sync_with_master_gtid.inc
45 # MDEV-31448 OOO finish event group by killed worker
46 # Initialize test data
47 connection master;
48 create table t1 (a int) engine=innodb;
49 create table t2 (a int) engine=innodb;
50 insert into t1 values (1);
51 include/save_master_gtid.inc
52 connection slave;
53 call mtr.add_suppression("Connection was killed");
54 call mtr.add_suppression("Can.t find record");
55 include/sync_with_master_gtid.inc
56 include/stop_slave.inc
57 set @save.slave_parallel_threads= @@global.slave_parallel_threads;
58 set @save.slave_parallel_mode= @@global.slave_parallel_mode;
59 set @@global.slave_parallel_threads= 3;
60 set @@global.slave_parallel_mode= OPTIMISTIC;
61 connection slave1;
62 begin;
63 update t1 set a=2 where a=1;
64 connection master;
65 set @old_dbug= @@session.debug_dbug;
66 set @@session.debug_dbug="+d,binlog_force_commit_id";
67 set @commit_id= 10000;
68 update t1 set a=2 where a=1;
69 insert into t2 values (1);
70 drop table t2;
71 connection slave;
72 include/start_slave.inc
73 # wait for T1
74 # wait for T2
75 # wait for T3
76 kill $t2_tid;
77 include/wait_for_slave_param.inc [Last_Errno]
78 connection slave1;
79 commit;
80 connection slave;
81 include/wait_for_slave_sql_error.inc [errno=1032]
82 update t1 set a=1 where a=2;
83 set @@global.slave_parallel_threads = @save.slave_parallel_threads;
84 set @@global.slave_parallel_mode = @save.slave_parallel_mode;
85 include/start_slave.inc
86 #
87 # Cleanup
88 connection master;
89 drop table t1;
90 include/save_master_gtid.inc
91 connection slave;
92 include/sync_with_master_gtid.inc
93 # MDEV-31448 OOO finish event group by killed worker
94 # Initialize test data
95 connection master;
96 create table t1 (a int) engine=innodb;
97 create table t2 (a int) engine=innodb;
98 insert into t1 values (1);
99 include/save_master_gtid.inc
100 connection slave;
101 call mtr.add_suppression("Connection was killed");
102 call mtr.add_suppression("Can.t find record");
103 include/sync_with_master_gtid.inc
104 include/stop_slave.inc
105 set @save.slave_parallel_threads= @@global.slave_parallel_threads;
106 set @save.slave_parallel_mode= @@global.slave_parallel_mode;
107 set @@global.slave_parallel_threads= 3;
108 set @@global.slave_parallel_mode= OPTIMISTIC;
109 connection slave1;
110 begin;
111 update t1 set a=2 where a=1;
112 connection master;
113 set @old_dbug= @@session.debug_dbug;
114 set @@session.debug_dbug="+d,binlog_force_commit_id";
115 set @commit_id= 10000;
116 update t1 set a=2 where a=1;
117 set @commit_id= 10001;
118 set statement skip_parallel_replication=1 for insert into t2 values (1);
119 drop table t2;
120 connection slave;
121 include/start_slave.inc
122 # wait for T1
123 # wait for T2
124 # wait for T3
125 kill $t2_tid;
126 include/wait_for_slave_param.inc [Last_Errno]
127 connection slave1;
128 commit;
129 connection slave;
130 include/wait_for_slave_sql_error.inc [errno=1032]
131 update t1 set a=1 where a=2;
132 set @@global.slave_parallel_threads = @save.slave_parallel_threads;
133 set @@global.slave_parallel_mode = @save.slave_parallel_mode;
134 include/start_slave.inc
135 #
136 # Cleanup
137 connection master;
138 drop table t1;
139 include/save_master_gtid.inc
140 connection slave;
141 include/sync_with_master_gtid.inc
142 include/rpl_end.inc