Debian Codegraph @

mysql-test/suite/innodb/t/known_dir_unique_undo.test

raw
1 --echo #
2 --echo # Show that datafiles are restricted to known directories.
3 --echo # Rules:
4 --echo # 1. Known Directories are the unique subsets from the combination of:
5 --echo # --datadir, --innobd-directories, --innodb-data-home-dir, --innodb-undo-directory
6 --echo # 2. If --innodb-undo-directory is unique, new IBD files are not allowed there.
7 --echo # 3. Any location referenced in DATA DIRECTORY must be a Known Directory other than a unique undo dir.
8 --echo # 4. CREATE TABLESPACE ... ADD DATAFILE must be a Known Directory other than a unique undo dir.
9 --echo # 5. CREATE UNDO TABLESPACE ... ADD DATAFILE must be any Known Directory.
10 --echo # 6. At startup, since previous engines did not restrict locations to known directories,
11 --echo # anything found will be used as before. But a warning message will be put into the error log.
12 --echo #
13
14 SET default_storage_engine=InnoDB;
15
16 --disable_query_log
17
18 LET $MYSQLD_DATADIR=`select @@datadir`;
19 LET $UNDO_DIR=$MYSQL_TMP_DIR/undo_dir;
20 LET $KNOWN_DIR=$MYSQL_TMP_DIR/known_dir;
21 LET $UNKNOWN_DIR=$MYSQL_TMP_DIR/unknown_dir;
22 LET $INNODB_PAGE_SIZE=`select @@innodb_page_size`;
23
24 --mkdir $KNOWN_DIR
25 --mkdir $UNKNOWN_DIR
26
27 --enable_query_log
28
29 --echo #
30 --echo # Create a table in a known directory.
31 --echo #
32 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
33 eval CREATE TABLE t1(c1 INT) DATA DIRECTORY='$KNOWN_DIR';
34 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
35 SHOW CREATE TABLE t1;
36
37 --echo #
38 --echo # Attempt to create a table in an unknown directory.
39 --echo #
40 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
41 --error ER_WRONG_FILE_NAME
42 eval CREATE TABLE bad_1 (c1 INT) DATA DIRECTORY='$UNKNOWN_DIR';
43 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
44 SHOW WARNINGS;
45
46 --echo #
47 --echo # Attempt to create a table in the datadir.
48 --echo #
49 CREATE DATABASE data;
50 USE data;
51 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
52 --error ER_WRONG_FILE_NAME
53 eval CREATE TABLE bad_2 (c1 INT) DATA DIRECTORY='$MYSQLTEST_VARDIR/mysqld.1';
54 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR \\ /
55 SHOW WARNINGS;
56 USE test;
57 DROP DATABASE data;
58
59 --echo #
60 --echo # Attempt to create a table in a unique undo directory.
61 --echo #
62 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
63 --error ER_WRONG_FILE_NAME
64 eval CREATE TABLE bad_3 (c1 INT) DATA DIRECTORY='$UNDO_DIR';
65 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
66 SHOW WARNINGS;
67
68 --echo #
69 --echo # Create a general tablespace in a known directories.
70 --echo #
71 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
72 eval CREATE TABLESPACE ts1 ADD DATAFILE '$KNOWN_DIR/ts1.ibd';
73
74 --echo #
75 --echo # Attempt to create a general tablespace in an unknown directory.
76 --echo #
77 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
78 --error ER_WRONG_FILE_NAME
79 eval CREATE TABLESPACE bad_4 ADD DATAFILE '$UNKNOWN_DIR/bad_4.ibd';
80 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
81 SHOW WARNINGS;
82
83 --echo #
84 --echo # Attempt to create a general tablespace in a unique undo directory.
85 --echo #
86 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
87 --error ER_WRONG_FILE_NAME
88 eval CREATE TABLESPACE bad_5 ADD DATAFILE '$UNDO_DIR/bad_5.ibd';
89 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
90 SHOW WARNINGS;
91
92 --echo #
93 --echo # Attempt to create a general tablespace in a subdirectory of the datadir.
94 --echo #
95 --mkdir $MYSQLD_DATADIR/general
96 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
97 --error ER_WRONG_FILE_NAME
98 eval CREATE TABLESPACE bad_6 ADD DATAFILE 'general/bad_6.ibd';
99 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
100 SHOW WARNINGS;
101 --force-rmdir $MYSQLD_DATADIR/general
102
103 --echo #
104 --echo # Create an undo tablespace in the unique undo directory.
105 --echo #
106 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
107 eval CREATE UNDO TABLESPACE undo_003 ADD DATAFILE '$UNDO_DIR/undo_003.ibu';
108 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
109
110 --echo #
111 --echo # Create an undo tablespace in a known dir other than the unique undo directory.
112 --echo #
113 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
114 eval CREATE UNDO TABLESPACE undo_004 ADD DATAFILE '$KNOWN_DIR/undo_004.ibu';
115
116 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
117 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
118
119 --echo #
120 --echo # Attempt to create an undo tablespace in an unknown directory.
121 --echo #
122 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
123 --error ER_WRONG_FILE_NAME
124 eval CREATE UNDO TABLESPACE bad_7 ADD DATAFILE '$UNKNOWN_DIR/bad_7.ibu';
125 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
126 SHOW WARNINGS;
127
128 --echo #
129 --echo # Create a table with a partitions in known directories.
130 --echo #
131 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
132 eval CREATE TABLE tp1(c1 INT)
133 PARTITION BY HASH(c1) (
134 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
135 PARTITION p2 DATA DIRECTORY='$KNOWN_DIR',
136 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
137 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
138 SHOW CREATE TABLE tp1;
139
140 --echo #
141 --echo # Attempt to create a table with a partition in an unknown directory.
142 --echo #
143 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
144 --error ER_WRONG_FILE_NAME
145 eval CREATE TABLE bad_8(c1 INT)
146 PARTITION BY HASH(c1) (
147 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
148 PARTITION p2 DATA DIRECTORY='$UNKNOWN_DIR',
149 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
150 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
151 SHOW WARNINGS;
152
153 --echo #
154 --echo # Attempt to create a table with a partition in the undo directory.
155 --echo #
156 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
157 --error ER_WRONG_FILE_NAME
158 eval CREATE TABLE bad_9(c1 INT)
159 PARTITION BY HASH(c1) (
160 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
161 PARTITION p2 DATA DIRECTORY='$UNDO_DIR',
162 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
163 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
164 SHOW WARNINGS;
165
166 --echo #
167 --echo # Create a table with a sub-partitions in known directories.
168 --echo #
169 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
170 eval CREATE TABLE tp3(c1 INT, c2 INT)
171 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
172 PARTITION p1 VALUES LESS THAN (10) (
173 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
174 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
175 PARTITION p2 VALUES LESS THAN (20) (
176 SUBPARTITION s3 DATA DIRECTORY='$KNOWN_DIR',
177 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
178 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
179 SHOW CREATE TABLE tp3;
180
181 --echo #
182 --echo # Attempt to create a table with a sub-partition in an unknown directory.
183 --echo #
184 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
185 --error ER_WRONG_FILE_NAME
186 eval CREATE TABLE bad_10(c1 INT, c2 INT)
187 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
188 PARTITION p1 VALUES LESS THAN (10) (
189 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
190 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
191 PARTITION p2 VALUES LESS THAN (20) (
192 SUBPARTITION s3 DATA DIRECTORY='$UNKNOWN_DIR',
193 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
194 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
195 SHOW WARNINGS;
196
197 --echo #
198 --echo # Attempt to create a table with a sub-partition in the undo directory
199 --echo #
200 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
201 --error ER_WRONG_FILE_NAME
202 eval CREATE TABLE bad_11(c1 INT, c2 INT)
203 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
204 PARTITION p1 VALUES LESS THAN (10) (
205 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
206 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
207 PARTITION p2 VALUES LESS THAN (20) (
208 SUBPARTITION s3 DATA DIRECTORY='$UNDO_DIR',
209 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
210 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
211 SHOW WARNINGS;
212
213 --echo #
214 --echo # Attempt to add a partition using an unknown directory.
215 --echo #
216 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
217 --error ER_WRONG_FILE_NAME
218 eval ALTER TABLE tp3 ADD PARTITION (
219 PARTITION p3 VALUES LESS THAN (30) (
220 SUBPARTITION s5 DATA DIRECTORY '$KNOWN_DIR',
221 SUBPARTITION s6 DATA DIRECTORY '$UNKNOWN_DIR'));
222 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
223 SHOW WARNINGS;
224
225 --echo #
226 --echo # Successfully add a partition using a known directory.
227 --echo #
228 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
229 eval ALTER TABLE tp3 ADD PARTITION (
230 PARTITION p3 VALUES LESS THAN (30) (
231 SUBPARTITION s5 DATA DIRECTORY '$KNOWN_DIR',
232 SUBPARTITION s6 DATA DIRECTORY '$KNOWN_DIR'));
233 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
234 SHOW CREATE TABLE tp3;
235
236 --echo #
237 --echo # Attempt to reorganize a partition using an unknown directory.
238 --echo #
239 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
240 --error ER_WRONG_FILE_NAME
241 eval ALTER TABLE tp3 REORGANIZE PARTITION p3 INTO (
242 PARTITION p3 VALUES LESS THAN(40) (
243 SUBPARTITION s5 DATA DIRECTORY '$UNKNOWN_DIR',
244 SUBPARTITION s6 DATA DIRECTORY '$KNOWN_DIR'));
245 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp# \\ /
246 SHOW WARNINGS;
247
248 --echo #
249 --echo # Show CREATE TABLE for all three tables.
250 --echo #
251 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
252 SHOW CREATE TABLE t1;
253 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
254 SHOW CREATE TABLE tp1;
255 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
256 SHOW CREATE TABLE tp3;
257
258 --echo #
259 --echo # Show these tables in information_schema.
260 --echo #
261 --source suite/innodb/include/show_i_s_tables.inc
262 --source suite/innodb/include/show_i_s_tablespaces.inc
263
264 --echo #
265 --echo # Validate the messages that should have been put into the error log.
266 --echo #
267 # include/search_pattern.inc uses the environment variable SEARCH_FILE.
268 let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err;
269
270 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_1 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory;
271 --source include/search_pattern.inc
272 let SEARCH_PATTERN=Cannot create a tablespace for table data/bad_2 because the directory is not a valid location. The DATA DIRECTORY location cannot be the datadir;
273 --source include/search_pattern.inc
274 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_3 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory;
275 --source include/search_pattern.inc
276 let SEARCH_PATTERN=Cannot create tablespace bad_4 because the directory is not a valid location. The DATAFILE location must be in a known directory;
277 --source include/search_pattern.inc
278 let SEARCH_PATTERN=Cannot create tablespace bad_5 because the directory is not a valid location. The DATAFILE location cannot be the undo directory;
279 --source include/search_pattern.inc
280 let SEARCH_PATTERN=Cannot create tablespace bad_6 because the directory is not a valid location. The DATAFILE location cannot be under the datadir;
281 --source include/search_pattern.inc
282 let SEARCH_PATTERN=Cannot create tablespace bad_7 because the directory is not a valid location. The UNDO DATAFILE location must be in a known directory;
283 --source include/search_pattern.inc
284 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_8.*p2 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory;
285 --source include/search_pattern.inc
286 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_9.*p2 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory;
287 --source include/search_pattern.inc
288 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_10.*p2.*s3 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory;
289 --source include/search_pattern.inc
290 let SEARCH_PATTERN=Cannot create a tablespace for table test/bad_11.*p2.*s3 because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory;
291 --source include/search_pattern.inc
292 let SEARCH_PATTERN=Cannot create a tablespace for table test/tp3.*p3.*s6 because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory;
293 --source include/search_pattern.inc
294 let SEARCH_PATTERN=Cannot create a tablespace for table test/tp3.*p3.*s5#tmp because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory;
295 --source include/search_pattern.inc
296
297 --echo #
298 --echo # Cleanup
299 --echo #
300
301 DROP TABLE t1;
302 DROP TABLE tp1;
303 DROP TABLE tp3;
304 DROP TABLESPACE ts1;
305
306 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
307 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
308 let $inactive_undo_space = undo_003;
309 source include/wait_until_undo_space_is_empty.inc;
310 let $inactive_undo_space = undo_004;
311 source include/wait_until_undo_space_is_empty.inc;
312 DROP UNDO TABLESPACE undo_003;
313 DROP UNDO TABLESPACE undo_004;
314
315 --force-rmdir $KNOWN_DIR
316 --force-rmdir $UNKNOWN_DIR
317
318 --disable_query_log
319 call mtr.add_suppression("Cannot create a tablespace for table .* because the directory is not a valid location. The DATA DIRECTORY location cannot be the undo directory");
320 call mtr.add_suppression("Cannot create a tablespace for table .* because the directory is not a valid location. The DATA DIRECTORY location must be in a known directory");
321 call mtr.add_suppression("Cannot create a tablespace for table .* because the directory is not a valid location. The DATA DIRECTORY location cannot be the datadir");
322 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location cannot be the undo directory");
323 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location cannot be under the datadir");
324 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location must be in a known directory");
325 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The UNDO DATAFILE location must be in a known directory");
326 call mtr.add_suppression("MySQL is freeing a thd though trx->n_mysql_tables_in_use is 0 and trx->mysql_n_tables_locked is 1.");
327 call mtr.add_suppression("The directory for tablespace .* does not exist or is incorrect");
328 --enable_query_log
329