Debian Codegraph @

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

raw
1 --source include/have_ndb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 --echo # Bug#21376265 - ENHANCEMENT: ACQUIRE MDL LOCKS ON ALL TABLESPACE
6 --echo # REFERRED BY A STATEMENT
7
8 # In NDB, LIST, RANGE and HASH partition disabled by default,
9 # we have to use --new option to enable it.
10 set new=on;
11
12 CREATE LOGFILE GROUP lg1
13 ADD UNDOFILE 'undofile.dat'
14 INITIAL_SIZE 16M
15 UNDO_BUFFER_SIZE = 1M ENGINE=NDB;
16
17 CREATE TABLESPACE ts1
18 ADD DATAFILE 'datafile1.dat'
19 USE LOGFILE GROUP lg1
20 INITIAL_SIZE 64M
21 ENGINE NDB;
22
23 CREATE TABLE t1 (
24 a INT NOT NULL,
25 PRIMARY KEY (a)
26 )
27 ENGINE=NDB
28 PARTITION BY RANGE (a)
29 PARTITIONS 1
30 (PARTITION P1 VALUES LESS THAN (2) TABLESPACE ts1);
31
32
33 --connect (con1, localhost, root)
34 set new=on;
35 --echo #############################################
36 --echo # Case1: Checking ALTER TABLE
37 --echo # Sending 'ALTER TABLE t1 ADD COLUMN f int;'
38 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
39 SIGNAL got_lock
40 WAIT_FOR cont';
41 --send ALTER TABLE t1 ADD COLUMN f int;
42
43 --echo # Verify that the tablespace name is locked.
44 --connection default
45 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
46 LET $wait_condition=
47 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
48 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts1';
49 --source include/wait_condition.inc
50 SET DEBUG_SYNC= 'now SIGNAL cont';
51
52 --connection con1
53 --echo # Reaping 'ALTER TABLE t1 ADD COLUMN f int;'
54 --reap
55
56 --echo #############################################
57 --echo # Case2: Checking TRUNCATE TABLE
58 --echo # Sending 'TRUNCATE TABLE t1;'
59 SET DEBUG_SYNC= 'RESET';
60 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
61 SIGNAL got_lock
62 WAIT_FOR cont';
63 --send TRUNCATE TABLE t1;
64
65 --echo # Verify that the tablespace name is locked.
66 --connection default
67 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
68 LET $wait_condition=
69 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
70 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts1';
71 --source include/wait_condition.inc
72 SET DEBUG_SYNC= 'now SIGNAL cont';
73
74 --connection con1
75 --echo # Reaping 'TRUNCATE TABLE t1'
76 --reap
77
78 #--echo #############################################
79 #--echo # Case3: RENAME TABLE t1 to t2 crashes NDB server.
80 #--echo # Search for "Test DDL statement 2: RENAME TABLE" above
81 #--echo # in the same test file.
82
83 --echo #############################################
84 --echo # Case4: Checking CREATE TABLE
85
86 SET DEBUG_SYNC= 'RESET';
87 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
88 SIGNAL got_lock
89 WAIT_FOR cont';
90 --send CREATE TABLE t3 (a INT NOT NULL, PRIMARY KEY (a)) ENGINE=NDB PARTITION BY RANGE (a) PARTITIONS 1 (PARTITION P1 VALUES LESS THAN (2) TABLESPACE ts1);
91
92
93 --echo # Verify that the tablespace name is locked.
94 --connection default
95 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
96 LET $wait_condition=
97 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
98 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts1';
99 --source include/wait_condition.inc
100 SET DEBUG_SYNC= 'now SIGNAL cont';
101
102 --connection con1
103 --echo # Reaping 'CREATE TABLE'
104 --reap
105
106 --echo #############################################
107 --echo # Case5: Checking CREATE TABLE LIKE
108
109 SET DEBUG_SYNC= 'RESET';
110 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
111 SIGNAL got_lock
112 WAIT_FOR cont';
113 --send CREATE TABLE t4 LIKE t3;
114
115 --echo # Verify that the tablespace name is locked.
116 --connection default
117 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
118 LET $wait_condition=
119 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
120 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts1';
121 --source include/wait_condition.inc
122 SET DEBUG_SYNC= 'now SIGNAL cont';
123
124 --connection con1
125 --echo # Reaping 'CREATE TABLE LIKE'
126 --reap
127
128 --echo #############################################
129 --echo # Case6: Checking ALTER TABLE ... PARTITION
130
131 CREATE TABLESPACE ts2
132 ADD DATAFILE 'datafile2.dat'
133 USE LOGFILE GROUP lg1
134 INITIAL_SIZE 64M
135 ENGINE NDB;
136
137 SET DEBUG_SYNC= 'RESET';
138 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
139 SIGNAL got_lock
140 WAIT_FOR cont';
141 --send ALTER TABLE t3 ADD PARTITION (PARTITION p2 VALUES LESS THAN (4) TABLESPACE ts2);
142
143 --echo # Verify that the tablespace name is locked.
144 --connection default
145 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
146 LET $wait_condition=
147 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
148 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts2';
149 --source include/wait_condition.inc
150 SET DEBUG_SYNC= 'now SIGNAL cont';
151
152 --connection con1
153 --echo # Reaping 'ALTER TABLE'
154 --reap
155
156 --echo #############################################
157 --echo # Case7: Checking LOCK TABLE t2 WRITE
158
159 SET DEBUG_SYNC= 'RESET';
160 SET DEBUG_SYNC= 'after_wait_locked_tablespace_name_for_table
161 SIGNAL got_lock
162 WAIT_FOR cont';
163 --send LOCK TABLE t3 WRITE
164
165 --echo # Verify that the tablespace name is locked.
166 --connection default
167 SET DEBUG_SYNC= 'now WAIT_FOR got_lock';
168 LET $wait_condition=
169 SELECT COUNT(*) = 1 FROM performance_schema.metadata_locks
170 WHERE object_type LIKE 'TABLESPACE' AND object_name LIKE 'ts2';
171 --source include/wait_condition.inc
172 SET DEBUG_SYNC= 'now SIGNAL cont';
173
174 --connection con1
175 --echo # Reaping 'LOCK TABLE'
176 --reap
177
178 UNLOCK TABLES;
179
180 --disconnect con1
181 --source include/wait_until_disconnected.inc
182
183 --echo # Cleanup
184 --connection default
185 set new=off;
186 SET DEBUG_SYNC= 'RESET';
187 DROP TABLE t1;
188 DROP TABLE t3;
189 DROP TABLE t4;
190 ALTER TABLESPACE ts1 DROP DATAFILE 'datafile1.dat';
191 ALTER TABLESPACE ts2 DROP DATAFILE 'datafile2.dat';
192 DROP TABLESPACE ts1;
193 DROP TABLESPACE ts2;
194 DROP LOGFILE GROUP lg1 ENGINE NDB;