Debian Codegraph @

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

raw
1 # *************************************************************************
2 # wl#8619 : Test the functionality of portability to a different OS
3 # Test Linux --datadir and tablespaces runs on windows platform
4 # In order to run this testcase datadir_tablespace_linux.zip file should
5 # exist in the mysql-test/std_data
6 # As now mysqld itself supports the upgrade of --datadir of any version
7 # such as mysql-5.7 to mysql-8.0 to trunk, this testcase can be used for
8 # version of mysqld server
9 # *************************************************************************
10 --source include/have_innodb_16k.inc
11 --source include/not_valgrind.inc
12 --source include/windows.inc
13 # Increased server restart time
14 --let $wait_counter= 4000
15
16 let $MYSQLD_OLD_DATADIR = `select @@datadir`;
17
18 CREATE TABLE tab(c1 int);
19
20 INSERT INTO tab VALUES(10);
21
22 --echo # copy the win datadir zip into destination location
23 --copy_file $MYSQL_TEST_DIR/std_data/datadir_tablespace_linux.zip $MYSQL_TMP_DIR/datadir_tablespace_linux.zip
24
25 --echo # Unzip the zip file on windows platform
26 --exec unzip -q $MYSQL_TMP_DIR/datadir_tablespace_linux.zip -d $MYSQL_TMP_DIR
27
28 --echo ## Stop DB server
29 --source include/shutdown_mysqld.inc
30
31 --echo ## Start Linx DB with --innodb-directories
32 let $innodb_dirs='$MYSQL_TMP_DIR/datadir1;$MYSQL_TMP_DIR/undo_files;$MYSQL_TMP_DIR/part0;$MYSQL_TMP_DIR/part1;$MYSQL_TMP_DIR/part2;$MYSQL_TMP_DIR/part3';
33 --let $restart_parameters=restart: --datadir=$MYSQL_TMP_DIR/db1 --innodb_undo_directory=$MYSQL_TMP_DIR/undo_files --innodb_data_home_dir=$MYSQL_TMP_DIR/data_home --innodb_redo_log_capacity=20M --innodb_log_group_home_dir=$MYSQL_TMP_DIR/data_home --innodb_data_file_path=data01:20M;data02:20M:autoextend --lower_case_table_names=1 --log_error_verbosity=3 --innodb-directories=$innodb_dirs
34 --source include/start_mysqld_no_echo.inc
35
36 --echo ## Check new datadir
37 --replace_result $MYSQL_TMP_DIR NEW_DATADIR
38 SELECT @@datadir;
39
40 --replace_result $MYSQL_TMP_DIR UNDO_FILES
41 SELECT @@innodb_undo_directory;
42
43 --replace_result $MYSQL_TMP_DIR DATA_HOME
44 SELECT @@innodb_data_home_dir;
45
46 --replace_result $MYSQL_TMP_DIR DATA_HOME_DIR
47 SELECT @@innodb_log_group_home_dir;
48
49 SELECT @@innodb_data_file_path;
50
51 SELECT @@innodb_undo_tablespaces;
52
53 --replace_result $MYSQL_TMP_DIR db_directory1
54 SHOW CREATE TABLE tab3;
55
56 --replace_result $MYSQL_TMP_DIR db_directory1
57 SHOW CREATE TABLE purchase;
58
59 # server was crashing here with ha_innodb.cc != nullptr
60 --replace_column 1 #
61 SELECT TABLESPACE_NAME,FILE_TYPE,TABLE_NAME,ENGINE FROM INFORMATION_SCHEMA.FILES;
62
63 --echo ## Stop DB server
64 --source include/shutdown_mysqld.inc
65
66 --echo ## restart the server with --datadir and innodb-directories
67 --let $restart_parameters=restart: --datadir=$MYSQL_TMP_DIR/db1 --innodb_undo_directory=$MYSQL_TMP_DIR/undo_files --innodb_data_home_dir=$MYSQL_TMP_DIR/data_home --innodb_redo_log_capacity=20M --innodb_log_group_home_dir=$MYSQL_TMP_DIR/data_home --innodb_data_file_path=data01:20M;data02:20M:autoextend --lower_case_table_names=1 --log_error_verbosity=3 --innodb-directories=$innodb_dirs
68 --source include/start_mysqld_no_echo.inc
69
70 --echo ## Check new datadir
71 --replace_result $MYSQL_TMP_DIR NEW_DATADIR
72 SELECT @@datadir;
73
74 --replace_result $MYSQL_TMP_DIR UNDO_FILES
75 SELECT @@innodb_undo_directory;
76
77 --replace_result $MYSQL_TMP_DIR DATA_HOME
78 SELECT @@innodb_data_home_dir;
79
80 --replace_result $MYSQL_TMP_DIR DATA_HOME_DIR
81 SELECT @@innodb_log_group_home_dir;
82
83 SELECT @@innodb_data_file_path;
84
85 SELECT @@innodb_undo_tablespaces;
86
87 --replace_result $MYSQL_TMP_DIR db_directory1
88 SHOW CREATE TABLE tab3;
89
90 SHOW CREATE TABLE tab4;
91
92 --replace_result $MYSQL_TMP_DIR db_directory1
93 SHOW CREATE TABLE purchase;
94
95 --echo ## Check with DML & DDL operations
96 SELECT * FROM tab1;
97
98 SELECT * FROM tab2;
99
100 SELECT * FROM tab3;
101
102 DELETE FROM tab1;
103
104 DELETE FROM tab2;
105
106 DELETE FROM tab3;
107
108 DELETE FROM tab4;
109
110 DELETE FROM purchase;
111
112 # Server throws error Got error 44 - 'InnoDB error' to be fixed
113 ALTER TABLE tab3 ADD COLUMN c3 VARCHAR(15);
114
115 ALTER TABLE tab4 ADD COLUMN c3 VARCHAR(15);
116
117 INSERT INTO tab1 VALUES(1, 'VISH');
118
119 INSERT INTO tab2 VALUES(2, 'VISH');
120
121 INSERT INTO tab3 VALUES (100,'VISWANATH',100,'Test1');
122
123 INSERT INTO tab3 VALUES (300,'VISWANATH',100,'Test2');
124
125 INSERT INTO tab4 VALUES(2, 'VISH', 'NATH');
126
127 INSERT INTO purchase VALUES(1,'1980-05-31');
128 INSERT INTO purchase VALUES(2,'1999-05-31');
129 INSERT INTO purchase VALUES(3,'1998-05-31');
130 INSERT INTO purchase VALUES(4,'1979-05-31');
131 INSERT INTO purchase VALUES(5,'1978-05-31');
132 INSERT INTO purchase VALUES(6,'1997-05-31');
133
134 SELECT * FROM tab1;
135
136 SELECT * FROM tab2;
137
138 SELECT * FROM tab3;
139
140 SELECT * FROM tab4;
141
142 SELECT * FROM purchase;
143
144 --echo ## Stop DB server for moving tablespaces around
145 --source include/shutdown_mysqld.inc
146
147 --echo ## Moving tablespace files in criss-cross form
148 --move_file $MYSQL_TMP_DIR/part0/test/purchase#p#p0#sp#s0.ibd $MYSQL_TMP_DIR/datadir1/test/purchase#p#p0#sp#s0.ibd
149 --move_file $MYSQL_TMP_DIR/part1/test/purchase#p#p0#sp#s1.ibd $MYSQL_TMP_DIR/datadir1/test/purchase#p#p0#sp#s1.ibd
150 --move_file $MYSQL_TMP_DIR/datadir1/test/tab3#p#p0.ibd $MYSQL_TMP_DIR/part0/test/tab3#p#p0.ibd
151 --move_file $MYSQL_TMP_DIR/datadir1/test/tab3#p#p1.ibd $MYSQL_TMP_DIR/part1/test/tab3#p#p1.ibd
152 --move_file $MYSQL_TMP_DIR/undo_files/ts2.ibd $MYSQL_TMP_DIR/data_home/ts2.ibd
153
154 --echo ## Start Linx DB with --innodb-directories
155 let $innodb_dirs='$MYSQL_TMP_DIR/db1/../datadir1;$MYSQL_TMP_DIR/db1/../undo_files;$MYSQL_TMP_DIR/db1/../part0;$MYSQL_TMP_DIR/db1/../part1;$MYSQL_TMP_DIR/part2;$MYSQL_TMP_DIR/part3';
156 --let $restart_parameters=restart: --datadir=$MYSQL_TMP_DIR/db1 --innodb_undo_directory=$MYSQL_TMP_DIR/undo_files --innodb_data_home_dir=$MYSQL_TMP_DIR/data_home --innodb_redo_log_capacity=20M --innodb_log_group_home_dir=$MYSQL_TMP_DIR/data_home --innodb_data_file_path=data01:20M;data02:20M:autoextend --lower_case_table_names=1 --log_error_verbosity=3 --innodb-directories=$innodb_dirs
157 --source include/start_mysqld_no_echo.inc
158
159 --echo ## Check new datadir
160 --replace_result $MYSQL_TMP_DIR NEW_DATADIR
161 SELECT @@datadir;
162
163 --replace_result $MYSQL_TMP_DIR UNDO_FILES
164 SELECT @@innodb_undo_directory;
165
166 --replace_result $MYSQL_TMP_DIR DATA_HOME
167 SELECT @@innodb_data_home_dir;
168
169 --replace_result $MYSQL_TMP_DIR DATA_HOME_DIR
170 SELECT @@innodb_log_group_home_dir;
171
172 SELECT @@innodb_data_file_path;
173
174 SELECT @@innodb_undo_tablespaces;
175
176 --replace_result $MYSQL_TMP_DIR db_directory1
177 SHOW CREATE TABLE tab3;
178
179 --replace_result $MYSQL_TMP_DIR db_directory1
180 SHOW CREATE TABLE purchase;
181
182 SHOW CREATE TABLE tab4;
183
184 --echo ## Stop DB server after scan DIR
185 --source include/shutdown_mysqld.inc
186
187 --echo ## restart the server with --datadir and innodb-directories
188 --let $restart_parameters=restart: --datadir=$MYSQL_TMP_DIR/db1 --innodb_undo_directory=$MYSQL_TMP_DIR/undo_files --innodb_data_home_dir=$MYSQL_TMP_DIR/data_home --innodb_redo_log_capacity=20M --innodb_log_group_home_dir=$MYSQL_TMP_DIR/data_home --innodb_data_file_path=data01:20M;data02:20M:autoextend --lower_case_table_names=1 --log_error_verbosity=3 --innodb-directories=$innodb_dirs
189 --source include/start_mysqld_no_echo.inc
190
191 --echo ## Check new datadir
192 --replace_result $MYSQL_TMP_DIR NEW_DATADIR
193 SELECT @@datadir;
194
195 --replace_result $MYSQL_TMP_DIR UNDO_FILES
196 SELECT @@innodb_undo_directory;
197
198 --replace_result $MYSQL_TMP_DIR DATA_HOME
199 SELECT @@innodb_data_home_dir;
200
201 --replace_result $MYSQL_TMP_DIR DATA_HOME_DIR
202 SELECT @@innodb_log_group_home_dir;
203
204 SELECT @@innodb_data_file_path;
205
206 SELECT @@innodb_undo_tablespaces;
207
208 --replace_result $MYSQL_TMP_DIR db_directory1
209 SHOW CREATE TABLE tab3;
210
211 --replace_result $MYSQL_TMP_DIR db_directory1
212 SHOW CREATE TABLE purchase;
213
214 SHOW CREATE TABLE tab4;
215
216 --echo ## Check with DML operations
217 DELETE FROM tab1;
218
219 DELETE FROM tab2;
220
221 DELETE FROM tab3;
222
223 DELETE FROM tab4;
224
225 DELETE FROM purchase;
226
227 # Server throws error Got error 44 - 'InnoDB error' to be fixed
228 ALTER TABLE tab3 ADD COLUMN c4 VARCHAR(15);
229
230 ALTER TABLE tab4 DROP COLUMN c3;
231
232 INSERT INTO tab1 VALUES(1, 'VISH');
233
234 INSERT INTO tab2 VALUES(2, 'VISH');
235
236 INSERT INTO tab3 VALUES (100,'VISWANATH',100,'Test1','Check1');
237
238 INSERT INTO tab3 VALUES (300,'VISWANATH',100,'Test2','Check2');
239
240 INSERT INTO tab4 VALUES(2, 'VISH');
241
242 INSERT INTO purchase VALUES(1,'1980-05-31');
243 INSERT INTO purchase VALUES(2,'1999-05-31');
244 INSERT INTO purchase VALUES(3,'1998-05-31');
245 INSERT INTO purchase VALUES(4,'1979-05-31');
246 INSERT INTO purchase VALUES(5,'1978-05-31');
247 INSERT INTO purchase VALUES(6,'1997-05-31');
248
249 SELECT * FROM tab1;
250
251 SELECT * FROM tab2;
252
253 SELECT * FROM tab3;
254
255 SELECT * FROM tab4;
256
257 # clean up
258 DROP TABLE tab1;
259
260 DROP TABLE tab2;
261
262 DROP TABLE tab3;
263
264 DROP TABLE tab4;
265
266 DROP TABLE purchase;
267
268 DROP TABLESPACE ts2;
269
270 --echo ## Stop DB server for clean up
271 --source include/shutdown_mysqld.inc
272
273 --echo ## Cleanup the Windows --datadir location and its *.ibd file location
274 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/ data*
275 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/ ib_buffer*
276 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/ ib_log*
277 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/ ibtmp*
278 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/ tablespaces*
279 --remove_files_wildcard $MYSQL_TMP_DIR/data_home/#innodb_redo #ib_redo*
280 --rmdir $MYSQL_TMP_DIR/data_home/#innodb_redo
281 --rmdir $MYSQL_TMP_DIR/data_home
282
283 --remove_files_wildcard $MYSQL_TMP_DIR/undo_files/ undo*
284 --rmdir $MYSQL_TMP_DIR/undo_files
285
286 --rmdir $MYSQL_TMP_DIR/datadir1/test
287 --rmdir $MYSQL_TMP_DIR/datadir1
288 --rmdir $MYSQL_TMP_DIR/part0/test
289 --rmdir $MYSQL_TMP_DIR/part1/test
290 --rmdir $MYSQL_TMP_DIR/part2/test
291 --rmdir $MYSQL_TMP_DIR/part3/test
292 --rmdir $MYSQL_TMP_DIR/part0
293 --rmdir $MYSQL_TMP_DIR/part1
294 --rmdir $MYSQL_TMP_DIR/part2
295 --rmdir $MYSQL_TMP_DIR/part3
296
297 --remove_files_wildcard $MYSQL_TMP_DIR/db1/test/ *
298 --remove_files_wildcard $MYSQL_TMP_DIR/db1/sys/ *
299 --remove_files_wildcard $MYSQL_TMP_DIR/db1/mysql/ *
300 --remove_files_wildcard $MYSQL_TMP_DIR/db1/performance_schema/ *
301 --rmdir $MYSQL_TMP_DIR/db1/mysql
302 --rmdir $MYSQL_TMP_DIR/db1/sys
303 --rmdir $MYSQL_TMP_DIR/db1/test
304 --rmdir $MYSQL_TMP_DIR/db1/performance_schema
305 --remove_files_wildcard $MYSQL_TMP_DIR/db1/ *
306 --force-rmdir $MYSQL_TMP_DIR/db1
307 --remove_files_wildcard $MYSQL_TMP_DIR/ datadir_tablespace_linux.zip
308
309 --echo ## Restart the server with MTR default location
310 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
311 --let $restart_parameters="restart: --datadir=$MYSQLD_OLD_DATADIR"
312 --source include/start_mysqld.inc
313
314 --replace_result $MYSQLD_OLD_DATADIR OLD_DATADIR
315 SELECT @@datadir;
316
317 SELECT * FROM tab;
318
319 DROP TABLE tab;