Debian Codegraph @

mysql-test/suite/mariabackup/aria_backup.test

raw
1 --source include/have_aria.inc
2 --source include/have_partition.inc
3 --source include/have_debug.inc
4 --source include/big_test.inc
5 # This test timeouts with msan
6 --source include/not_msan.inc
7
8 --let $targetdir=$MYSQLTEST_VARDIR/tmp/backup
9 --let $backup_stream=2
10 --let $backup_dir=1
11 --let $backup_variant=$backup_stream
12
13 while ($backup_variant) {
14 if ($backup_variant == $backup_stream) {
15 --echo ###
16 --echo # Test for backup to stream
17 --echo #####
18 }
19 if ($backup_variant == $backup_dir) {
20 --echo ###
21 --echo # Test for backup to directory
22 --echo #####
23 }
24
25 --echo ###
26 --echo # Test for mix of online/offline backup tables
27 --echo #####
28
29 CREATE TABLE t_default(i INT PRIMARY KEY)
30 ENGINE ARIA;
31 INSERT INTO t_default VALUES (1);
32
33 CREATE TABLE t_tr_p_ch(i INT PRIMARY KEY)
34 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
35 INSERT INTO t_tr_p_ch VALUES (1);
36
37 CREATE TABLE t_tr_p_nch(i INT PRIMARY KEY)
38 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
39 INSERT INTO t_tr_p_nch VALUES (1);
40
41 CREATE TABLE t_p_ch(i INT PRIMARY KEY)
42 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
43 INSERT INTO t_p_ch VALUES (1);
44
45 CREATE TABLE t_p_nch(i INT PRIMARY KEY)
46 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=PAGE PAGE_CHECKSUM=0;
47 INSERT INTO t_p_nch VALUES (1);
48
49 CREATE TABLE t_fixed(i INT PRIMARY KEY)
50 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=FIXED PAGE_CHECKSUM=1;
51 INSERT INTO t_fixed VALUES (1);
52
53 CREATE TABLE t_dyn(i INT PRIMARY KEY)
54 ENGINE ARIA TRANSACTIONAL=0 ROW_FORMAT=DYNAMIC PAGE_CHECKSUM=1;
55 INSERT INTO t_dyn VALUES (1);
56
57 --echo # Test for partitioned table
58 CREATE TABLE t_part_online(i INT PRIMARY KEY)
59 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
60 PARTITION BY RANGE( i ) (
61 PARTITION p0 VALUES LESS THAN (10),
62 PARTITION p1 VALUES LESS THAN (20),
63 PARTITION p2 VALUES LESS THAN (30)
64 );
65
66 INSERT INTO t_part_online VALUES(5);
67 INSERT INTO t_part_online VALUES(15);
68 INSERT INTO t_part_online VALUES(25);
69 SELECT * FROM t_part_online;
70
71 CREATE TABLE t_part_offline(i INT)
72 ENGINE ARIA TRANSACTIONAL = 0 PAGE_CHECKSUM = 0
73 PARTITION BY RANGE( i ) (
74 PARTITION p0 VALUES LESS THAN (10),
75 PARTITION p1 VALUES LESS THAN (20),
76 PARTITION p2 VALUES LESS THAN (30)
77 );
78
79 INSERT INTO t_part_offline VALUES(5);
80 INSERT INTO t_part_offline VALUES(15);
81 INSERT INTO t_part_offline VALUES(25);
82
83 --echo # Test for filename to tablename mapping
84 CREATE TABLE `t 1 t-1`(i INT PRIMARY KEY)
85 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
86 INSERT INTO `t 1 t-1` VALUES (1);
87
88 CREATE TABLE `t-part online`(i INT PRIMARY KEY)
89 ENGINE ARIA TRANSACTIONAL = 1 PAGE_CHECKSUM = 1
90 PARTITION BY RANGE( i ) (
91 PARTITION p0 VALUES LESS THAN (10),
92 PARTITION p1 VALUES LESS THAN (20),
93 PARTITION p2 VALUES LESS THAN (30)
94 );
95
96 INSERT INTO `t-part online` VALUES(5);
97 INSERT INTO `t-part online` VALUES(15);
98 INSERT INTO `t-part online` VALUES(25);
99
100
101 --echo ###
102 --echo # Test for redo log files backup;
103 --echo #####
104 CREATE TABLE t_logs_1(i INT)
105 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
106 CREATE TABLE t_logs_2 LIKE t_logs_1;
107 CREATE TABLE t_bulk_ins LIKE t_logs_1;
108 INSERT INTO t_logs_1 VALUES
109 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
110 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
111 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
112 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
113 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
114 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
115 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
116 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
117 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9),
118 (0), (1), (2), (3), (4), (5), (6), (7), (8), (9);
119 --echo # Generate several log files
120 --let $i = 0
121 while ($i < 14) {
122 INSERT INTO t_logs_1 SELECT * FROM t_logs_1;
123 --inc $i
124 }
125
126 --echo ###
127 --echo # Test for DML during backup for online backup
128 --echo #####
129 CREATE TABLE t_dml_ins(i INT PRIMARY KEY)
130 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
131 INSERT INTO t_dml_ins VALUES(1);
132 --let after_aria_table_copy_test_t_dml_ins=INSERT INTO test.t_dml_ins VALUES(2)
133 CREATE TABLE t_dml_upd(i INT PRIMARY KEY)
134 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
135 INSERT INTO t_dml_upd VALUES(1);
136 --let after_aria_table_copy_test_t_dml_upd=UPDATE test.t_dml_upd SET i = 2
137 CREATE TABLE t_dml_del(i INT PRIMARY KEY)
138 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
139 INSERT INTO t_dml_del VALUES(1);
140 --let after_aria_table_copy_test_t_dml_del=DELETE FROM test.t_dml_del
141
142 --echo ###
143 --echo # Test for DDL during backup for online backup
144 --echo #####
145 CREATE DATABASE test_for_db_drop;
146 CREATE TABLE test_for_db_drop.t(i INT PRIMARY KEY) ENGINE ARIA;
147 --let after_aria_table_copy_test_for_db_drop_t=DROP DATABASE test_for_db_drop
148 CREATE TABLE t_db_create(i INT PRIMARY KEY) ENGINE ARIA;
149 --let after_aria_table_copy_test_t_db_create=CREATE DATABASE test_for_db_create
150 --sorted_result
151 SHOW DATABASES;
152
153 CREATE TABLE t_alter(i INT PRIMARY KEY) ENGINE ARIA;
154 INSERT INTO t_alter VALUES (1);
155 --let after_aria_table_copy_test_t_alter=ALTER TABLE test.t_alter ADD COLUMN c INT
156
157 CREATE TABLE t_trunc(i INT PRIMARY KEY) ENGINE ARIA;
158 INSERT INTO t_trunc VALUES (1);
159 --let after_aria_table_copy_test_t_trunc=TRUNCATE TABLE test.t_trunc
160
161 CREATE TABLE t_ch_i (i int(10), index(i) ) ENGINE=Aria;
162 INSERT INTO t_ch_i VALUES(1);
163 --let after_aria_table_copy_test_t_ch_i=ALTER TABLE test.t_ch_i DISABLE KEYS
164
165 CREATE TABLE t_change_engine(i INT PRIMARY KEY) ENGINE InnoDB;
166 INSERT INTO t_change_engine VALUES (1);
167 --let after_aria_background=begin not atomic ALTER TABLE test.t_change_engine ENGINE = ARIA; INSERT INTO test.t_logs_1 SELECT * FROM test.t_logs_1; INSERT INTO test.t_bulk_ins SELECT * FROM test.t_logs_1; INSERT INTO test.t_logs_2 SET i = 1; end
168
169 CREATE TABLE t_rename(i INT PRIMARY KEY) ENGINE ARIA;
170 --let after_aria_table_copy_test_t_rename=RENAME TABLE test.t_rename TO test.t_rename_new
171 CREATE DATABASE test_for_rename;
172 CREATE TABLE t_rename_2(i INT PRIMARY KEY) ENGINE ARIA;
173 --let after_aria_table_copy_test_t_rename_2=RENAME TABLE test.t_rename_2 TO test_for_rename.t_rename_new_2
174
175 CREATE TABLE t_rename_3(i INT PRIMARY KEY) ENGINE ARIA;
176 --let after_aria_table_copy_test_t_rename_3=begin not atomic RENAME TABLE test.t_rename_3 TO test.t_rename_new_3; RENAME TABLE test.t_rename_new_3 TO test.t_rename_new_new_3; end
177
178 CREATE TABLE t_rename_4(i INT PRIMARY KEY) ENGINE ARIA;
179 --let after_aria_table_copy_test_t_rename_4=begin not atomic RENAME TABLE test.t_rename_4 TO test.t_rename_new_4; RENAME TABLE test.t_rename_new_4 TO test.t_rename_new_new_4; RENAME TABLE test.t_rename_new_new_4 TO test.t_rename_new_4; end
180
181 CREATE TABLE t_delete(i INT PRIMARY KEY) ENGINE ARIA;
182 --let after_aria_table_copy_test_t_delete=DROP TABLE test.t_delete
183
184 CREATE TABLE t_delete_2(i INT PRIMARY KEY) ENGINE ARIA;
185 --let after_aria_table_copy_test_t_delete_2=ALTER TABLE test.t_delete_2 ENGINE=Innodb
186
187 CREATE TABLE t_rename_alter(i INT PRIMARY KEY) ENGINE ARIA;
188 --let after_aria_table_copy_test_t_rename_alter=begin not atomic RENAME TABLE test.t_rename_alter TO test.t_rename_alter_2; ALTER TABLE test.t_rename_alter_2 ADD COLUMN c INT; end
189
190 CREATE TABLE t_rename_create(i INT PRIMARY KEY) ENGINE ARIA;
191 --let after_aria_table_copy_test_t_rename_create=begin not atomic RENAME TABLE test.t_rename_create TO test.t_rename_create_new; CREATE TABLE test.t_rename_create(d INT PRIMARY KEY) ENGINE ARIA; end
192
193 CREATE TABLE t_part_create(i INT PRIMARY KEY) ENGINE ARIA;
194 --let after_aria_table_copy_test_t_part_create=create table test.t_part_create_2 (i int) engine=Aria PARTITION BY HASH(i) PARTITIONS 2
195
196 CREATE TABLE t_part_add_part(i INT PRIMARY KEY) ENGINE ARIA;
197 --let after_aria_table_copy_test_t_part_add_part=alter table test.t_part_add_part PARTITION BY HASH(i) PARTITIONS 2
198
199 CREATE TABLE t_part_change_eng(i INT PRIMARY KEY) ENGINE ARIA PARTITION BY HASH(i) PARTITIONS 2;
200 --let after_aria_table_copy_test_t_part_change_eng=alter table test.t_part_change_eng ENGINE=InnoDB
201
202 CREATE TABLE t_part_change_eng_2(i INT PRIMARY KEY) ENGINE InnoDB PARTITION BY HASH(i) PARTITIONS 2;
203 CREATE TABLE t_part_change_eng_3(i INT PRIMARY KEY) ENGINE Aria;
204 --let after_aria_table_copy_test_t_part_change_eng_3=alter table test.t_part_change_eng_2 ENGINE=Aria
205
206 CREATE TABLE t_part_alter(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
207 --let after_aria_table_copy_test_t_part_alter=alter table test.t_part_alter ADD COLUMN c INT
208
209 CREATE TABLE t_part_alter_2(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 3;
210 --let after_aria_table_copy_test_t_part_alter_2=alter table test.t_part_alter_2 COALESCE PARTITION 1
211
212 CREATE TABLE t_part_drop(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
213 --let after_aria_table_copy_test_t_part_drop=DROP table test.t_part_drop
214
215 CREATE TABLE t_part_rename(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
216 --let after_aria_table_copy_test_t_part_rename=RENAME TABLE test.t_part_rename TO test.t_part_rename_2
217
218 CREATE TABLE t_part_rename_3(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
219 --let after_aria_table_copy_test_t_part_rename_3=RENAME TABLE test.t_part_rename_3 TO test_for_rename.t_part_rename_4
220
221 CREATE TABLE t_part_rm_part(i INT PRIMARY KEY) ENGINE Aria PARTITION BY HASH(i) PARTITIONS 2;
222 --let after_aria_table_copy_test_t_part_rm_part=begin not atomic ALTER TABLE test.t_part_rm_part REMOVE PARTITIONING; ALTER TABLE test.t_part_rm_part ADD COLUMN c INT; end
223
224 SET SESSION debug_dbug="+d,maria_flush_whole_log";
225 SET GLOBAL aria_checkpoint_interval=10000;
226
227 --mkdir $targetdir
228
229 if ($backup_variant == $backup_stream) {
230 --echo ### Backup to stream
231 --let $streamfile=$MYSQLTEST_VARDIR/tmp/backup.xb
232 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir --dbug=+d,mariabackup_events --stream=xbstream > $streamfile 2>$targetdir/backup_stream.log;
233 --disable_result_log
234 exec $XBSTREAM -x -C $targetdir < $streamfile;
235 --enable_result_log
236 }
237
238 if ($backup_variant == $backup_dir) {
239 --echo ### Backup to dir
240 --disable_result_log
241 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir --dbug=+d,mariabackup_events
242 --enable_result_log
243 }
244
245 --let $t_logs_1_records_count_before_backup=`SELECT COUNT(*) FROM t_logs_1`
246 --let $t_logs_2_records_count_before_backup=`SELECT COUNT(*) FROM t_logs_2`
247 --let $t_bulk_ins_records_count_before_backup=`SELECT COUNT(*) FROM t_bulk_ins`
248
249 --echo # xtrabackup prepare
250 --disable_result_log
251 --exec $XTRABACKUP --prepare --target-dir=$targetdir
252 --source include/restart_and_restore.inc
253 --enable_result_log
254
255 --echo ### Result for DDL test
256 SHOW CREATE TABLE t_alter;
257 SELECT * FROM t_alter;
258 SHOW CREATE TABLE t_change_engine;
259 SELECT * FROM t_change_engine;
260 SELECT * FROM t_trunc;
261 SELECT * FROM t_ch_i;
262 SELECT * FROM t_rename_new;
263 SELECT * FROM test_for_rename.t_rename_new_2;
264 SELECT * FROM t_rename_new_new_3;
265 SELECT * FROM t_rename_new_4;
266 --error ER_NO_SUCH_TABLE
267 SELECT * FROM t_delete;
268 SHOW CREATE TABLE t_delete_2;
269 SELECT * FROM t_rename_alter_2;
270 SELECT * FROM t_rename_create;
271 SELECT * FROM t_rename_create_new;
272 SHOW CREATE TABLE t_part_create_2;
273 SELECT * FROM t_part_create_2;
274 SHOW CREATE TABLE t_part_add_part;
275 SELECT * FROM t_part_add_part;
276 SHOW CREATE TABLE t_part_change_eng;
277 SELECT * FROM t_part_change_eng;
278 SHOW CREATE TABLE t_part_change_eng_2;
279 SELECT * FROM t_part_change_eng_2;
280 SELECT * FROM t_part_alter;
281 SHOW CREATE TABLE t_part_alter_2;
282 SELECT * FROM t_part_alter_2;
283 --error ER_NO_SUCH_TABLE
284 SELECT * FROM t_part_drop;
285 --error ER_NO_SUCH_TABLE
286 SELECT * FROM t_part_rename;
287 SELECT * FROM t_part_rename_2;
288 --error ER_NO_SUCH_TABLE
289 SELECT * FROM t_part_rename_3;
290 SELECT * FROM test_for_rename.t_part_rename_4;
291 SHOW CREATE TABLE t_part_rm_part;
292 SELECT * FROM t_part_rm_part;
293 --sorted_result
294 SHOW DATABASES;
295
296 --echo ### Clean up for DDL test
297 DROP DATABASE test_for_db_create;
298 DROP TABLE t_db_create;
299 DROP TABLE t_change_engine;
300 DROP TABLE t_alter;
301 DROP TABLE t_trunc;
302 DROP TABLE t_ch_i;
303 DROP TABLE t_rename_new;
304 DROP TABLE t_rename_new_new_3;
305 DROP TABLE t_rename_new_4;
306 DROP TABLE t_delete_2;
307 DROP TABLE t_rename_alter_2;
308 DROP TABLE t_rename_create;
309 DROP TABLE t_rename_create_new;
310 DROP TABLE t_part_create;
311 DROP TABLE t_part_create_2;
312 DROP TABLE t_part_add_part;
313 DROP TABLE t_part_change_eng;
314 DROP TABLE t_part_change_eng_2;
315 DROP TABLE t_part_change_eng_3;
316 DROP TABLE t_part_alter;
317 DROP TABLE t_part_alter_2;
318 DROP TABLE t_part_rename_2;
319 DROP TABLE t_part_rm_part;
320 DROP DATABASE test_for_rename;
321 --let after_aria_table_copy_test_for_db_drop_t=
322 --let after_aria_table_copy_test_t_db_create=
323 --let after_aria_table_copy_test_t_alter=
324 --let after_aria_background=
325 --let after_aria_table_copy_test_t_trunc=
326 --let after_aria_table_copy_test_t_ch_i=
327 --let after_aria_table_copy_test_t_rename=
328 --let after_aria_table_copy_test_t_rename_2=
329 --let after_aria_table_copy_test_t_rename_3=
330 --let after_aria_table_copy_test_t_rename_4=
331 --let after_aria_table_copy_test_t_delete=
332 --let after_aria_table_copy_test_t_delete_2=
333 --let after_aria_table_copy_test_t_rename_alter=
334 --let after_aria_table_copy_test_t_rename_create=
335 --let after_aria_table_copy_test_t_part_create=
336 --let after_aria_table_copy_test_t_part_add_part=
337 --let after_aria_table_copy_test_t_part_change_eng=
338 --let after_aria_table_copy_test_t_part_change_eng_3=
339 --let after_aria_table_copy_test_t_part_alter=
340 --let after_aria_table_copy_test_t_part_alter_2=
341 --let after_aria_table_copy_test_t_part_drop=
342 --let after_aria_table_copy_test_t_part_rename=
343 --let after_aria_table_copy_test_t_part_rename_3=
344 --let after_aria_table_copy_test_t_part_rm_part=
345
346 --echo ### Result for DML test
347 SELECT * FROM t_dml_ins;
348 SELECT * FROM t_dml_upd;
349 SELECT * FROM t_dml_del;
350
351 --echo ### Clean up for DML test
352 DROP TABLE t_dml_ins;
353 DROP TABLE t_dml_upd;
354 DROP TABLE t_dml_del;
355 --let after_aria_table_copy_test_t_dml_ins=
356 --let after_aria_table_copy_test_t_dml_upd=
357 --let after_aria_table_copy_test_t_dml_del=
358
359 --echo ### Result for redo log files backup
360 --let $t_logs_1_records_count_after_backup=`SELECT COUNT(*) FROM t_logs_1`
361 --let $t_logs_2_records_count_after_backup=`SELECT COUNT(*) FROM t_logs_2`
362 --let $t_bulk_ins_records_count_after_backup=`SELECT COUNT(*) FROM t_bulk_ins`
363 if ($t_logs_1_records_count_after_backup == $t_logs_1_records_count_before_backup) {
364 --echo # ok
365 }
366 if ($t_logs_1_records_count_after_backup != $t_logs_1_records_count_before_backup) {
367 --echo # failed
368 }
369 if ($t_logs_2_records_count_after_backup == $t_logs_2_records_count_before_backup) {
370 --echo # ok
371 }
372 if ($t_logs_2_records_count_after_backup != $t_logs_2_records_count_before_backup) {
373 --echo # failed
374 }
375 if ($t_bulk_ins_records_count_after_backup == $t_bulk_ins_records_count_before_backup) {
376 --echo # ok
377 }
378 if ($t_bulk_ins_records_count_after_backup != $t_bulk_ins_records_count_before_backup) {
379 --echo # failed
380 }
381
382 --echo ### Cleanup for redo log files backup
383 DROP TABLE t_logs_1;
384 DROP TABLE t_logs_2;
385 DROP TABLE t_bulk_ins;
386 --let $t_logs_1_records_count_before_backup=
387 --let $t_logs_1_records_count_after_backup=
388 --let $t_logs_2_records_count_before_backup=
389 --let $t_logs_2_records_count_after_backup=
390 --let $t_bulk_ins_records_count_before_backup=
391 --let $t_bulk_ins_records_count_after_backup=
392
393 --echo ### Result for online/offline tables test
394 SELECT * FROM t_default;
395 SELECT * FROM t_tr_p_ch;
396 SELECT * FROM t_tr_p_nch;
397 SELECT * FROM t_p_ch;
398 SELECT * FROM t_p_nch;
399 SELECT * FROM t_fixed;
400 SELECT * FROM t_dyn;
401 SELECT * FROM t_part_online;
402 SELECT * FROM t_part_offline;
403 SELECT * FROM `t 1 t-1`;
404 SELECT * FROM `t-part online`;
405
406 --echo ### Cleanup for online/offline tables test
407 DROP TABLE t_default;
408 DROP TABLE t_tr_p_ch;
409 DROP TABLE t_tr_p_nch;
410 DROP TABLE t_p_ch;
411 DROP TABLE t_p_nch;
412 DROP TABLE t_fixed;
413 DROP TABLE t_dyn;
414 DROP TABLE t_part_online;
415 DROP TABLE t_part_offline;
416 DROP TABLE `t 1 t-1`;
417 DROP TABLE `t-part online`;
418
419 if ($backup_variant == $backup_stream) {
420 --remove_file $streamfile
421 }
422 --rmdir $targetdir
423 --dec $backup_variant
424 }
425