| 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; |