Debian Codegraph @

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

raw
1 #
2 # Show the limitations of using a 'dotfile' hidden directory
3 #
4 SET default_storage_engine=InnoDB;
5 CREATE TABLE t1 (a INT);
6 CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.ibd';
7 # Shutdown and make the another directory that is HIDDEN.
8 # Copy ibdata1, test/t1.ibd and ts1.ibd to the hidden directory.
9 # Restart with the --innodb-directories=MYSQL_TMP_DIR
10 # The tablespaces in the hidden directory will not be scanned.
11 # restart:--innodb-directories=MYSQL_TMP_DIR
12 SHOW VARIABLES LIKE 'innodb_directories';
13 Variable_name Value
14 innodb_directories MYSQL_TMP_DIR
15 # Show that tablespaces can be built in a HIDDEN directory.
16 # NOTE: This means that a tablespace can be created in a location that cannot be recovered. !!!
17 CREATE TABLE t2 (a INT) DATA DIRECTORY='MYSQL_TMP_DIR/.other_dir';
18 CREATE TABLESPACE ts2 ADD DATAFILE 'MYSQL_TMP_DIR/.other_dir/ts2.ibd';
19 === information_schema.innodb_tablespaces and innodb_datafiles ===
20 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
21 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
22 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
23 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
24 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
25 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
26 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/.other_dir/test/t2.ibd
27 ts1 General DEFAULT 0 1 1 Any ts1.ibd
28 ts2 General DEFAULT 0 1 1 Any MYSQL_TMP_DIR/.other_dir/ts2.ibd
29 === information_schema.files ===
30 Space_Name File_Type Engine Status Tablespace_Name Path
31 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
32 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
33 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
34 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
35 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
36 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQL_TMP_DIR/.other_dir/test/t2.ibd
37 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQLD_DATADIR/ts1.ibd
38 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQL_TMP_DIR/.other_dir/ts2.ibd
39 # Shutdown again.
40 # Make a copy of the new tablespaces in the datadir
41 # Restart again.
42 # The tablespaces in the hidden directory will not be scanned and the
43 # tablespaces originally created in the hidden directory will be marked
44 # as MOVED to the datadir.
45 # restart:--innodb-directories=MYSQL_TMP_DIR
46 === information_schema.innodb_tablespaces and innodb_datafiles ===
47 Space_Name Space_Type Page_Size Zip_Size BlockSize!=0 FileSize!=0 Formats_Permitted Path
48 mtr/asserted_test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
49 mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
50 mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
51 mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
52 test/t1 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t1.ibd
53 test/t2 Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t2.ibd
54 ts1 General DEFAULT 0 1 1 Any ts1.ibd
55 ts2 General DEFAULT 0 1 1 Any MYSQLD_DATADIR/ts2.ibd
56 === information_schema.files ===
57 Space_Name File_Type Engine Status Tablespace_Name Path
58 mtr/asserted_test_suppressions TABLESPACE InnoDB NORMAL mtr/asserted_test_suppressions MYSQLD_DATADIR/mtr/asserted_test_suppressions.ibd
59 mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
60 mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
61 mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
62 test/t1 TABLESPACE InnoDB NORMAL test/t1 MYSQLD_DATADIR/test/t1.ibd
63 test/t2 TABLESPACE InnoDB NORMAL test/t2 MYSQLD_DATADIR/test/t2.ibd
64 ts1 TABLESPACE InnoDB NORMAL ts1 MYSQLD_DATADIR/ts1.ibd
65 ts2 TABLESPACE InnoDB NORMAL ts2 MYSQLD_DATADIR/ts2.ibd
66 #
67 # Validate the message that should have been put into the error log.
68 #
69 Pattern "Directory '.*' will not be scanned because it is a hidden directory" found
70 #
71 # Cleanup
72 #
73 DROP TABLE t1;
74 DROP TABLE t2;
75 DROP TABLESPACE ts1;
76 DROP TABLESPACE ts2;
77 # restart: