Debian Codegraph @

mysql-test/suite/mariabackup/incremental_drop_db.test

raw
1 --source include/have_innodb.inc
2 call mtr.add_suppression("InnoDB: New log files created");
3
4 --echo #
5 --echo # Start of 10.3 tests
6 --echo #
7
8 --echo #
9 --echo # MDEV-23335 MariaBackup Incremental Does Not Reflect Dropped/Created Databases
10 --echo #
11
12 --let $datadir=`SELECT @@datadir`
13 --let $basedir=$MYSQLTEST_VARDIR/tmp/backup
14 --let $incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1
15
16 # Create two databases:
17 # - db1 is dropped normally below
18 # - db2 is used to cover a corner case: its db.opt file is removed
19
20 # Incremental backup contains:
21 # - no directory for db1
22 # - an empty directory for db2 (after we remove db2/db.opt)
23
24
25 CREATE DATABASE db1;
26 CREATE DATABASE db2;
27
28 # Add some tables to db1
29 CREATE TABLE db1.t1 (a INT) ENGINE=MyISAM;
30 CREATE TABLE db1.t2 (a INT) ENGINE=InnoDB;
31
32 --echo # Create base backup
33 --disable_result_log
34 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$basedir
35 --enable_result_log
36
37 DROP DATABASE db1;
38
39 --echo # Create incremental backup
40 --exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$incremental_dir --incremental-basedir=$basedir
41
42 --echo # Remove incremental_dir/db2/db.opt file to make incremental_dir/db2/ empty
43 --remove_file $incremental_dir/db2/db.opt
44
45
46 --echo # Prepare base backup, apply incremental one
47 --disable_result_log
48 --exec $XTRABACKUP --prepare --target-dir=$basedir
49 --exec $XTRABACKUP --prepare --target-dir=$basedir --incremental-dir=$incremental_dir
50 --enable_result_log
51
52 --let $targetdir=$basedir
53 --source include/restart_and_restore.inc
54 --enable_result_log
55
56 --echo # Expect no 'db1' in the output, because it was really dropped.
57 --echo # Expect 'db2' in the ouput, because it was not dropped!
58 --echo # (its incremental directory was emptied only)
59
60 SHOW DATABASES LIKE 'db%';
61 DROP DATABASE db2;
62
63 --rmdir $basedir
64 --rmdir $incremental_dir
65
66 --echo #
67 --echo # End of 10.3 tests
68 --echo #