Debian Codegraph @

mysql-test/suite/innodb/r/known_dir_unique_undo.result

raw
1 #
2 # Show that datafiles are restricted to known directories.
3 # Rules:
4 # 1. Known Directories are the unique subsets from the combination of:
5 # --datadir, --innobd-directories, --innodb-data-home-dir, --innodb-undo-directory
6 # 2. If --innodb-undo-directory is unique, new IBD files are not allowed there.
7 # 3. Any location referenced in DATA DIRECTORY must be a Known Directory other than a unique undo dir.
8 # 4. CREATE TABLESPACE ... ADD DATAFILE must be a Known Directory other than a unique undo dir.
9 # 5. CREATE UNDO TABLESPACE ... ADD DATAFILE must be any Known Directory.
10 # 6. At startup, since previous engines did not restrict locations to known directories,
11 # anything found will be used as before. But a warning message will be put into the error log.
12 #
13 SET default_storage_engine=InnoDB;
14 #
15 # Create a table in a known directory.
16 #
17 CREATE TABLE t1(c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/known_dir';
18 SHOW CREATE TABLE t1;
19 Table Create Table
20 t1 CREATE TABLE `t1` (
21 `c1` int DEFAULT NULL
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/known_dir/'
23 #
24 # Attempt to create a table in an unknown directory.
25 #
26 CREATE TABLE bad_1 (c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir';
27 ERROR HY000: The DATA DIRECTORY location must be in a known directory.
28 SHOW WARNINGS;
29 Level Code Message
30 Error 3121 The DATA DIRECTORY location must be in a known directory.
31 Error 1031 Table storage engine for 'bad_1' doesn't have this option
32 #
33 # Attempt to create a table in the datadir.
34 #
35 CREATE DATABASE data;
36 USE data;
37 CREATE TABLE bad_2 (c1 INT) DATA DIRECTORY='MYSQLTEST_VARDIR/mysqld.1';
38 ERROR HY000: The DATA DIRECTORY location cannot be the datadir.
39 SHOW WARNINGS;
40 Level Code Message
41 Error 3121 The DATA DIRECTORY location cannot be the datadir.
42 Error 1031 Table storage engine for 'bad_2' doesn't have this option
43 USE test;
44 DROP DATABASE data;
45 #
46 # Attempt to create a table in a unique undo directory.
47 #
48 CREATE TABLE bad_3 (c1 INT) DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir';
49 ERROR HY000: The DATA DIRECTORY location cannot be the undo directory.
50 SHOW WARNINGS;
51 Level Code Message
52 Error 3121 The DATA DIRECTORY location cannot be the undo directory.
53 Error 1031 Table storage engine for 'bad_3' doesn't have this option
54 #
55 # Create a general tablespace in a known directories.
56 #
57 CREATE TABLESPACE ts1 ADD DATAFILE 'MYSQL_TMP_DIR/known_dir/ts1.ibd';
58 #
59 # Attempt to create a general tablespace in an unknown directory.
60 #
61 CREATE TABLESPACE bad_4 ADD DATAFILE 'MYSQL_TMP_DIR/unknown_dir/bad_4.ibd';
62 ERROR HY000: The DATAFILE location must be in a known directory.
63 SHOW WARNINGS;
64 Level Code Message
65 Error 3121 The DATAFILE location must be in a known directory.
66 Error 1528 Failed to create TABLESPACE bad_4
67 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/unknown_dir/bad_4.ibd'.
68 #
69 # Attempt to create a general tablespace in a unique undo directory.
70 #
71 CREATE TABLESPACE bad_5 ADD DATAFILE 'MYSQL_TMP_DIR/undo_dir/bad_5.ibd';
72 ERROR HY000: The DATAFILE location cannot be the undo directory.
73 SHOW WARNINGS;
74 Level Code Message
75 Error 3121 The DATAFILE location cannot be the undo directory.
76 Error 1528 Failed to create TABLESPACE bad_5
77 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/undo_dir/bad_5.ibd'.
78 #
79 # Attempt to create a general tablespace in a subdirectory of the datadir.
80 #
81 CREATE TABLESPACE bad_6 ADD DATAFILE 'general/bad_6.ibd';
82 ERROR HY000: The DATAFILE location cannot be under the datadir.
83 SHOW WARNINGS;
84 Level Code Message
85 Error 3121 The DATAFILE location cannot be under the datadir.
86 Error 1528 Failed to create TABLESPACE bad_6
87 Error 3121 Incorrect File Name 'general/bad_6.ibd'.
88 #
89 # Create an undo tablespace in the unique undo directory.
90 #
91 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'MYSQL_TMP_DIR/undo_dir/undo_003.ibu';
92 #
93 # Create an undo tablespace in a known dir other than the unique undo directory.
94 #
95 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'MYSQL_TMP_DIR/known_dir/undo_004.ibu';
96 SELECT NAME, SPACE_TYPE, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
97 WHERE SPACE_TYPE = 'Undo' ORDER BY NAME;
98 NAME SPACE_TYPE STATE
99 innodb_undo_001 Undo active
100 innodb_undo_002 Undo active
101 undo_003 Undo active
102 undo_004 Undo active
103 #
104 # Attempt to create an undo tablespace in an unknown directory.
105 #
106 CREATE UNDO TABLESPACE bad_7 ADD DATAFILE 'MYSQL_TMP_DIR/unknown_dir/bad_7.ibu';
107 ERROR HY000: The UNDO DATAFILE location must be in a known directory.
108 SHOW WARNINGS;
109 Level Code Message
110 Error 3121 The UNDO DATAFILE location must be in a known directory.
111 Error 1528 Failed to create UNDO TABLESPACE bad_7
112 Error 3121 Incorrect File Name 'MYSQL_TMP_DIR/unknown_dir/bad_7.ibu'.
113 #
114 # Create a table with a partitions in known directories.
115 #
116 CREATE TABLE tp1(c1 INT)
117 PARTITION BY HASH(c1) (
118 PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
119 PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
120 PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir');
121 SHOW CREATE TABLE tp1;
122 Table Create Table
123 tp1 CREATE TABLE `tp1` (
124 `c1` int DEFAULT NULL
125 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
126 /*!50100 PARTITION BY HASH (`c1`)
127 (PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
128 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
129 PARTITION p3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB) */
130 #
131 # Attempt to create a table with a partition in an unknown directory.
132 #
133 CREATE TABLE bad_8(c1 INT)
134 PARTITION BY HASH(c1) (
135 PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
136 PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir',
137 PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir');
138 ERROR HY000: The DATA DIRECTORY location must be in a known directory.
139 SHOW WARNINGS;
140 Level Code Message
141 Error 3121 The DATA DIRECTORY location must be in a known directory.
142 Error 1031 Table storage engine for 'bad_8' doesn't have this option
143 #
144 # Attempt to create a table with a partition in the undo directory.
145 #
146 CREATE TABLE bad_9(c1 INT)
147 PARTITION BY HASH(c1) (
148 PARTITION p1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
149 PARTITION p2 DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir',
150 PARTITION p3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir');
151 ERROR HY000: The DATA DIRECTORY location cannot be the undo directory.
152 SHOW WARNINGS;
153 Level Code Message
154 Error 3121 The DATA DIRECTORY location cannot be the undo directory.
155 Error 1031 Table storage engine for 'bad_9' doesn't have this option
156 #
157 # Create a table with a sub-partitions in known directories.
158 #
159 CREATE TABLE tp3(c1 INT, c2 INT)
160 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
161 PARTITION p1 VALUES LESS THAN (10) (
162 SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
163 SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'),
164 PARTITION p2 VALUES LESS THAN (20) (
165 SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
166 SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'));
167 SHOW CREATE TABLE tp3;
168 Table Create Table
169 tp3 CREATE TABLE `tp3` (
170 `c1` int DEFAULT NULL,
171 `c2` int DEFAULT NULL
172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
173 /*!50100 PARTITION BY RANGE (`c1`)
174 SUBPARTITION BY HASH (`c2`)
175 (PARTITION p1 VALUES LESS THAN (10)
176 (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
177 SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB),
178 PARTITION p2 VALUES LESS THAN (20)
179 (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
180 SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB)) */
181 #
182 # Attempt to create a table with a sub-partition in an unknown directory.
183 #
184 CREATE TABLE bad_10(c1 INT, c2 INT)
185 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
186 PARTITION p1 VALUES LESS THAN (10) (
187 SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
188 SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'),
189 PARTITION p2 VALUES LESS THAN (20) (
190 SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/unknown_dir',
191 SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'));
192 ERROR HY000: The DATA DIRECTORY location must be in a known directory.
193 SHOW WARNINGS;
194 Level Code Message
195 Error 3121 The DATA DIRECTORY location must be in a known directory.
196 Error 1031 Table storage engine for 'bad_10' doesn't have this option
197 #
198 # Attempt to create a table with a sub-partition in the undo directory
199 #
200 CREATE TABLE bad_11(c1 INT, c2 INT)
201 PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c2) (
202 PARTITION p1 VALUES LESS THAN (10) (
203 SUBPARTITION s1 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir',
204 SUBPARTITION s2 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'),
205 PARTITION p2 VALUES LESS THAN (20) (
206 SUBPARTITION s3 DATA DIRECTORY='MYSQL_TMP_DIR/undo_dir',
207 SUBPARTITION s4 DATA DIRECTORY='MYSQL_TMP_DIR/known_dir'));
208 ERROR HY000: The DATA DIRECTORY location cannot be the undo directory.
209 SHOW WARNINGS;
210 Level Code Message
211 Error 3121 The DATA DIRECTORY location cannot be the undo directory.
212 Error 1031 Table storage engine for 'bad_11' doesn't have this option
213 #
214 # Attempt to add a partition using an unknown directory.
215 #
216 ALTER TABLE tp3 ADD PARTITION (
217 PARTITION p3 VALUES LESS THAN (30) (
218 SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir',
219 SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/unknown_dir'));
220 ERROR HY000: The DATA DIRECTORY location must be in a known directory.
221 SHOW WARNINGS;
222 Level Code Message
223 Error 3121 The DATA DIRECTORY location must be in a known directory.
224 Error 1031 Table storage engine for 'tp3' doesn't have this option
225 #
226 # Successfully add a partition using a known directory.
227 #
228 ALTER TABLE tp3 ADD PARTITION (
229 PARTITION p3 VALUES LESS THAN (30) (
230 SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir',
231 SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir'));
232 SHOW CREATE TABLE tp3;
233 Table Create Table
234 tp3 CREATE TABLE `tp3` (
235 `c1` int DEFAULT NULL,
236 `c2` int DEFAULT NULL
237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
238 /*!50100 PARTITION BY RANGE (`c1`)
239 SUBPARTITION BY HASH (`c2`)
240 (PARTITION p1 VALUES LESS THAN (10)
241 (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
242 SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB),
243 PARTITION p2 VALUES LESS THAN (20)
244 (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
245 SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB),
246 PARTITION p3 VALUES LESS THAN (30)
247 (SUBPARTITION s5 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
248 SUBPARTITION s6 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB)) */
249 #
250 # Attempt to reorganize a partition using an unknown directory.
251 #
252 ALTER TABLE tp3 REORGANIZE PARTITION p3 INTO (
253 PARTITION p3 VALUES LESS THAN(40) (
254 SUBPARTITION s5 DATA DIRECTORY 'MYSQL_TMP_DIR/unknown_dir',
255 SUBPARTITION s6 DATA DIRECTORY 'MYSQL_TMP_DIR/known_dir'));
256 ERROR HY000: The DATA DIRECTORY location must be in a known directory.
257 SHOW WARNINGS;
258 Level Code Message
259 Error 3121 The DATA DIRECTORY location must be in a known directory.
260 Error 1031 Table storage engine for 'tp3' doesn't have this option
261 #
262 # Show CREATE TABLE for all three tables.
263 #
264 SHOW CREATE TABLE t1;
265 Table Create Table
266 t1 CREATE TABLE `t1` (
267 `c1` int DEFAULT NULL
268 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci DATA DIRECTORY='MYSQL_TMP_DIR/known_dir/'
269 SHOW CREATE TABLE tp1;
270 Table Create Table
271 tp1 CREATE TABLE `tp1` (
272 `c1` int DEFAULT NULL
273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
274 /*!50100 PARTITION BY HASH (`c1`)
275 (PARTITION p1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
276 PARTITION p2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB,
277 PARTITION p3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir/' ENGINE = InnoDB) */
278 SHOW CREATE TABLE tp3;
279 Table Create Table
280 tp3 CREATE TABLE `tp3` (
281 `c1` int DEFAULT NULL,
282 `c2` int DEFAULT NULL
283 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
284 /*!50100 PARTITION BY RANGE (`c1`)
285 SUBPARTITION BY HASH (`c2`)
286 (PARTITION p1 VALUES LESS THAN (10)
287 (SUBPARTITION s1 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
288 SUBPARTITION s2 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB),
289 PARTITION p2 VALUES LESS THAN (20)
290 (SUBPARTITION s3 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
291 SUBPARTITION s4 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB),
292 PARTITION p3 VALUES LESS THAN (30)
293 (SUBPARTITION s5 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB,
294 SUBPARTITION s6 DATA DIRECTORY = 'MYSQL_TMP_DIR/known_dir' ENGINE = InnoDB)) */
295 #
296 # Show these tables in information_schema.
297 #
298 === information_schema.innodb_tables and innodb_tablespaces ===
299 Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
300 mtr/asserted_test_suppressions mtr/asserted_test_suppressions 33 4 Dynamic 0 Single
301 mtr/global_suppressions mtr/global_suppressions 33 4 Dynamic 0 Single
302 mtr/test_ignored_global_suppressions mtr/test_ignored_global_suppressions 33 4 Dynamic 0 Single
303 mtr/test_suppressions mtr/test_suppressions 33 4 Dynamic 0 Single
304 test/t1 test/t1 97 4 Dynamic 0 Single
305 test/tp1#p#p1 test/tp1#p#p1 97 4 Dynamic 0 Single
306 test/tp1#p#p2 test/tp1#p#p2 97 4 Dynamic 0 Single
307 test/tp1#p#p3 test/tp1#p#p3 97 4 Dynamic 0 Single
308 test/tp3#p#p1#sp#s1 test/tp3#p#p1#sp#s1 97 5 Dynamic 0 Single
309 test/tp3#p#p1#sp#s2 test/tp3#p#p1#sp#s2 97 5 Dynamic 0 Single
310 test/tp3#p#p2#sp#s3 test/tp3#p#p2#sp#s3 97 5 Dynamic 0 Single
311 test/tp3#p#p2#sp#s4 test/tp3#p#p2#sp#s4 97 5 Dynamic 0 Single
312 test/tp3#p#p3#sp#s5 test/tp3#p#p3#sp#s5 97 5 Dynamic 0 Single
313 test/tp3#p#p3#sp#s6 test/tp3#p#p3#sp#s6 97 5 Dynamic 0 Single
314 === information_schema.innodb_tablespaces and innodb_datafiles ===
315 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
316 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
317 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
318 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
319 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
320 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/t1.ibd
321 test/tp1#p#p1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p1.ibd
322 test/tp1#p#p2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p2.ibd
323 test/tp1#p#p3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp1#p#p3.ibd
324 test/tp3#p#p1#sp#s1 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s1.ibd
325 test/tp3#p#p1#sp#s2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s2.ibd
326 test/tp3#p#p2#sp#s3 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s3.ibd
327 test/tp3#p#p2#sp#s4 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s4.ibd
328 test/tp3#p#p3#sp#s5 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s5.ibd
329 test/tp3#p#p3#sp#s6 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s6.ibd
330 ts1 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/known_dir/ts1.ibd
331 === information_schema.files ===
332 Space_Name File_Type Engine Status Tablespace_Name Path
333 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
334 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
335 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
336 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
337 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQL_TMP_DIR/known_dir/test/t1.ibd
338 test/tp1#p#p1 TABLESPACE InnoDB NORMAL test/tp1#p#p1 MYSQL_TMP_DIR/known_dir/test/tp1#p#p1.ibd
339 test/tp1#p#p2 TABLESPACE InnoDB NORMAL test/tp1#p#p2 MYSQL_TMP_DIR/known_dir/test/tp1#p#p2.ibd
340 test/tp1#p#p3 TABLESPACE InnoDB NORMAL test/tp1#p#p3 MYSQL_TMP_DIR/known_dir/test/tp1#p#p3.ibd
341 test/tp3#p#p1#sp#s1 TABLESPACE InnoDB NORMAL test/tp3#p#p1#sp#s1 MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s1.ibd
342 test/tp3#p#p1#sp#s2 TABLESPACE InnoDB NORMAL test/tp3#p#p1#sp#s2 MYSQL_TMP_DIR/known_dir/test/tp3#p#p1#sp#s2.ibd
343 test/tp3#p#p2#sp#s3 TABLESPACE InnoDB NORMAL test/tp3#p#p2#sp#s3 MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s3.ibd
344 test/tp3#p#p2#sp#s4 TABLESPACE InnoDB NORMAL test/tp3#p#p2#sp#s4 MYSQL_TMP_DIR/known_dir/test/tp3#p#p2#sp#s4.ibd
345 test/tp3#p#p3#sp#s5 TABLESPACE InnoDB NORMAL test/tp3#p#p3#sp#s5 MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s5.ibd
346 test/tp3#p#p3#sp#s6 TABLESPACE InnoDB NORMAL test/tp3#p#p3#sp#s6 MYSQL_TMP_DIR/known_dir/test/tp3#p#p3#sp#s6.ibd
347 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQL_TMP_DIR/known_dir/ts1.ibd
348 #
349 # Validate the messages that should have been put into the error log.
350 #
351 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" found
352 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" found
353 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" found
354 Pattern "Cannot create tablespace bad_4 because the directory is not a valid location. The DATAFILE location must be in a known directory" found
355 Pattern "Cannot create tablespace bad_5 because the directory is not a valid location. The DATAFILE location cannot be the undo directory" found
356 Pattern "Cannot create tablespace bad_6 because the directory is not a valid location. The DATAFILE location cannot be under the datadir" found
357 Pattern "Cannot create tablespace bad_7 because the directory is not a valid location. The UNDO DATAFILE location must be in a known directory" found
358 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" found
359 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" found
360 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" found
361 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" found
362 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" found
363 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" found
364 #
365 # Cleanup
366 #
367 DROP TABLE t1;
368 DROP TABLE tp1;
369 DROP TABLE tp3;
370 DROP TABLESPACE ts1;
371 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
372 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
373 DROP UNDO TABLESPACE undo_003;
374 DROP UNDO TABLESPACE undo_004;