Debian Codegraph @

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

raw
1 connect server_1,127.0.0.1,root,,,$SERVER_MYPORT_1;
2 connect server_2,127.0.0.1,root,,,$SERVER_MYPORT_2;
3 connect server_3,127.0.0.1,root,,,$SERVER_MYPORT_3;
4 connection server_1;
5 set global binlog_alter_two_phase = ON;
6 set binlog_alter_two_phase = ON;
7 connection server_2;
8 stop slave;
9 Warnings:
10 Note 1255 Slave already has been stopped
11 set global binlog_alter_two_phase=true;
12 connection server_3;
13 SET STATEMENT sql_log_bin=0 FOR
14 CALL mtr.add_suppression("The table mysql.gtid_slave_pos was removed. This change will not take full effect until all SQL threads have been restarted");
15 SET STATEMENT sql_log_bin=0 FOR
16 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
17 SET GLOBAL slave_parallel_threads=8;
18 set global slave_parallel_mode=optimistic;
19 set global gtid_strict_mode=1;
20 connection server_1;
21 set gtid_domain_id= 11;
22 create database s1;
23 use s1;
24 connect master_node,127.0.0.1,root,,$db_name, $M_port;
25 set gtid_domain_id= 11;;
26 connect slave_node,127.0.0.1,root,,test, $S_port;
27 set gtid_domain_id= 11;;
28 # myisam
29 connection master_node;
30 create table t1(a int, b int) engine=myisam;;
31 insert into t1 values(1,1);
32 insert into t1 values(2,2);
33 # Normal Alter
34 alter table t1 add column c int;
35 show create table t1;
36 Table Create Table
37 t1 CREATE TABLE `t1` (
38 `a` int(11) DEFAULT NULL,
39 `b` int(11) DEFAULT NULL,
40 `c` int(11) DEFAULT NULL
41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
42 # Failed Alter
43 insert into t1 values(1,1, NULL);
44 alter table t1 change a a int unique;
45 ERROR 23000: Duplicate entry '1' for key 'a'
46 set @@session.binlog_alter_two_phase = 0;
47 alter table t1 change a a int;
48 set @@session.binlog_alter_two_phase = 1;
49 alter table t1 change a a int;
50 show create table t1;
51 Table Create Table
52 t1 CREATE TABLE `t1` (
53 `a` int(11) DEFAULT NULL,
54 `b` int(11) DEFAULT NULL,
55 `c` int(11) DEFAULT NULL
56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
57 connection master_node;
58 drop table t1;
59 # innodb
60 connection master_node;
61 create table t1(a int, b int) engine=innodb;;
62 insert into t1 values(1,1);
63 insert into t1 values(2,2);
64 # Normal Alter
65 alter table t1 add column c int;
66 show create table t1;
67 Table Create Table
68 t1 CREATE TABLE `t1` (
69 `a` int(11) DEFAULT NULL,
70 `b` int(11) DEFAULT NULL,
71 `c` int(11) DEFAULT NULL
72 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
73 # Failed Alter
74 insert into t1 values(1,1, NULL);
75 alter table t1 change a a int unique;
76 ERROR 23000: Duplicate entry '1' for key 'a'
77 set @@session.binlog_alter_two_phase = 0;
78 alter table t1 change a a int;
79 set @@session.binlog_alter_two_phase = 1;
80 alter table t1 change a a int;
81 show create table t1;
82 Table Create Table
83 t1 CREATE TABLE `t1` (
84 `a` int(11) DEFAULT NULL,
85 `b` int(11) DEFAULT NULL,
86 `c` int(11) DEFAULT NULL
87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
88 connection master_node;
89 drop table t1;
90 # aria
91 connection master_node;
92 create table t1(a int, b int) engine=aria;;
93 insert into t1 values(1,1);
94 insert into t1 values(2,2);
95 # Normal Alter
96 alter table t1 add column c int;
97 show create table t1;
98 Table Create Table
99 t1 CREATE TABLE `t1` (
100 `a` int(11) DEFAULT NULL,
101 `b` int(11) DEFAULT NULL,
102 `c` int(11) DEFAULT NULL
103 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
104 # Failed Alter
105 insert into t1 values(1,1, NULL);
106 alter table t1 change a a int unique;
107 ERROR 23000: Duplicate entry '1' for key 'a'
108 set @@session.binlog_alter_two_phase = 0;
109 alter table t1 change a a int;
110 set @@session.binlog_alter_two_phase = 1;
111 alter table t1 change a a int;
112 show create table t1;
113 Table Create Table
114 t1 CREATE TABLE `t1` (
115 `a` int(11) DEFAULT NULL,
116 `b` int(11) DEFAULT NULL,
117 `c` int(11) DEFAULT NULL
118 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
119 connection master_node;
120 drop table t1;
121 # concurrent alter Myisam
122 # Concurrent DML
123 # Rollback tests
124 ERROR 23000: Duplicate entry '2' for key 'b'
125 ERROR 23000: Duplicate entry '2' for key 'b'
126 ERROR 23000: Duplicate entry '2' for key 'b'
127 ERROR 23000: Duplicate entry '2' for key 'b'
128 ERROR 23000: Duplicate entry '2' for key 'b'
129 ERROR 23000: Duplicate entry '2' for key 'b'
130 ERROR 23000: Duplicate entry '2' for key 'b'
131 ERROR 23000: Duplicate entry '2' for key 'b'
132 ERROR 23000: Duplicate entry '2' for key 'b'
133 ERROR 23000: Duplicate entry '2' for key 'b'
134 # concurrent alter Aria
135 # Concurrent DML
136 # Rollback tests
137 ERROR 23000: Duplicate entry '2' for key 'b'
138 ERROR 23000: Duplicate entry '2' for key 'b'
139 ERROR 23000: Duplicate entry '2' for key 'b'
140 ERROR 23000: Duplicate entry '2' for key 'b'
141 ERROR 23000: Duplicate entry '2' for key 'b'
142 ERROR 23000: Duplicate entry '2' for key 'b'
143 ERROR 23000: Duplicate entry '2' for key 'b'
144 ERROR 23000: Duplicate entry '2' for key 'b'
145 ERROR 23000: Duplicate entry '2' for key 'b'
146 ERROR 23000: Duplicate entry '2' for key 'b'
147 # concurrent alter Innodb copy
148 # Concurrent DML
149 # Rollback tests
150 ERROR 23000: Duplicate entry '2' for key 'b'
151 ERROR 23000: Duplicate entry '2' for key 'b'
152 ERROR 23000: Duplicate entry '2' for key 'b'
153 ERROR 23000: Duplicate entry '2' for key 'b'
154 ERROR 23000: Duplicate entry '2' for key 'b'
155 ERROR 23000: Duplicate entry '2' for key 'b'
156 ERROR 23000: Duplicate entry '2' for key 'b'
157 ERROR 23000: Duplicate entry '2' for key 'b'
158 ERROR 23000: Duplicate entry '2' for key 'b'
159 ERROR 23000: Duplicate entry '2' for key 'b'
160 # concurrent alter Innodb Inplace
161 # Concurrent DML
162 # Rollback tests
163 ERROR 23000: Duplicate entry '2' for key 'b'
164 ERROR 23000: Duplicate entry '2' for key 'b'
165 ERROR 23000: Duplicate entry '2' for key 'b'
166 ERROR 23000: Duplicate entry '2' for key 'b'
167 ERROR 23000: Duplicate entry '2' for key 'b'
168 ERROR 23000: Duplicate entry '2' for key 'b'
169 ERROR 23000: Duplicate entry '2' for key 'b'
170 ERROR 23000: Duplicate entry '2' for key 'b'
171 ERROR 23000: Duplicate entry '2' for key 'b'
172 ERROR 23000: Duplicate entry '2' for key 'b'
173 connection server_1;
174 drop database s1;
175 select @@gtid_binlog_pos;
176 @@gtid_binlog_pos
177 11-1-412
178 connection server_2;
179 set gtid_domain_id= 12;
180 create database s2;
181 use s2;
182 connect master_node,127.0.0.1,root,,$db_name, $M_port;
183 set gtid_domain_id= 12;;
184 connect slave_node,127.0.0.1,root,,test, $S_port;
185 set gtid_domain_id= 12;;
186 # myisam
187 connection master_node;
188 create table t1(a int, b int) engine=myisam;;
189 insert into t1 values(1,1);
190 insert into t1 values(2,2);
191 # Normal Alter
192 alter table t1 add column c int;
193 show create table t1;
194 Table Create Table
195 t1 CREATE TABLE `t1` (
196 `a` int(11) DEFAULT NULL,
197 `b` int(11) DEFAULT NULL,
198 `c` int(11) DEFAULT NULL
199 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
200 # Failed Alter
201 insert into t1 values(1,1, NULL);
202 alter table t1 change a a int unique;
203 ERROR 23000: Duplicate entry '1' for key 'a'
204 set @@session.binlog_alter_two_phase = 0;
205 alter table t1 change a a int;
206 set @@session.binlog_alter_two_phase = 1;
207 alter table t1 change a a int;
208 show create table t1;
209 Table Create Table
210 t1 CREATE TABLE `t1` (
211 `a` int(11) DEFAULT NULL,
212 `b` int(11) DEFAULT NULL,
213 `c` int(11) DEFAULT NULL
214 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
215 connection master_node;
216 drop table t1;
217 # innodb
218 connection master_node;
219 create table t1(a int, b int) engine=innodb;;
220 insert into t1 values(1,1);
221 insert into t1 values(2,2);
222 # Normal Alter
223 alter table t1 add column c int;
224 show create table t1;
225 Table Create Table
226 t1 CREATE TABLE `t1` (
227 `a` int(11) DEFAULT NULL,
228 `b` int(11) DEFAULT NULL,
229 `c` int(11) DEFAULT NULL
230 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
231 # Failed Alter
232 insert into t1 values(1,1, NULL);
233 alter table t1 change a a int unique;
234 ERROR 23000: Duplicate entry '1' for key 'a'
235 set @@session.binlog_alter_two_phase = 0;
236 alter table t1 change a a int;
237 set @@session.binlog_alter_two_phase = 1;
238 alter table t1 change a a int;
239 show create table t1;
240 Table Create Table
241 t1 CREATE TABLE `t1` (
242 `a` int(11) DEFAULT NULL,
243 `b` int(11) DEFAULT NULL,
244 `c` int(11) DEFAULT NULL
245 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
246 connection master_node;
247 drop table t1;
248 # aria
249 connection master_node;
250 create table t1(a int, b int) engine=aria;;
251 insert into t1 values(1,1);
252 insert into t1 values(2,2);
253 # Normal Alter
254 alter table t1 add column c int;
255 show create table t1;
256 Table Create Table
257 t1 CREATE TABLE `t1` (
258 `a` int(11) DEFAULT NULL,
259 `b` int(11) DEFAULT NULL,
260 `c` int(11) DEFAULT NULL
261 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
262 # Failed Alter
263 insert into t1 values(1,1, NULL);
264 alter table t1 change a a int unique;
265 ERROR 23000: Duplicate entry '1' for key 'a'
266 set @@session.binlog_alter_two_phase = 0;
267 alter table t1 change a a int;
268 set @@session.binlog_alter_two_phase = 1;
269 alter table t1 change a a int;
270 show create table t1;
271 Table Create Table
272 t1 CREATE TABLE `t1` (
273 `a` int(11) DEFAULT NULL,
274 `b` int(11) DEFAULT NULL,
275 `c` int(11) DEFAULT NULL
276 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
277 connection master_node;
278 drop table t1;
279 # concurrent alter Myisam
280 # Concurrent DML
281 # Rollback tests
282 ERROR 23000: Duplicate entry '2' for key 'b'
283 ERROR 23000: Duplicate entry '2' for key 'b'
284 ERROR 23000: Duplicate entry '2' for key 'b'
285 ERROR 23000: Duplicate entry '2' for key 'b'
286 ERROR 23000: Duplicate entry '2' for key 'b'
287 ERROR 23000: Duplicate entry '2' for key 'b'
288 ERROR 23000: Duplicate entry '2' for key 'b'
289 ERROR 23000: Duplicate entry '2' for key 'b'
290 ERROR 23000: Duplicate entry '2' for key 'b'
291 ERROR 23000: Duplicate entry '2' for key 'b'
292 # concurrent alter Aria
293 # Concurrent DML
294 # Rollback tests
295 ERROR 23000: Duplicate entry '2' for key 'b'
296 ERROR 23000: Duplicate entry '2' for key 'b'
297 ERROR 23000: Duplicate entry '2' for key 'b'
298 ERROR 23000: Duplicate entry '2' for key 'b'
299 ERROR 23000: Duplicate entry '2' for key 'b'
300 ERROR 23000: Duplicate entry '2' for key 'b'
301 ERROR 23000: Duplicate entry '2' for key 'b'
302 ERROR 23000: Duplicate entry '2' for key 'b'
303 ERROR 23000: Duplicate entry '2' for key 'b'
304 ERROR 23000: Duplicate entry '2' for key 'b'
305 # concurrent alter Innodb copy
306 # Concurrent DML
307 # Rollback tests
308 ERROR 23000: Duplicate entry '2' for key 'b'
309 ERROR 23000: Duplicate entry '2' for key 'b'
310 ERROR 23000: Duplicate entry '2' for key 'b'
311 ERROR 23000: Duplicate entry '2' for key 'b'
312 ERROR 23000: Duplicate entry '2' for key 'b'
313 ERROR 23000: Duplicate entry '2' for key 'b'
314 ERROR 23000: Duplicate entry '2' for key 'b'
315 ERROR 23000: Duplicate entry '2' for key 'b'
316 ERROR 23000: Duplicate entry '2' for key 'b'
317 ERROR 23000: Duplicate entry '2' for key 'b'
318 # concurrent alter Innodb Inplace
319 # Concurrent DML
320 # Rollback tests
321 ERROR 23000: Duplicate entry '2' for key 'b'
322 ERROR 23000: Duplicate entry '2' for key 'b'
323 ERROR 23000: Duplicate entry '2' for key 'b'
324 ERROR 23000: Duplicate entry '2' for key 'b'
325 ERROR 23000: Duplicate entry '2' for key 'b'
326 ERROR 23000: Duplicate entry '2' for key 'b'
327 ERROR 23000: Duplicate entry '2' for key 'b'
328 ERROR 23000: Duplicate entry '2' for key 'b'
329 ERROR 23000: Duplicate entry '2' for key 'b'
330 ERROR 23000: Duplicate entry '2' for key 'b'
331 connection server_2;
332 drop database s2;
333 select @@gtid_binlog_pos;
334 @@gtid_binlog_pos
335 12-2-412
336 connection server_3;
337 start all slaves;
338 Warnings:
339 Note 1937 SLAVE 'm2' started
340 Note 1937 SLAVE 'm1' started
341 set default_master_connection = 'm1';
342 include/wait_for_slave_to_start.inc
343 set default_master_connection = 'm2';
344 include/wait_for_slave_to_start.inc
345 set default_master_connection = 'm1';
346 include/sync_with_master_gtid.inc
347 set default_master_connection = 'm2';
348 include/sync_with_master_gtid.inc
349 # cleanup
350 connection server_3;
351 set default_master_connection = 'm1';
352 include/stop_slave.inc
353 set default_master_connection = 'm2';
354 include/stop_slave.inc
355 set global slave_parallel_threads = 0;;
356 set global slave_parallel_mode = optimistic;;
357 set global gtid_strict_mode = 0;;
358 set global gtid_domain_id= 0;
359 reset master;
360 RESET SLAVE ALL;
361 SET GLOBAL gtid_slave_pos= '';
362 connection server_1;
363 set global binlog_alter_two_phase=0;;
364 set global gtid_domain_id= 0;
365 reset master;
366 connection server_2;
367 set global gtid_domain_id= 0;
368 set global binlog_alter_two_phase=0;
369 reset master;
370 disconnect server_1;
371 disconnect server_2;
372 disconnect server_3;