Debian Codegraph @

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

raw
1 CREATE TABLESPACE ts1;
2 CREATE TABLE t1 (
3 id INT PRIMARY KEY,
4 make_big CHAR(200),
5 val LONGBLOB
6 ) TABLESPACE ts1;
7 CREATE TABLE t2 (
8 id INT PRIMARY KEY,
9 make_big CHAR(200),
10 val LONGBLOB
11 ) TABLESPACE ts1;
12 INSERT INTO t1 (id,val) VALUES (1,REPEAT('a',1000000));
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',523809));
18 BEGIN;
19 UPDATE t2 SET val = REPEAT('b',10000) WHERE id=3;
20 SET DEBUG_SYNC=
21 'ib_blob_update_rollback_will_reserve
22 SIGNAL con1_will_reserve
23 WAIT_FOR con1_can_reserve';
24 ROLLBACK;
25 SET DEBUG_SYNC='now WAIT_FOR con1_will_reserve';
26 BEGIN;
27 INSERT INTO t1 (id,val) VALUES (4000,REPEAT('b',1000000));
28 SET DEBUG_SYNC='now SIGNAL con1_can_reserve';
29 ROLLBACK;
30 DROP TABLE t1;
31 DROP TABLE t2;
32 DROP TABLESPACE ts1;