Debian Codegraph @

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

raw
1 #
2 # Bug #30258536 DEADLOCK BETWEEN LOB::ALLOC_LOB_PAGE AND ROW_UNDO_MOD_CLUST_LOW
3 #
4 # This scenario is for regression caused by fix for
5 # Bug #30178056 .IBD FILE GROWS INDEFINITELY FOR TABLES WITH BLOB COLUMNS
6 # which introduced an operation which latches first page during ROLLBACK,
7 # that leads to a failure of the assertion introduced in
8 # Bug #27777959 INNODB: ASSERTION FAILURE: UT0UT.CC DUE TO DEADLOCK AT FSP_PAGE_CREATE()
9 # which states that the first page of zLOB should not be latched during lob::z_rollback
10 #
11 --source include/have_innodb_16k.inc
12 SET GLOBAL innodb_compression_level = 0;
13
14 CREATE TABLE t1 (
15 id INT PRIMARY KEY,
16 val LONGBLOB
17 ) ENGINE=InnoDB ROW_FORMAT=compressed;
18 INSERT INTO t1 (id,val) VALUES (1,REPEAT('a',13));
19
20 BEGIN;
21 UPDATE t1 SET val = REPEAT('b',1000000) WHERE id=1;
22 ROLLBACK;
23
24 DROP TABLE t1;
25 SET GLOBAL innodb_compression_level = default;