Debian Codegraph @

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

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