Debian Codegraph @

mysql-test/suite/innodb/t/zlob_rollback_crash_4.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_max_16k.inc
6
7 # Valgrind can hang or return spurious messages on DBUG_SUICIDE
8 --source include/not_valgrind.inc
9
10 SET GLOBAL innodb_compression_level = 0;
11
12 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB, KEY(f2(50)))
13 ENGINE=InnoDB ROW_FORMAT=compressed;
14
15 SHOW CREATE TABLE t1;
16
17 START TRANSACTION;
18 INSERT INTO t1 VALUES (1, REPEAT('abcdefghijklmnopqrstuvwxyz1234', 60006));
19 SET DEBUG = '+d,crash_middle_of_lob_rollback_6';
20 --source include/expect_crash.inc
21
22 --error CR_SERVER_LOST
23 ROLLBACK;
24
25 --echo # Verify that before the crash, we HAVE NOT reached the index length=4 yet
26 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
27
28 let SEARCH_PATTERN= Rolling back LOB for transaction \d+ undo number \d+ : current index length 4\.;
29 --source include/search_pattern.inc
30
31 --source include/start_mysqld.inc
32
33 SELECT * FROM t1 FOR UPDATE;
34 DROP TABLE t1;
35 SET GLOBAL innodb_compression_level = default;
36
37 --echo # Verify that after the restart, we HAVE reached the index length=4
38 --source include/search_pattern.inc