Debian Codegraph @

mysql-test/suite/mariabackup/apply-log-only-incr.result

raw
1 call mtr.add_suppression("InnoDB: New log files created");
2 CREATE TABLE t(a INT UNSIGNED PRIMARY KEY) ENGINE INNODB;
3 INSERT INTO t VALUES(0);
4 COMMIT;
5 start transaction;
6 connect flush_log,localhost,root,,;
7 BEGIN;
8 DELETE FROM t LIMIT 1;
9 SET GLOBAL innodb_flush_log_at_trx_commit = 1;
10 ROLLBACK;
11 disconnect flush_log;
12 connection default;
13 NOT FOUND /Rolled back recovered transaction/ in current_test
14 # expect NOT FOUND
15 NOT FOUND /Rolled back recovered transaction/ in current_test
16 # expect NOT FOUND
17 commit;
18 SELECT count(*) FROM t;
19 count(*)
20 201
21 # Restore and check results
22 # shutdown server
23 # remove datadir
24 # xtrabackup move back
25 # restart: --innodb-force-recovery=3
26 SELECT COUNT(*) FROM t;
27 COUNT(*)
28 1
29 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
30 SELECT COUNT(*) FROM t;
31 COUNT(*)
32 201
33 # restart
34 SELECT * FROM t;
35 a
36 0
37 DROP TABLE t;