Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 *** MDEV-6321: close_temporary_tables() in format description event not serialised correctly ***
3 connection server_2;
4 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
5 include/stop_slave.inc
6 SET GLOBAL slave_parallel_threads=5;
7 include/start_slave.inc
8 connection server_1;
9 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(100) CHARACTER SET utf8);
10 connection server_2;
11 include/stop_slave.inc
12 connection server_1;
13 SET gtid_domain_id= 1;
14 INSERT INTO t1 VALUES (1, 0);
15 CREATE TEMPORARY TABLE t2 (a int);
16 connection default;
17 SET gtid_domain_id= 2;
18 CREATE TEMPORARY TABLE t3 (a INT PRIMARY KEY);
19 CREATE TEMPORARY TABLE t4 (a int);
20 INSERT INTO t3 VALUES (100);
21 INSERT INTO t4 SELECT a+1 FROM t3;
22 connection server_1;
23 INSERT INTO t2 VALUES (2), (4), (6), (8), (10), (12), (14), (16), (18), (20);
24 INSERT INTO t2 VALUES (3), (6), (9), (12), (15), (18);
25 INSERT INTO t2 VALUES (4), (8), (12), (16), (20);
26 connection default;
27 INSERT INTO t3 SELECT a+2 FROM t4;
28 INSERT INTO t4 SELECT a+4 FROM t3;
29 connection server_1;
30 INSERT INTO t2 VALUES (5), (10), (15), (20);
31 INSERT INTO t2 VALUES (6), (12), (18);
32 INSERT INTO t2 VALUES (7), (14);
33 INSERT INTO t2 VALUES (8), (16);
34 INSERT INTO t2 VALUES (9), (18);
35 INSERT INTO t2 VALUES (10), (20);
36 connection default;
37 INSERT INTO t3 SELECT a+8 FROM t4;
38 INSERT INTO t4 SELECT a+16 FROM t3;
39 connection server_1;
40 INSERT INTO t2 VALUES (11);
41 INSERT INTO t2 VALUES (12);
42 INSERT INTO t2 VALUES (13);
43 connection default;
44 INSERT INTO t3 SELECT a+32 FROM t4;
45 connection server_1;
46 INSERT INTO t2 VALUES (14);
47 INSERT INTO t2 VALUES (15);
48 INSERT INTO t2 VALUES (16);
49 connection default;
50 INSERT INTO t4 SELECT a+64 FROM t3;
51 connection server_1;
52 INSERT INTO t2 VALUES (17);
53 INSERT INTO t2 VALUES (18);
54 INSERT INTO t2 VALUES (19);
55 connection default;
56 INSERT INTO t3 SELECT a+128 FROM t4;
57 connection server_1;
58 INSERT INTO t2 VALUES (20);
59 connection default;
60 INSERT INTO t1 SELECT a, a MOD 7 FROM t3;
61 INSERT INTO t1 SELECT a, a MOD 7 FROM t4;
62 connection server_1;
63 INSERT INTO t1 SELECT a, COUNT(*) FROM t2 GROUP BY a;
64 FLUSH TABLES;
65 SET SESSION debug_dbug="+d,crash_dispatch_command_before";
66 SELECT 1;
67 Got one of the listed errors
68 connection default;
69 connection default;
70 connection server_1;
71 INSERT INTO t1 VALUES (0, 1);
72 connection server_2;
73 include/start_slave.inc
74 SELECT * FROM t1 WHERE a <= 20 ORDER BY a;
75 a b
76 0 1
77 1 0
78 2 1
79 3 1
80 4 2
81 5 1
82 6 3
83 7 1
84 8 3
85 9 2
86 10 3
87 11 1
88 12 5
89 13 1
90 14 3
91 15 3
92 16 4
93 17 1
94 18 5
95 19 1
96 20 5
97 SELECT COUNT(*) FROM t1 WHERE a BETWEEN 100+0 AND 100+256;
98 COUNT(*)
99 55
100 SHOW STATUS LIKE 'Slave_open_temp_tables';
101 Variable_name Value
102 Slave_open_temp_tables 0
103 *** Test that if master logged partial event group before crash, we finish that group correctly before executing format description event ***
104 include/stop_slave.inc
105 connection server_1;
106 CALL mtr.add_suppression("Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them");
107 SET gtid_domain_id= 1;
108 DELETE FROM t1;
109 ALTER TABLE t1 ENGINE=InnoDB;
110 CREATE TEMPORARY TABLE t2 (a INT PRIMARY KEY);
111 INSERT INTO t2 VALUES (1);
112 INSERT INTO t2 VALUES (2);
113 connection default;
114 SET gtid_domain_id= 2;
115 CREATE TEMPORARY TABLE t3 (a INT PRIMARY KEY);
116 INSERT INTO t3 VALUES (10);
117 INSERT INTO t3 VALUES (20);
118 connection server_1;
119 INSERT INTO t1 SELECT a, 'server_1' FROM t2;
120 connection default;
121 INSERT INTO t1 SELECT a, 'default' FROM t3;
122 connection server_1;
123 INSERT INTO t1 SELECT a+2, '+server_1' FROM t2;
124 FLUSH TABLES;
125 SET SESSION debug_dbug="+d,crash_before_writing_xid";
126 INSERT INTO t1 SELECT a+4, '++server_1' FROM t2;
127 Got one of the listed errors
128 connection default;
129 connection default;
130 connection server_1;
131 INSERT INTO t1 VALUES (0, 1);
132 include/save_master_gtid.inc
133 connection server_2;
134 set @@sql_log_bin=0;
135 call mtr.add_suppression("Unexpected break of being relay-logged GTID 1-1-32 event group by the current GTID event 0-1-4");
136 set @@sql_log_bin=1;
137 set @@global.debug_dbug="+d,slave_discard_xid_for_gtid_0_x_1000";
138 include/start_slave.inc
139 include/sync_with_master_gtid.inc
140 set @@global.debug_dbug="";
141 SELECT * FROM t1 ORDER BY a;
142 a b
143 0 1
144 1 server_1
145 2 server_1
146 3 +server_1
147 4 +server_1
148 10 default
149 20 default
150 SHOW STATUS LIKE 'Slave_open_temp_tables';
151 Variable_name Value
152 Slave_open_temp_tables 0
153 connection server_1;
154 FLUSH LOGS;
155 *** MDEV-7936: Assertion `!table || table->in_use == _current_thd()' failed on parallel replication in optimistic mode ***
156 connection server_1;
157 CREATE TEMPORARY TABLE t4 (a INT PRIMARY KEY) ENGINE=InnoDB;
158 SET @old_dbug= @@SESSION.debug_dbug;
159 SET SESSION debug_dbug="+d,binlog_force_commit_id";
160 SET @commit_id= 10000;
161 INSERT INTO t4 VALUES (30);
162 INSERT INTO t4 VALUES (31);
163 SET SESSION debug_dbug= @old_dbug;
164 INSERT INTO t1 SELECT a, "conservative" FROM t4;
165 DROP TEMPORARY TABLE t4;
166 SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
167 a b
168 30 conservative
169 31 conservative
170 include/save_master_gtid.inc
171 connection server_2;
172 include/sync_with_master_gtid.inc
173 SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
174 a b
175 30 conservative
176 31 conservative
177 include/stop_slave.inc
178 SET @old_mode= @@GLOBAL.slave_parallel_mode;
179 SET GLOBAL slave_parallel_mode=optimistic;
180 connection server_1;
181 CREATE TEMPORARY TABLE t4 (a INT PRIMARY KEY) ENGINE=InnoDB;
182 INSERT INTO t4 VALUES (32);
183 INSERT INTO t4 VALUES (33);
184 INSERT INTO t1 SELECT a, "optimistic" FROM t4;
185 DROP TEMPORARY TABLE t4;
186 SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
187 a b
188 30 conservative
189 31 conservative
190 32 optimistic
191 33 optimistic
192 include/save_master_gtid.inc
193 connection server_2;
194 include/start_slave.inc
195 include/sync_with_master_gtid.inc
196 SELECT * FROM t1 WHERE a >= 30 ORDER BY a;
197 a b
198 30 conservative
199 31 conservative
200 32 optimistic
201 33 optimistic
202 include/stop_slave.inc
203 SET GLOBAL slave_parallel_mode=@old_mode;
204 include/start_slave.inc
205 *** MDEV33426: Memory allocation accounting incorrect for replicated temptable
206 connection server_1;
207 CREATE TEMPORARY TABLE t5 (a int) ENGINE=Aria;
208 CREATE TEMPORARY TABLE t6 (a int) ENGINE=Heap;
209 INSERT INTO t5 VALUES (1);
210 INSERT INTO t6 VALUES (2);
211 connection server_2;
212 include/stop_slave.inc
213 connection server_1;
214 INSERT INTO t1 SELECT a+40, 5 FROM t5;
215 INSERT INTO t1 SELECT a+40, 6 FROM t6;
216 DROP TABLE t5, t6;
217 connection server_2;
218 include/start_slave.inc
219 SELECT * FROM t1 WHERE a>=40 ORDER BY a;
220 a b
221 41 5
222 42 6
223 connection server_2;
224 include/stop_slave.inc
225 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
226 include/start_slave.inc
227 connection server_1;
228 DROP TABLE t1;
229 include/rpl_end.inc