Debian Codegraph @

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

raw
1 #
2 # Non-Windows version of Tablespace Portability test.
3 #
4 # This testcase is related to WL#5980 & WL#6205.
5 # It tests whether datafiles can be copied from one location
6 # to another, and still be opened. In order to make this testcase run
7 # on any OS, we create the tablespaces here.
8 #
9 SET DEFAULT_STORAGE_ENGINE=InnoDB;
10 # restart:--innodb-directories=MYSQL_TMP_DIR
11 SHOW VARIABLES LIKE 'innodb_directories';
12 Variable_name Value
13 innodb_directories MYSQL_TMP_DIR
14 #
15 # Try to create a tablespace in a read-only directory.
16 #
17 CREATE TABLESPACE s7_def ADD DATAFILE 'MYSQL_TMP_DIR/read_only_dir/s7.ibd';
18 ERROR HY000: Failed to create TABLESPACE s7_def
19 SHOW WARNINGS;
20 Level Code Message
21 Error 1528 Failed to create TABLESPACE s7_def
22 Error 1030 Got error 168 - 'Unknown (generic) error from engine' from storage engine
23 #
24 # Try a series of invalid relative ADD DATAFILE entries.
25 # General tablespace files can be in the datadir but they cannot be under the datadir.
26 #
27 CREATE TABLESPACE bad ADD DATAFILE '';
28 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
29 SHOW WARNINGS;
30 Level Code Message
31 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
32 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
33 Error 1528 Failed to create TABLESPACE bad
34 Error 3121 Incorrect File Name ''.
35 CREATE TABLESPACE bad ADD DATAFILE '.ibd';
36 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
37 SHOW WARNINGS;
38 Level Code Message
39 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
40 Error 1528 Failed to create TABLESPACE bad
41 Error 3121 Incorrect File Name '.ibd'.
42 CREATE TABLESPACE bad ADD DATAFILE './ibd';
43 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
44 SHOW WARNINGS;
45 Level Code Message
46 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
47 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
48 Error 1528 Failed to create TABLESPACE bad
49 Error 3121 Incorrect File Name './ibd'.
50 CREATE TABLESPACE bad ADD DATAFILE './.ibd';
51 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
52 SHOW WARNINGS;
53 Level Code Message
54 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
55 Error 1528 Failed to create TABLESPACE bad
56 Error 3121 Incorrect File Name './.ibd'.
57 CREATE TABLESPACE bad ADD DATAFILE '../spaces/';
58 ERROR HY000: The ADD DATAFILE filepath does not have a proper filename.
59 SHOW WARNINGS;
60 Level Code Message
61 Error 3121 The ADD DATAFILE filepath does not have a proper filename.
62 Error 3121 The ADD DATAFILE filepath must end with '.ibd'.
63 Error 3121 The directory does not exist or is incorrect.
64 Error 3121 The DATAFILE location must be in a known directory.
65 Error 1528 Failed to create TABLESPACE bad
66 Error 3121 Incorrect File Name '../spaces/'.
67 CREATE TABLESPACE bad ADD DATAFILE 'test/bad.ibd';
68 ERROR HY000: The DATAFILE location cannot be under the datadir.
69 SHOW WARNINGS;
70 Level Code Message
71 Error 3121 The DATAFILE location cannot be under the datadir.
72 Error 1528 Failed to create TABLESPACE bad
73 Error 3121 Incorrect File Name 'test/bad.ibd'.
74 CREATE TABLESPACE bad ADD DATAFILE './test/bad.ibd';
75 ERROR HY000: The DATAFILE location cannot be under the datadir.
76 SHOW WARNINGS;
77 Level Code Message
78 Error 3121 The DATAFILE location cannot be under the datadir.
79 Error 1528 Failed to create TABLESPACE bad
80 Error 3121 Incorrect File Name './test/bad.ibd'.
81 CREATE TABLESPACE bad ADD DATAFILE './test//bad.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
87 Error 3121 Incorrect File Name './test//bad.ibd'.
88 CREATE TABLESPACE bad ADD DATAFILE '../data/test/bad.ibd';
89 ERROR HY000: The DATAFILE location cannot be under the datadir.
90 SHOW WARNINGS;
91 Level Code Message
92 Error 3121 The DATAFILE location cannot be under the datadir.
93 Error 1528 Failed to create TABLESPACE bad
94 Error 3121 Incorrect File Name '../data/test/bad.ibd'.
95 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/test/bad.ibd';
96 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
97 SHOW WARNINGS;
98 Level Code Message
99 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
100 Error 3121 The DATAFILE location cannot be under the datadir.
101 Error 1528 Failed to create TABLESPACE bad
102 Error 3121 Incorrect File Name '../data/../data/test/bad.ibd'.
103 CREATE TABLESPACE bad ADD DATAFILE '../data/../data/bad.ibd';
104 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
105 SHOW WARNINGS;
106 Level Code Message
107 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
108 Error 1528 Failed to create TABLESPACE bad
109 Error 3121 Incorrect File Name '../data/../data/bad.ibd'.
110 CREATE TABLESPACE bad ADD DATAFILE '../does_not_exist/bad.ibd';
111 ERROR HY000: The directory does not exist or is incorrect.
112 SHOW WARNINGS;
113 Level Code Message
114 Error 3121 The directory does not exist or is incorrect.
115 Error 3121 The DATAFILE location must be in a known directory.
116 Error 1528 Failed to create TABLESPACE bad
117 Error 3121 Incorrect File Name '../does_not_exist/bad.ibd'.
118 CREATE TABLESPACE bad ADD DATAFILE 'test/../bad.ibd';
119 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
120 SHOW WARNINGS;
121 Level Code Message
122 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
123 Error 1528 Failed to create TABLESPACE bad
124 Error 3121 Incorrect File Name 'test/../bad.ibd'.
125 CREATE TABLESPACE bad ADD DATAFILE './test/../bad.ibd';
126 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
127 SHOW WARNINGS;
128 Level Code Message
129 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
130 Error 1528 Failed to create TABLESPACE bad
131 Error 3121 Incorrect File Name './test/../bad.ibd'.
132 CREATE TABLESPACE bad ADD DATAFILE 'test\\..\\bad.ibd';
133 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
134 SHOW WARNINGS;
135 Level Code Message
136 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
137 Error 1528 Failed to create TABLESPACE bad
138 Error 3121 Incorrect File Name 'test\..\bad.ibd'.
139 CREATE TABLESPACE bad ADD DATAFILE '..///data//test///..//bad.ibd';
140 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
141 SHOW WARNINGS;
142 Level Code Message
143 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
144 Error 1528 Failed to create TABLESPACE bad
145 Error 3121 Incorrect File Name '..///data//test///..//bad.ibd'.
146 CREATE TABLESPACE bad ADD DATAFILE '.\\test\\..\\bad.ibd';
147 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
148 SHOW WARNINGS;
149 Level Code Message
150 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
151 Error 1528 Failed to create TABLESPACE bad
152 Error 3121 Incorrect File Name '.\test\..\bad.ibd'.
153 CREATE TABLESPACE bad ADD DATAFILE '..\\\\\\data\\\\test\\\\\\..\\\\bad.ibd';
154 ERROR HY000: The ADD DATAFILE filepath cannot contain circular directory references.
155 SHOW WARNINGS;
156 Level Code Message
157 Error 3121 The ADD DATAFILE filepath cannot contain circular directory references.
158 Error 1528 Failed to create TABLESPACE bad
159 Error 3121 Incorrect File Name '..\\\data\\test\\\..\\bad.ibd'.
160 #
161 # Try a series of valid relative ADD DATAFILE entries.
162 # General tablespace files can be in the datadir but they cannot be under the datadir.
163 #
164 CREATE TABLESPACE ibport_s01 ADD DATAFILE 'ibport_s01.ibd';
165 CREATE TABLESPACE ibport_s02 ADD DATAFILE './ibport_s02.ibd';
166 CREATE TABLESPACE ibport_s03 ADD DATAFILE '../data/ibport_s03.ibd';
167 CREATE TABLESPACE ibport_s04 ADD DATAFILE '.\\ibport_s04.ibd';
168 CREATE TABLESPACE ibport_s05 ADD DATAFILE '..\\data\\ibport_s05.ibd';
169 # Directory listing of MYSQLD_DATADIR/ ibport*
170 ibport_s01.ibd
171 ibport_s02.ibd
172 ibport_s03.ibd
173 ibport_s04.ibd
174 ibport_s05.ibd
175 SELECT s.space_type 'Type', s.name 'Space Name', d.path 'Path'
176 FROM information_schema.innodb_tablespaces s, information_schema.innodb_datafiles d
177 WHERE s.name like '%ibport%' AND s.space = d.space ORDER BY s.space;
178 Type Space Name Path
179 General ibport_s01 ibport_s01.ibd
180 General ibport_s02 ./ibport_s02.ibd
181 General ibport_s03 ../data/ibport_s03.ibd
182 General ibport_s04 .\ibport_s04.ibd
183 General ibport_s05 ..\data\ibport_s05.ibd
184 SELECT s.space_type 'Type', s.name 'Space Name', f.file_name 'Path'
185 FROM information_schema.innodb_tablespaces s, information_schema.files f
186 WHERE s.name like '%ibport%' AND s.space = f.file_id ORDER BY s.space;
187 Type Space Name Path
188 General ibport_s01 ./ibport_s01.ibd
189 General ibport_s02 ./ibport_s02.ibd
190 General ibport_s03 ../data/ibport_s03.ibd
191 General ibport_s04 ./ibport_s04.ibd
192 General ibport_s05 ../data/ibport_s05.ibd
193 DROP TABLESPACE ibport_s01;
194 DROP TABLESPACE ibport_s02;
195 DROP TABLESPACE ibport_s03;
196 DROP TABLESPACE ibport_s04;
197 DROP TABLESPACE ibport_s05;
198 # restart:
199 #
200 # Bug#32721533 CAN'T ALTER TABLE AFTER MOVING THE DATA FILE USING INNODB_DIRECTORIES OPTION
201 #
202 CREATE TABLE t1(a INT);
203 include/save_error_log_position.inc
204 # restart:
205 include/assert_error_log.inc [server: 1, pattern: .*\[Warning\].*Tablespace .*, name 'test/t1', file '.*test.*t1.ibd' is missing]
206 # restart: --innodb_directories=INNODB_DIR
207 ALTER TABLE t1 FORCE;
208 DROP TABLE t1;
209 # restart: