Debian Codegraph @

mysql-test/suite/innodb/t/known_directory.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 # Create a table in a non-unique undo directory.
61 --echo #
62 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
63 eval CREATE TABLE t2 (c1 INT) DATA DIRECTORY='$UNDO_DIR';
64 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
65 SHOW CREATE TABLE t2;
66
67 --echo #
68 --echo # Create a general tablespace in a known directories.
69 --echo #
70 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
71 eval CREATE TABLESPACE ts1 ADD DATAFILE '$KNOWN_DIR/ts1.ibd';
72
73 --echo #
74 --echo # Attempt to create a general tablespace in an unknown directory.
75 --echo #
76 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
77 --error ER_WRONG_FILE_NAME
78 eval CREATE TABLESPACE bad_4 ADD DATAFILE '$UNKNOWN_DIR/bad_4.ibd';
79 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
80 SHOW WARNINGS;
81
82 --echo #
83 --echo # Create a general tablespace in a non-unique undo directory.
84 --echo #
85 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
86 eval CREATE TABLESPACE ts2 ADD DATAFILE '$UNDO_DIR/ts2.ibd';
87
88 --echo #
89 --echo # Attempt to create a general tablespace in a subdirectory of the datadir.
90 --echo #
91 --mkdir $MYSQLD_DATADIR/general
92 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
93 --error ER_WRONG_FILE_NAME
94 eval CREATE TABLESPACE bad_6 ADD DATAFILE 'general/bad_6.ibd';
95 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
96 SHOW WARNINGS;
97 --force-rmdir $MYSQLD_DATADIR/general
98
99 --echo #
100 --echo # Create an undo tablespace in the unique undo directory.
101 --echo #
102 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
103 eval CREATE UNDO TABLESPACE undo_003 ADD DATAFILE '$UNDO_DIR/undo_003.ibu';
104 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
105
106 --echo #
107 --echo # Create an undo tablespace in a known dir other than the unique undo directory.
108 --echo #
109 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
110 eval CREATE UNDO TABLESPACE undo_004 ADD DATAFILE '$KNOWN_DIR/undo_004.ibu';
111
112 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
113 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
114
115 --echo #
116 --echo # Attempt to create an undo tablespace in an unknown directory.
117 --echo #
118 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
119 --error ER_WRONG_FILE_NAME
120 eval CREATE UNDO TABLESPACE bad_7 ADD DATAFILE '$UNKNOWN_DIR/bad_7.ibu';
121 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
122 SHOW WARNINGS;
123
124 --echo #
125 --echo # Create a table with a partitions in known directories.
126 --echo #
127 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
128 eval CREATE TABLE tp1(c1 INT)
129 PARTITION BY HASH(c1) (
130 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
131 PARTITION p2 DATA DIRECTORY='$KNOWN_DIR',
132 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
133 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
134 SHOW CREATE TABLE tp1;
135
136 --echo #
137 --echo # Attempt to create a table with a partition in an unknown directory.
138 --echo #
139 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
140 --error ER_WRONG_FILE_NAME
141 eval CREATE TABLE bad_8(c1 INT)
142 PARTITION BY HASH(c1) (
143 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
144 PARTITION p2 DATA DIRECTORY='$UNKNOWN_DIR',
145 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
146 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
147 SHOW WARNINGS;
148
149 --echo #
150 --echo # Attempt to create a table with a partition in the undo directory.
151 --echo #
152 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
153 eval CREATE TABLE tp2(c1 INT)
154 PARTITION BY HASH(c1) (
155 PARTITION p1 DATA DIRECTORY='$KNOWN_DIR',
156 PARTITION p2 DATA DIRECTORY='$UNDO_DIR',
157 PARTITION p3 DATA DIRECTORY='$KNOWN_DIR');
158 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
159 SHOW CREATE TABLE tp2;
160
161 --echo #
162 --echo # Create a table with a sub-partitions in known directories.
163 --echo #
164 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
165 eval CREATE TABLE tp3(c1 INT, c2 INT)
166 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
167 PARTITION p1 VALUES LESS THAN (10) (
168 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
169 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
170 PARTITION p2 VALUES LESS THAN (20) (
171 SUBPARTITION s3 DATA DIRECTORY='$KNOWN_DIR',
172 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
173 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
174 SHOW CREATE TABLE tp3;
175
176 --echo #
177 --echo # Attempt to create a table with a sub-partition in an unknown directory.
178 --echo #
179 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
180 --error ER_WRONG_FILE_NAME
181 eval CREATE TABLE bad_10(c1 INT, c2 INT)
182 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
183 PARTITION p1 VALUES LESS THAN (10) (
184 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
185 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
186 PARTITION p2 VALUES LESS THAN (20) (
187 SUBPARTITION s3 DATA DIRECTORY='$UNKNOWN_DIR',
188 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
189 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR \\ /
190 SHOW WARNINGS;
191
192 --echo #
193 --echo # Attempt to create a table with a sub-partition in the undo directory
194 --echo #
195 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
196 eval CREATE TABLE tp4(c1 INT, c2 INT)
197 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
198 PARTITION p1 VALUES LESS THAN (10) (
199 SUBPARTITION s1 DATA DIRECTORY='$KNOWN_DIR',
200 SUBPARTITION s2 DATA DIRECTORY='$KNOWN_DIR'),
201 PARTITION p2 VALUES LESS THAN (20) (
202 SUBPARTITION s3 DATA DIRECTORY='$UNDO_DIR',
203 SUBPARTITION s4 DATA DIRECTORY='$KNOWN_DIR'));
204 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
205 SHOW CREATE TABLE tp4;
206
207 --echo #
208 --echo # Attempt to add a partition using an unknown directory.
209 --echo #
210 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
211 --error ER_WRONG_FILE_NAME
212 eval ALTER TABLE tp3 ADD PARTITION (
213 PARTITION p3 VALUES LESS THAN (30) (
214 SUBPARTITION s5 DATA DIRECTORY '$KNOWN_DIR',
215 SUBPARTITION s6 DATA DIRECTORY '$UNKNOWN_DIR'));
216 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
217 SHOW WARNINGS;
218
219 --echo #
220 --echo # Successfully add a partition using a known directory.
221 --echo #
222 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
223 eval ALTER TABLE tp3 ADD PARTITION (
224 PARTITION p3 VALUES LESS THAN (30) (
225 SUBPARTITION s5 DATA DIRECTORY '$KNOWN_DIR',
226 SUBPARTITION s6 DATA DIRECTORY '$KNOWN_DIR'));
227 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
228 SHOW CREATE TABLE tp3;
229
230 --echo #
231 --echo # Attempt to reorganize a partition using an unknown directory.
232 --echo #
233 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
234 --error ER_WRONG_FILE_NAME
235 eval ALTER TABLE tp3 REORGANIZE PARTITION p3 INTO (
236 PARTITION p3 VALUES LESS THAN(40) (
237 SUBPARTITION s5 DATA DIRECTORY '$UNKNOWN_DIR',
238 SUBPARTITION s6 DATA DIRECTORY '$KNOWN_DIR'));
239 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp# \\ /
240 SHOW WARNINGS;
241
242 --echo #
243 --echo # Show CREATE TABLE for all six tables.
244 --echo #
245 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
246 SHOW CREATE TABLE t1;
247 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
248 SHOW CREATE TABLE t2;
249 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
250 SHOW CREATE TABLE tp1;
251 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
252 SHOW CREATE TABLE tp2;
253 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
254 SHOW CREATE TABLE tp3;
255 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR #P# #p# #SP# #sp#
256 SHOW CREATE TABLE tp4;
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 tablespace bad_4 because the directory is not a valid location. The DATAFILE location must be in a known directory;
275 --source include/search_pattern.inc
276 let SEARCH_PATTERN=Cannot create tablespace bad_6 because the directory is not a valid location. The DATAFILE location cannot be under the datadir;
277 --source include/search_pattern.inc
278 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;
279 --source include/search_pattern.inc
280 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;
281 --source include/search_pattern.inc
282 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;
283 --source include/search_pattern.inc
284 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;
285 --source include/search_pattern.inc
286 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;
287 --source include/search_pattern.inc
288
289 --echo #
290 --echo # Cleanup
291 --echo #
292
293 DROP TABLE t1;
294 DROP TABLE t2;
295 DROP TABLE tp1;
296 DROP TABLE tp2;
297 DROP TABLE tp3;
298 DROP TABLE tp4;
299 DROP TABLESPACE ts1;
300 DROP TABLESPACE ts2;
301
302 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
303 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
304 let $inactive_undo_space = undo_003;
305 source include/wait_until_undo_space_is_empty.inc;
306 let $inactive_undo_space = undo_004;
307 source include/wait_until_undo_space_is_empty.inc;
308 DROP UNDO TABLESPACE undo_003;
309 DROP UNDO TABLESPACE undo_004;
310
311 --force-rmdir $KNOWN_DIR
312 --force-rmdir $UNKNOWN_DIR
313
314 --disable_query_log
315 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");
316 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");
317 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");
318 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location cannot be the undo directory");
319 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location cannot be under the datadir");
320 call mtr.add_suppression("Cannot create tablespace .* because the directory is not a valid location. The DATAFILE location must be in a known directory");
321 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");
322 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.");
323 call mtr.add_suppression("The directory for tablespace .* does not exist or is incorrect");
324 --enable_query_log
325