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