| 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; |