Debian Codegraph @

mysql-test/suite/mariabackup/full_backup.result

raw
1 CREATE TABLE t(i INT) ENGINE INNODB;
2 INSERT INTO t VALUES(1);
3 SET GLOBAL innodb_max_purge_lag_wait=0;
4 # xtrabackup backup
5 NOT FOUND /InnoDB: Allocated tablespace ID/ in backup.log
6 SELECT variable_value FROM information_schema.global_status
7 WHERE variable_name = 'INNODB_BUFFER_POOL_PAGES_DIRTY';
8 variable_value
9 0
10 INSERT INTO t VALUES(2);
11 # xtrabackup prepare
12 # shutdown server
13 # remove datadir
14 # xtrabackup move back
15 # restart
16 SELECT * FROM t;
17 i
18 1
19 DROP TABLE t;
20 #
21 # MDEV-27121 mariabackup incompatible with disabled dedicated
22 # undo log tablespaces
23 #
24 call mtr.add_suppression("InnoDB: innodb_undo_tablespaces=0 disables dedicated undo log tablespaces");
25 call mtr.add_suppression("InnoDB: Cannot change innodb_undo_tablespaces=0 because previous shutdown was not with innodb_fast_shutdown=0");
26 call mtr.add_suppression("Found 1 prepared XA transactions");
27 CREATE TABLE t(f1 INT NOT NULL)ENGINE=InnoDB;
28 XA START 'zombie';
29 INSERT INTO t VALUES(1);
30 XA END 'zombie';
31 XA PREPARE 'zombie';
32 # restart: --innodb_undo_tablespaces=0
33 # xtrabackup backup
34 # xtrabackup prepare
35 # shutdown server
36 # remove datadir
37 # xtrabackup move back
38 # restart: --innodb_undo_tablespaces=0
39 # Display undo log files from target directory
40 undo001
41 undo002
42 XA COMMIT 'zombie';
43 DROP TABLE t;