diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/recovery_shutdown.result')
| -rw-r--r-- | mysql-test/suite/innodb/r/recovery_shutdown.result | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/suite/innodb/r/recovery_shutdown.result b/mysql-test/suite/innodb/r/recovery_shutdown.result index b21beecc24b..dc785d580fe 100644 --- a/mysql-test/suite/innodb/r/recovery_shutdown.result +++ b/mysql-test/suite/innodb/r/recovery_shutdown.result @@ -1,4 +1,5 @@ FLUSH TABLES; +call mtr.add_suppression("Found 1 prepared XA transactions"); # # MDEV-13797 InnoDB may hang if shutdown is initiated soon after startup # while rolling back recovered incomplete transactions @@ -8,10 +9,12 @@ BEGIN; COMMIT; connect con$c,localhost,root,,; CREATE TABLE t8 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB; -BEGIN; +XA START 'x'; INSERT INTO t8 (a) SELECT NULL FROM t; UPDATE t8 SET a=a+100, b=a; DELETE FROM t8; +XA END 'x'; +XA PREPARE 'x'; connect con$c,localhost,root,,; CREATE TABLE t7 (a SERIAL, b INT UNIQUE, c INT UNIQUE) ENGINE=InnoDB; BEGIN; @@ -65,5 +68,8 @@ CREATE TABLE u(a SERIAL) ENGINE=INNODB; FLUSH TABLES; # restart # restart +XA RECOVER; +formatID gtrid_length bqual_length data +1 1 0 x # restart DROP TABLE t,u; |