Debian Codegraph @

mysql-test/suite/innodb/r/zlob_rollback_crash_4.result

raw
1 SET GLOBAL innodb_compression_level = 0;
2 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB, KEY(f2(50)))
3 ENGINE=InnoDB ROW_FORMAT=compressed;
4 SHOW CREATE TABLE t1;
5 Table Create Table
6 t1 CREATE TABLE `t1` (
7 `f1` int NOT NULL,
8 `f2` longblob,
9 PRIMARY KEY (`f1`),
10 KEY `f2` (`f2`(50))
11 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (1, REPEAT('abcdefghijklmnopqrstuvwxyz1234', 60006));
14 SET DEBUG = '+d,crash_middle_of_lob_rollback_6';
15 ROLLBACK;
16 ERROR HY000: Lost connection to MySQL server during query
17 # Verify that before the crash, we HAVE NOT reached the index length=4 yet
18 Pattern "Rolling back LOB for transaction \d+ undo number \d+ : current index length 4\." not found
19 # restart
20 SELECT * FROM t1 FOR UPDATE;
21 f1 f2
22 DROP TABLE t1;
23 SET GLOBAL innodb_compression_level = default;
24 # Verify that after the restart, we HAVE reached the index length=4
25 Pattern "Rolling back LOB for transaction \d+ undo number \d+ : current index length 4\." found