Debian Codegraph @

mysql-test/suite/ndb/t/ndb_ddl_open_trans.test

raw
1 -- source include/have_multi_ndb.inc
2
3
4 # Configure the second mysqld to not wait for lock so long during
5 # schema distribution.
6 connection server2;
7 let $save_lock_wait_timeout = `select @@ndb_schema_dist_lock_wait_timeout`;
8 set @@global.ndb_schema_dist_lock_wait_timeout = 1;
9
10 --disable_query_log
11 # This test provokes various failures to lock metadata on second mysqld
12 call mtr.add_suppression("Failed to acquire exclusive metadata lock");
13 call mtr.add_suppression("Failed to rename table definition in DD, continue");
14 call mtr.add_suppression("Failed to update table definition in DD");
15 call mtr.add_suppression("Failed to update schema version for database");
16 call mtr.add_suppression("Failed to execute 'ALTER DATABASE'");
17 call mtr.add_suppression("Failed to execute 'DROP DATABASE'");
18 call mtr.add_suppression("Distribution of ALTER TABLE");
19 call mtr.add_suppression("Got error '1062: Duplicate entry");
20 --enable_query_log
21
22 #
23 # alter - rename
24 #
25 connection server1;
26 create table t1 ( a int ) engine = ndb;
27
28 connection server2;
29 begin;
30 insert into t1 values(1);
31
32 connection server1;
33 replace_regex /Node [0-9]+:/Node <nodeid>/;
34 alter table t1 rename t2;
35
36 connection server2;
37 commit;
38
39 connection server1;
40 drop table t2;
41
42 connection server1;
43 --error 0,1193
44 set global ndb_dbg_check_shares=1;
45
46 connection server2;
47 --error 0,1193
48 set global ndb_dbg_check_shares=1;
49
50 #
51 # alter online add column
52 #
53 connection server1;
54 create table t1 ( a int primary key) engine = ndb;
55
56 connection server2;
57 begin;
58 insert into t1 values(1);
59
60 connection server1;
61 replace_regex /Node [0-9]+:/Node <nodeid>/;
62 alter table t1 algorithm=inplace, add column b int column_format dynamic;
63
64 connection server2;
65 commit;
66
67 connection server1;
68 drop table t1;
69
70 connection server1;
71 --error 0,1193
72 set global ndb_dbg_check_shares=1;
73
74 connection server2;
75 --error 0,1193
76 set global ndb_dbg_check_shares=1;
77
78
79 #
80 # alter offline add column
81 #
82 connection server1;
83 create table t1 ( a int primary key) engine = ndb;
84
85 connection server2;
86 begin;
87 insert into t1 values(1);
88
89 connection server1;
90 --error ER_LOCK_WAIT_TIMEOUT
91 alter table t1 algorithm=copy, add column b int column_format dynamic;
92
93 connection server2;
94 commit;
95
96 connection server1;
97 drop table t1;
98
99 connection server1;
100 --error 0,1193
101 set global ndb_dbg_check_shares=1;
102
103 connection server2;
104 --error 0,1193
105 set global ndb_dbg_check_shares=1;
106
107 #
108 # online create index
109 #
110 connection server1;
111 create table t1 ( a int primary key, b int) engine = ndb;
112
113 connection server2;
114 begin;
115 insert into t1 values(1, 1);
116
117 connection server1;
118 replace_regex /Node [0-9]+:/Node <nodeid>/;
119 create index ind_b on t1(b) algorithm=inplace;
120
121 connection server2;
122 commit;
123
124 connection server1;
125 drop table t1;
126
127 connection server1;
128 --error 0,1193
129 set global ndb_dbg_check_shares=1;
130
131 connection server2;
132 --error 0,1193
133 set global ndb_dbg_check_shares=1;
134
135 #
136 # online drop index
137 #
138 connection server1;
139 create table t1 ( a int primary key, b int, index ind_b (b)) engine = ndb;
140
141 connection server2;
142 begin;
143 insert into t1 values(1, 1);
144
145 connection server1;
146 replace_regex /Node [0-9]+:/Node <nodeid>/;
147 drop index ind_b on t1;
148
149 connection server2;
150 commit;
151
152 connection server1;
153 drop table t1;
154
155 connection server1;
156 --error 0,1193
157 set global ndb_dbg_check_shares=1;
158
159 connection server2;
160 --error 0,1193
161 set global ndb_dbg_check_shares=1;
162
163 #
164 # alter db
165 #
166 connection server1;
167 # Disable ps protocol for the next test case since the
168 # ALTER DATABASE doesn't fail on the participant with
169 # ps protocol enabled
170 --disable_ps_protocol
171 create database testdb;
172 create table testdb.t1 (a int) engine = ndb;
173
174 connection server2;
175 begin;
176 insert into testdb.t1 values(1);
177
178 connection server1;
179 replace_regex /Node [0-9]+:/Node <nodeid>/;
180 alter database testdb charset = latin1;
181
182 connection server2;
183 commit;
184 --enable_ps_protocol
185
186 connection server1;
187 drop database testdb;
188
189 connection server1;
190 --error 0,1193
191 set global ndb_dbg_check_shares=1;
192
193 connection server2;
194 --error 0,1193
195 set global ndb_dbg_check_shares=1;
196
197 # Restore intial ndb_schema_dist_lock_wait_timeout value
198 --disable_query_log ONCE
199 eval set @@global.ndb_schema_dist_lock_wait_timeout = $save_lock_wait_timeout;
200
201
202
203 --echo Remote MDL lock claim failure
204
205 connection server1;
206 --echo Server1 Create table
207 create table t1 (a int primary key, b int) engine=ndb;
208 insert into t1 values (1,1);
209
210 --echo Add column c on server1
211 connection server2;
212 --echo
213 --echo Server2 Get + hold MDL on table t1, no row locks
214 begin;
215 select * from t1;
216
217 connection server1;
218 --echo
219 --echo Server1 Send Alter add column, will stall due to remote MDL lock
220 --send alter table t1 add column c int; # Online alter
221
222 connection server2;
223
224 --echo Server2 Issue normal queries on table, causing table access, rollback etc
225 --let $ct=15
226 --disable_query_log
227 --disable_result_log
228 while($ct)
229 {
230 --error 1412,0
231 select * from t1;
232 --sleep 0.5
233 --dec $ct
234 }
235 --enable_query_log
236 --enable_result_log
237
238 connection server1;
239 --echo
240 --echo Server1 Allow ALTER to complete successfully
241 --reap
242
243 --echo
244 --echo Server 1 Show table schema at origin
245 select * from t1;
246 show create table t1;
247 desc t1;
248 select column_name from information_schema.columns where table_name='t1';
249
250
251 connection server2;
252 --echo
253 --echo Server2 Show schema at participant
254 select * from t1;
255 desc t1;
256 select column_name from information_schema.columns where table_name='t1';
257 show create table t1;
258
259 --echo Add index c on server 1
260
261 connection server2;
262 --echo Server2 Take + hold MDL lock again
263 begin;
264 select * from test.t1;
265
266 connection server1;
267 --echo Server1 Issue another online DDL, will stall due to remote MDL lock
268 --send alter table t1 add index(c);
269
270 connection server2;
271 --echo Server2 Issue normal queries on table, causing table access, rollback etc
272 --let $ct=15
273 --disable_query_log
274 --disable_result_log
275 while($ct)
276 {
277 --error 1412,0
278 select * from t1;
279 --sleep 0.5
280 --dec $ct
281 }
282 --enable_query_log
283 --enable_result_log
284
285 connection server1;
286 --echo
287 --echo Server1 Allow ALTER to complete successfully
288 --reap
289
290 --echo
291 --echo Server 1 Show table schema at origin
292 select * from t1;
293 show create table t1;
294 desc t1;
295 select column_name from information_schema.columns where table_name='t1';
296
297
298 connection server2;
299 --echo
300 --echo Server2 Show schema at participant
301 select * from t1;
302 desc t1;
303 select column_name from information_schema.columns where table_name='t1';
304 show create table t1;
305
306 --echo Now further changes in the opposite direction
307 --echo Server2 -> Server1
308
309 connection server1;
310 --echo Server1 Take and hold MDL lock
311 begin;
312 select * from test.t1;
313
314 connection server2;
315 --echo Server2 Send Alter table add column, will stall due to remote MDL lock
316 --send alter table t1 add column d int;
317
318 connection server1;
319 --echo Server1 Issue normal queries on table, causing table access, rollback etc
320 --let $ct=15
321 --disable_query_log
322 --disable_result_log
323 while($ct)
324 {
325 --error 1412,0
326 select * from t1;
327 --sleep 0.5
328 --dec $ct
329 }
330 --enable_query_log
331 --enable_result_log
332
333 connection server2;
334 --echo
335 --echo Server2 Allow ALTER to complete successfully
336 --reap
337
338 --echo
339 --echo Server 2 Show table schema at origin
340 select * from t1;
341 show create table t1;
342 desc t1;
343 select column_name from information_schema.columns where table_name='t1';
344
345
346 connection server1;
347 --echo
348 --echo Server1 Show schema at participant
349 select * from t1;
350 desc t1;
351 select column_name from information_schema.columns where table_name='t1';
352 show create table t1;
353
354 --echo Add index d on server 2
355
356 connection server1;
357 --echo Server1 Take and hold MDL lock again
358 begin;
359 select * from test.t1;
360
361 connection server2;
362 --echo Server2 Issue another online DDL, will stall due to remote MDL lock
363 --send alter table t1 add index(d);
364
365 connection server1;
366 --echo Server1 Issue normal queries on table, causing table access, rollback etc
367 --let $ct=15
368 --disable_query_log
369 --disable_result_log
370 while($ct)
371 {
372 --error 1412,0
373 select * from t1;
374 --sleep 0.5
375 --dec $ct
376 }
377 --enable_query_log
378 --enable_result_log
379
380 connection server2;
381 --echo
382 --echo Server2 Allow ALTER to complete successfully
383 --reap
384
385 --echo
386 --echo Server 2 Show table schema
387 select * from t1;
388 show create table t1;
389 desc t1;
390 select column_name from information_schema.columns where table_name='t1';
391
392
393 connection server1;
394
395 --echo
396 --echo Server1 Show schema at participant
397 select * from t1;
398 desc t1;
399 select column_name from information_schema.columns where table_name='t1';
400 show create table t1;
401
402
403 drop table t1;
404