Debian Codegraph @

mysql-test/suite/mariabackup/incremental_backup.result

raw
1 call mtr.add_suppression("InnoDB: New log files created");
2 CREATE TABLE t_aria(i INT) ENGINE ARIA;
3 CREATE TABLE t(i INT PRIMARY KEY) ENGINE INNODB;
4 INSERT INTO t VALUES(100);
5 BEGIN;
6 INSERT INTO t VALUES(2);
7 connect con1,localhost,root,,;
8 SET GLOBAL innodb_flush_log_at_trx_commit = 1;
9 INSERT INTO t VALUES(1);
10 # Create full backup , modify table, then create incremental/differential backup
11 BEGIN;
12 INSERT INTO t VALUES(0);
13 DELETE FROM t WHERE i=0;
14 connection default;
15 COMMIT;
16 # Generate enough aria log records to increase area log file size
17 SELECT * FROM t;
18 i
19 1
20 2
21 100
22 # Prepare full backup, apply incremental one
23 # Aria log file was updated during applying incremental backup
24 disconnect con1;
25 # Restore and check results
26 # shutdown server
27 # remove datadir
28 # xtrabackup move back
29 # restart
30 SELECT * FROM t;
31 i
32 1
33 2
34 100
35 DROP TABLE t;
36 DROP TABLE t_aria;