# # Bug #29846292 ROLLBACK OF BIG TRANSACTION DUE TO CONFLICT REMAINS IN HUNG STATE # --source include/have_debug.inc --source include/have_innodb_16k.inc --disable_reconnect # Valgrind can hang or return spurious messages on DBUG_SUICIDE --source include/not_valgrind.inc SET GLOBAL innodb_compression_level = 0; CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB, KEY(f2(50))) ENGINE=InnoDB ROW_FORMAT=compressed; SHOW CREATE TABLE t1; START TRANSACTION; # The length of the string is chosen so that the last zstream has less bytes # after decompression (~118), than is required to build a cached prefix # (REC_VERSION_56_MAX_INDEX_COL_LEN = 3072 bytes) INSERT INTO t1 VALUES (1, REPEAT('abcdefghijklmnopqrstuvwxyz1234', 4373)); SET DEBUG = '+d,crash_almost_end_of_lob_rollback_0'; --source include/expect_crash.inc --error CR_SERVER_LOST ROLLBACK; --source include/start_mysqld.inc SELECT * FROM t1; DROP TABLE t1; SET GLOBAL innodb_compression_level = default;