Debian Codegraph @

mysql-test/suite/innodb/r/recovery_shutdown.result

raw
1 FLUSH TABLES;
2 call mtr.add_suppression("Found 1 prepared XA transactions");
3 call mtr.add_suppression("InnoDB: Cannot free the unused segments in system tablespace because a previous shutdown was not with innodb_fast_shutdown=0 or XA PREPARE transactions exist");
4 #
5 # MDEV-13797 InnoDB may hang if shutdown is initiated soon after startup
6 # while rolling back recovered incomplete transactions
7 #
8 connect con$c,localhost,root,,;
9 CREATE TABLE t8 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
10 XA START 'x';
11 INSERT INTO t8 (a) SELECT NULL FROM seq_1_to_100;
12 UPDATE t8 SET a=a+100, b=a;
13 DELETE FROM t8;
14 XA END 'x';
15 XA PREPARE 'x';
16 connect con$c,localhost,root,,;
17 CREATE TABLE t7 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
18 BEGIN;
19 INSERT INTO t7 (a) SELECT NULL FROM seq_1_to_100;
20 UPDATE t7 SET a=a+100, b=a;
21 DELETE FROM t7;
22 connect con$c,localhost,root,,;
23 CREATE TABLE t6 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
24 BEGIN;
25 INSERT INTO t6 (a) SELECT NULL FROM seq_1_to_100;
26 UPDATE t6 SET a=a+100, b=a;
27 DELETE FROM t6;
28 connect con$c,localhost,root,,;
29 CREATE TABLE t5 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
30 BEGIN;
31 INSERT INTO t5 (a) SELECT NULL FROM seq_1_to_100;
32 UPDATE t5 SET a=a+100, b=a;
33 DELETE FROM t5;
34 connect con$c,localhost,root,,;
35 CREATE TABLE t4 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
36 BEGIN;
37 INSERT INTO t4 (a) SELECT NULL FROM seq_1_to_100;
38 UPDATE t4 SET a=a+100, b=a;
39 DELETE FROM t4;
40 connect con$c,localhost,root,,;
41 CREATE TABLE t3 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
42 BEGIN;
43 INSERT INTO t3 (a) SELECT NULL FROM seq_1_to_100;
44 UPDATE t3 SET a=a+100, b=a;
45 DELETE FROM t3;
46 connect con$c,localhost,root,,;
47 CREATE TABLE t2 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
48 BEGIN;
49 INSERT INTO t2 (a) SELECT NULL FROM seq_1_to_100;
50 UPDATE t2 SET a=a+100, b=a;
51 DELETE FROM t2;
52 connect con$c,localhost,root,,;
53 CREATE TABLE t1 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB;
54 BEGIN;
55 INSERT INTO t1 (a) SELECT NULL FROM seq_1_to_100;
56 UPDATE t1 SET a=a+100, b=a;
57 DELETE FROM t1;
58 INSERT INTO t1(a) SELECT NULL FROM seq_1_to_1600;
59 connection default;
60 SET GLOBAL innodb_flush_log_at_trx_commit=1;
61 CREATE TABLE MDEV_29559 (a TINYINT UNSIGNED PRIMARY KEY, KEY(a)) ENGINE=InnoDB;
62 INSERT INTO MDEV_29559 VALUES (0x69);
63 FLUSH TABLES;
64 # restart
65 XA RECOVER;
66 formatID gtrid_length bqual_length data
67 1 1 0 x
68 # restart
69 DROP TABLE MDEV_29559;