Debian Codegraph @

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

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