Debian Codegraph @

mysql-test/suite/innodb/t/zlob_rollback_crash_3.test

raw
1 #
2 # Bug #29846292 ROLLBACK OF BIG TRANSACTION DUE TO CONFLICT REMAINS IN HUNG STATE
3 #
4 --source include/have_debug.inc
5 --source include/have_innodb_16k.inc
6 --disable_reconnect
7
8 # Valgrind can hang or return spurious messages on DBUG_SUICIDE
9 --source include/not_valgrind.inc
10
11 SET GLOBAL innodb_compression_level = 0;
12
13 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB, KEY(f2(50)))
14 ENGINE=InnoDB ROW_FORMAT=compressed;
15
16 SHOW CREATE TABLE t1;
17
18 START TRANSACTION;
19 # The length of the string is chosen so that the last zstream has less bytes
20 # after decompression (~118), than is required to build a cached prefix
21 # (REC_VERSION_56_MAX_INDEX_COL_LEN = 3072 bytes)
22 INSERT INTO t1 VALUES (1, REPEAT('abcdefghijklmnopqrstuvwxyz1234', 4373));
23 SET DEBUG = '+d,crash_almost_end_of_lob_rollback_0';
24 --source include/expect_crash.inc
25
26 --error CR_SERVER_LOST
27 ROLLBACK;
28
29 --source include/start_mysqld.inc
30
31 SELECT * FROM t1;
32 DROP TABLE t1;
33 SET GLOBAL innodb_compression_level = default;