Debian Codegraph @

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

raw
1 #
2 # Bug #29846292 ROLLBACK OF BIG TRANSACTION DUE TO CONFLICT REMAINS IN HUNG STATE
3 #
4 --source include/have_innodb_max_16k.inc
5
6 # In this scenario, we create a LOB which does not fit in the buffer pool, thus
7 # the rollback has to be smart about managing pages.
8 # In particular a buggy implementaiton which tries to keep all pages of the LOB
9 # in the memory until mini-transaction commits, will deadlock with itself at
10 # some point when trying to fetch next page of the LOB from storage to already
11 # fully saturated buffer pool.
12
13 SET GLOBAL innodb_compression_level = 0;
14
15 CREATE TABLE t1 (id INT PRIMARY KEY NOT NULL, val LONGTEXT)
16 ENGINE=InnoDB ROW_FORMAT=compressed;
17 BEGIN;
18 INSERT INTO t1 VALUES (1, repeat('a',6000000));
19 ROLLBACK;
20 DROP TABLE t1;
21
22 SET GLOBAL innodb_compression_level = default;