Debian Codegraph @

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

raw
1 connect stop_purge, localhost, root,,;
2 START TRANSACTION WITH CONSISTENT SNAPSHOT;
3 connect delete, localhost, root,,;
4 connection default;
5 CREATE TABLE t1(a INT PRIMARY KEY, b INT UNIQUE) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES(1,1);
7 DELETE FROM t1;
8 SET DEBUG_SYNC='row_ins_sec_index_unique SIGNAL inserted WAIT_FOR locked';
9 BEGIN;
10 INSERT INTO t1 VALUES(1,1);
11 connection delete;
12 SET DEBUG_SYNC='now WAIT_FOR inserted';
13 SET DEBUG_SYNC='innodb_row_search_for_mysql_exit SIGNAL locked';
14 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
15 BEGIN;
16 DELETE FROM t1 WHERE b=1;
17 connection default;
18 connection delete;
19 COMMIT;
20 connection default;
21 SET DEBUG_SYNC='RESET';
22 ROLLBACK;
23 SET DEBUG_SYNC='row_ins_sec_index_unique SIGNAL inserted WAIT_FOR locked';
24 BEGIN;
25 INSERT INTO t1 VALUES(1,1);
26 connection delete;
27 SET DEBUG_SYNC='now WAIT_FOR inserted';
28 SET DEBUG_SYNC='innodb_row_search_for_mysql_exit SIGNAL locked';
29 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
30 BEGIN;
31 DELETE FROM t1 WHERE b=1;
32 connection default;
33 connection delete;
34 COMMIT;
35 connection default;
36 SET DEBUG_SYNC='RESET';
37 ROLLBACK;
38 SET DEBUG_SYNC='row_ins_sec_index_unique SIGNAL inserted WAIT_FOR locked';
39 BEGIN;
40 SET innodb_lock_wait_timeout=1;
41 INSERT INTO t1 VALUES(1,1);
42 connection delete;
43 SET DEBUG_SYNC='now WAIT_FOR inserted';
44 SET DEBUG_SYNC='innodb_row_search_for_mysql_exit SIGNAL locked';
45 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
46 BEGIN;
47 DELETE FROM t1 WHERE b=1;
48 connection default;
49 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
50 COMMIT;
51 SET DEBUG_SYNC='RESET';
52 connection delete;
53 COMMIT;
54 disconnect delete;
55 disconnect stop_purge;
56 connection default;
57 DROP TABLE t1;