Debian Codegraph @

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

raw
1 CREATE TABLE t1(id INT PRIMARY key, val VARCHAR(16000))
2 ENGINE=InnoDB STATS_PERSISTENT=0;
3 INSERT INTO t1 (id,val) SELECT 2*seq,'x' FROM seq_0_to_1023;
4 connect con1,localhost,root,,;
5 InnoDB 0 transactions not purged
6 START TRANSACTION WITH CONSISTENT SNAPSHOT;
7 connection default;
8 DELETE FROM t1 WHERE id=1788;
9 SET @saved_dbug = @@GLOBAL.debug_dbug;
10 SET @@GLOBAL.debug_dbug="d,enable_row_purge_del_mark_exit_sync_point";
11 BEGIN;
12 SELECT * FROM t1 WHERE id=1788 FOR UPDATE;
13 id val
14 connection con1;
15 COMMIT;
16 SET DEBUG_SYNC = 'now WAIT_FOR row_purge_del_mark_finished';
17 SET @@GLOBAL.debug_dbug = @saved_dbug;
18 connection default;
19 INSERT INTO t1 (id,val) VALUES (1787, REPEAT('x',2000));
20 connection con1;
21 SET innodb_lock_wait_timeout=0;
22 INSERT INTO t1 (id,val) VALUES (1788, 'x');
23 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
24 SELECT * FROM t1 WHERE id=1788 FOR UPDATE;
25 id val
26 disconnect con1;
27 connection default;
28 COMMIT;
29 DROP TABLE t1;