Debian Codegraph @

mysql-test/suite/rpl/r/rpl_start_alter_8.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=20;
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 connection server_2;
176 set gtid_domain_id= 12;
177 create database s2;
178 use s2;
179 connect master_node,127.0.0.1,root,,$db_name, $M_port;
180 set gtid_domain_id= 12;;
181 connect slave_node,127.0.0.1,root,,test, $S_port;
182 set gtid_domain_id= 12;;
183 # myisam
184 connection master_node;
185 create table t1(a int, b int) engine=myisam;;
186 insert into t1 values(1,1);
187 insert into t1 values(2,2);
188 # Normal Alter
189 alter table t1 add column c int;
190 show create table t1;
191 Table Create Table
192 t1 CREATE TABLE `t1` (
193 `a` int(11) DEFAULT NULL,
194 `b` int(11) DEFAULT NULL,
195 `c` int(11) DEFAULT NULL
196 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
197 # Failed Alter
198 insert into t1 values(1,1, NULL);
199 alter table t1 change a a int unique;
200 ERROR 23000: Duplicate entry '1' for key 'a'
201 set @@session.binlog_alter_two_phase = 0;
202 alter table t1 change a a int;
203 set @@session.binlog_alter_two_phase = 1;
204 alter table t1 change a a int;
205 show create table t1;
206 Table Create Table
207 t1 CREATE TABLE `t1` (
208 `a` int(11) DEFAULT NULL,
209 `b` int(11) DEFAULT NULL,
210 `c` int(11) DEFAULT NULL
211 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
212 connection master_node;
213 drop table t1;
214 # innodb
215 connection master_node;
216 create table t1(a int, b int) engine=innodb;;
217 insert into t1 values(1,1);
218 insert into t1 values(2,2);
219 # Normal Alter
220 alter table t1 add column c int;
221 show create table t1;
222 Table Create Table
223 t1 CREATE TABLE `t1` (
224 `a` int(11) DEFAULT NULL,
225 `b` int(11) DEFAULT NULL,
226 `c` int(11) DEFAULT NULL
227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
228 # Failed Alter
229 insert into t1 values(1,1, NULL);
230 alter table t1 change a a int unique;
231 ERROR 23000: Duplicate entry '1' for key 'a'
232 set @@session.binlog_alter_two_phase = 0;
233 alter table t1 change a a int;
234 set @@session.binlog_alter_two_phase = 1;
235 alter table t1 change a a int;
236 show create table t1;
237 Table Create Table
238 t1 CREATE TABLE `t1` (
239 `a` int(11) DEFAULT NULL,
240 `b` int(11) DEFAULT NULL,
241 `c` int(11) DEFAULT NULL
242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
243 connection master_node;
244 drop table t1;
245 # aria
246 connection master_node;
247 create table t1(a int, b int) engine=aria;;
248 insert into t1 values(1,1);
249 insert into t1 values(2,2);
250 # Normal Alter
251 alter table t1 add column c int;
252 show create table t1;
253 Table Create Table
254 t1 CREATE TABLE `t1` (
255 `a` int(11) DEFAULT NULL,
256 `b` int(11) DEFAULT NULL,
257 `c` int(11) DEFAULT NULL
258 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
259 # Failed Alter
260 insert into t1 values(1,1, NULL);
261 alter table t1 change a a int unique;
262 ERROR 23000: Duplicate entry '1' for key 'a'
263 set @@session.binlog_alter_two_phase = 0;
264 alter table t1 change a a int;
265 set @@session.binlog_alter_two_phase = 1;
266 alter table t1 change a a int;
267 show create table t1;
268 Table Create Table
269 t1 CREATE TABLE `t1` (
270 `a` int(11) DEFAULT NULL,
271 `b` int(11) DEFAULT NULL,
272 `c` int(11) DEFAULT NULL
273 ) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
274 connection master_node;
275 drop table t1;
276 # concurrent alter Myisam
277 # Concurrent DML
278 # Rollback tests
279 ERROR 23000: Duplicate entry '2' for key 'b'
280 ERROR 23000: Duplicate entry '2' for key 'b'
281 ERROR 23000: Duplicate entry '2' for key 'b'
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 # concurrent alter Aria
290 # Concurrent DML
291 # Rollback tests
292 ERROR 23000: Duplicate entry '2' for key 'b'
293 ERROR 23000: Duplicate entry '2' for key 'b'
294 ERROR 23000: Duplicate entry '2' for key 'b'
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 # concurrent alter Innodb copy
303 # Concurrent DML
304 # Rollback tests
305 ERROR 23000: Duplicate entry '2' for key 'b'
306 ERROR 23000: Duplicate entry '2' for key 'b'
307 ERROR 23000: Duplicate entry '2' for key 'b'
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 # concurrent alter Innodb Inplace
316 # Concurrent DML
317 # Rollback tests
318 ERROR 23000: Duplicate entry '2' for key 'b'
319 ERROR 23000: Duplicate entry '2' for key 'b'
320 ERROR 23000: Duplicate entry '2' for key 'b'
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 connection server_2;
329 drop database s2;
330 connection server_3;
331 start all slaves;
332 Warnings:
333 Note 1937 SLAVE 'm2' started
334 Note 1937 SLAVE 'm1' started
335 set default_master_connection = 'm1';
336 include/wait_for_slave_to_start.inc
337 set default_master_connection = 'm2';
338 include/wait_for_slave_to_start.inc
339 set default_master_connection = 'm1';
340 include/sync_with_master_gtid.inc
341 set default_master_connection = 'm2';
342 include/sync_with_master_gtid.inc
343 # cleanup
344 connection server_3;
345 set default_master_connection = 'm1';
346 include/stop_slave.inc
347 set default_master_connection = 'm2';
348 include/stop_slave.inc
349 set global slave_parallel_threads = 0;;
350 set global slave_parallel_mode = optimistic;;
351 set global gtid_strict_mode = 0;;
352 set global gtid_domain_id= 0;
353 reset master;
354 RESET SLAVE ALL;
355 SET GLOBAL gtid_slave_pos= '';
356 connection server_1;
357 set global binlog_alter_two_phase=0;;
358 set global gtid_domain_id= 0;
359 reset master;
360 connection server_2;
361 set global gtid_domain_id= 0;
362 set global binlog_alter_two_phase=0;;
363 reset master;
364 disconnect server_1;
365 disconnect server_2;
366 disconnect server_3;