Debian Codegraph @

mysql-test/suite/innodb/t/lock_deleted.test

raw
1 --source include/have_innodb.inc
2 --source include/have_debug.inc
3 --source include/have_debug_sync.inc
4
5 --source include/count_sessions.inc
6
7 connect(stop_purge, localhost, root,,);
8 START TRANSACTION WITH CONSISTENT SNAPSHOT;
9 connect(delete, localhost, root,,);
10 connection default;
11
12 CREATE TABLE t1(a INT PRIMARY KEY, b INT UNIQUE) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES(1,1);
14 DELETE FROM t1;
15
16 let $i=2;
17 while ($i) {
18 let $iso= `SELECT CASE $i WHEN 1 THEN 'UNCOMMITTED' ELSE 'COMMITTED' END`;
19
20 SET DEBUG_SYNC='row_ins_sec_index_unique SIGNAL inserted WAIT_FOR locked';
21 BEGIN;
22 send INSERT INTO t1 VALUES(1,1);
23
24 connection delete;
25 SET DEBUG_SYNC='now WAIT_FOR inserted';
26 SET DEBUG_SYNC='innodb_row_search_for_mysql_exit SIGNAL locked';
27 eval SET SESSION TRANSACTION ISOLATION LEVEL READ $iso;
28 BEGIN;
29 send DELETE FROM t1 WHERE b=1;
30
31 connection default;
32 reap;
33 connection delete;
34 reap;
35 COMMIT;
36
37 connection default;
38 SET DEBUG_SYNC='RESET';
39 ROLLBACK;
40
41 dec $i;
42 }
43
44 SET DEBUG_SYNC='row_ins_sec_index_unique SIGNAL inserted WAIT_FOR locked';
45 BEGIN;
46 SET innodb_lock_wait_timeout=1;
47 send INSERT INTO t1 VALUES(1,1);
48
49 connection delete;
50 SET DEBUG_SYNC='now WAIT_FOR inserted';
51 SET DEBUG_SYNC='innodb_row_search_for_mysql_exit SIGNAL locked';
52 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
53 BEGIN;
54 send DELETE FROM t1 WHERE b=1;
55
56 connection default;
57 --error ER_LOCK_WAIT_TIMEOUT
58 reap;
59 COMMIT;
60 SET DEBUG_SYNC='RESET';
61
62 connection delete;
63 reap;
64 COMMIT;
65
66 disconnect delete;
67 disconnect stop_purge;
68
69 connection default;
70 DROP TABLE t1;
71
72 --source include/wait_until_count_sessions.inc