Debian Codegraph @

mysql-test/suite/mariabackup/unsupported_redo.test

raw
1 --source include/have_innodb.inc
2 --source include/innodb_undo_tablespaces.inc
3 call mtr.add_suppression("InnoDB: New log files created");
4 call mtr.add_suppression("InnoDB: Operating system error number .* in a file operation");
5 call mtr.add_suppression("InnoDB: The error means the system cannot find the path specified");
6 call mtr.add_suppression("InnoDB: Ignoring tablespace for `test`\\.`t21` because it could not be opened");
7 call mtr.add_suppression("InnoDB: Cannot open datafile for read-only: ");
8 call mtr.add_suppression("Table .* in the InnoDB data dictionary has tablespace id .*, but tablespace with that id or name does not exist");
9
10 let $basedir=$MYSQLTEST_VARDIR/tmp/backup;
11 let $incremental_dir=$MYSQLTEST_VARDIR/tmp/backup_inc1;
12
13 CREATE TABLE t1(i INT PRIMARY KEY auto_increment, a int) ENGINE INNODB;
14 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
15
16 echo # No longer fails during full backup;
17 --disable_result_log
18 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$basedir;
19 --enable_result_log
20
21 DROP TABLE t1;
22
23 rmdir $basedir;
24
25 CREATE TABLE t1(i INT PRIMARY KEY auto_increment, a int) ENGINE INNODB;
26
27 INSERT INTO t1(a) select 1 union select 2 union select 3;
28
29 --echo # Create full backup , modify table, then fails during creation of
30 --echo # incremental/differential backup
31 --disable_result_log
32 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$basedir;
33 --enable_result_log
34
35 ALTER TABLE t1 FORCE, ALGORITHM=INPLACE;
36
37 --disable_result_log
38 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$incremental_dir --incremental-basedir=$basedir;
39 --enable_result_log
40
41 DROP TABLE t1;
42
43 rmdir $basedir;rmdir $incremental_dir;
44
45 CREATE TABLE t1(i INT) ENGINE INNODB;
46 INSERT INTO t1 VALUES(1);
47 CREATE TABLE t21(i INT) ENGINE INNODB;
48 INSERT INTO t21 VALUES(1);
49
50 let $MYSQLD_DATADIR= `select @@datadir`;
51 let $targetdir=$MYSQLTEST_VARDIR/tmp/bk;
52
53 CREATE TABLE t2(i int) ENGINE INNODB;
54
55 ALTER TABLE t21 FORCE, ALGORITHM=INPLACE;
56
57 --echo # Create partial backup (excluding table t21), Ignore the
58 --echo # unsupported redo log for the table t21.
59
60 --disable_result_log
61 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 "--tables-exclude=test.t21" --target-dir=$targetdir --innodb_log_checkpoint_now=1;
62 --enable_result_log
63 --list_files $targetdir/test *.ibd
64 --list_files $targetdir/test *.new
65
66 --echo # Prepare the full backup
67 --disable_result_log
68 exec $XTRABACKUP --prepare --target-dir=$targetdir;
69 --enable_result_log
70 --list_files $targetdir/test *.ibd
71
72 DROP TABLE t1;
73 DROP TABLE t2;
74 DROP TABLE t21;
75 rmdir $targetdir;