Debian Codegraph @

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

raw
1 SET GLOBAL innodb_compression_level = 0;
2 CREATE TABLESPACE ts1 FILE_BLOCK_SIZE=8K;
3 CREATE TABLE t1 (
4 id INT PRIMARY KEY,
5 make_big CHAR(200),
6 val LONGBLOB
7 ) ROW_FORMAT=compressed TABLESPACE ts1;
8 CREATE TABLE t2 (
9 id INT PRIMARY KEY,
10 make_big CHAR(200),
11 val LONGBLOB
12 ) ROW_FORMAT=compressed TABLESPACE ts1;
13 INSERT INTO t2 (id,val) VALUES (1,REPEAT('a',1000000));
14 INSERT INTO t1 (id,val) VALUES (2,REPEAT('a',1000000));
15 INSERT INTO t2 (id,val) VALUES (2,REPEAT('a',1000000));
16 INSERT INTO t1 (id,val) VALUES (3,REPEAT('a',1000000));
17 INSERT INTO t2 (id,val) VALUES (3,REPEAT('a',312000));
18 INSERT INTO t2 (id,val) VALUES (4,REPEAT('a',13));
19 BEGIN;
20 UPDATE t2 SET val = REPEAT('b',1000000) WHERE id=4;
21 SET DEBUG_SYNC=
22 'ib_blob_update_rollback_will_reserve
23 SIGNAL con1_will_reserve
24 WAIT_FOR con1_can_reserve';
25 ROLLBACK;
26 SET DEBUG_SYNC='now WAIT_FOR con1_will_reserve';
27 BEGIN;
28 INSERT INTO t1 (id,val) VALUES (4000,REPEAT('b',10000000));
29 SET DEBUG_SYNC='now SIGNAL con1_can_reserve';
30 ROLLBACK;
31 DROP TABLE t1;
32 DROP TABLE t2;
33 DROP TABLESPACE ts1;
34 SET GLOBAL innodb_compression_level = default;