Debian Codegraph @

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

raw
1 CREATE TABLE t1 (c1 LONGBLOB) ENGINE=InnoDB;
2 SHOW CREATE TABLE t1;
3 Table Create Table
4 t1 CREATE TABLE `t1` (
5 `c1` longblob
6 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
7 SET @long_str_1 = REPEAT('abcdefghijklmnopqrstuvwxyz1234', 6006);
8 SET @long_str_2 = REPEAT('1234abcdefghijklmnopqrstuvwxyz', 6006);
9 INSERT INTO t1 (c1) VALUES (@long_str_1);
10 SELECT SUBSTRING(c1, 1, 10) FROM t1;
11 SUBSTRING(c1, 1, 10)
12 abcdefghij
13 START TRANSACTION;
14 UPDATE t1 SET c1 = @long_str_2;
15 SELECT SUBSTRING(c1, 1, 10) FROM t1;
16 SUBSTRING(c1, 1, 10)
17 1234abcdef
18 SET DEBUG = '+d,crash_middle_of_lob_rollback_6';
19 ROLLBACK;
20 ERROR HY000: Lost connection to MySQL server during query
21 # Verify that before the crash, we HAVE NOT reached the index length=0 yet
22 Pattern "Rolling back LOB for transaction \d+ undo number \d+ : current index length 0\." not found
23 # restart
24 SELECT SUBSTRING(c1, 1, 10) FROM t1 FOR UPDATE;
25 SUBSTRING(c1, 1, 10)
26 abcdefghij
27 DROP TABLE t1;
28 # Verify that after the restart, we HAVE reached the index length=0
29 Pattern "Rolling back LOB for transaction \d+ undo number \d+ : current index length 0\." found