Debian Codegraph @

mysql-test/suite/innodb/t/lob_rollback_crash_2.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
7 # Valgrind can hang or return spurious messages on DBUG_SUICIDE
8 --source include/not_valgrind.inc
9
10
11 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB, KEY(f2(50)))
12 ENGINE=InnoDB;
13
14 SHOW CREATE TABLE t1;
15
16 START TRANSACTION;
17 # 6006*30 was chosen in such a way, that the last FIL_PAGE_TYPE_LOB_DATA page
18 # contains less data (1230 bytes) than is required to build a cached prefix
19 # (REC_VERSION_56_MAX_INDEX_COL_LEN = 3072 bytes)
20 INSERT INTO t1 VALUES (1, REPEAT('abcdefghijklmnopqrstuvwxyz1234', 6006));
21 SET DEBUG = '+d,crash_almost_end_of_lob_rollback_0';
22 --source include/expect_crash.inc
23
24 --error CR_SERVER_LOST
25 ROLLBACK;
26
27 --source include/start_mysqld.inc
28
29 SELECT * FROM t1;
30 DROP TABLE t1;