Debian Codegraph @

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

raw
1 connection default;
2 CREATE TABLE t1(
3 id INT,
4 PRIMARY KEY(id)
5 ) ENGINE=InnoDB;
6 CREATE TABLE dl(
7 id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
8 cnt INT UNSIGNED
9 ) ENGINE=InnoDB;
10 INSERT INTO t1 VALUES(1), (2), (3);
11 INSERT INTO dl(cnt) SELECT variable_value FROM information_schema.global_status WHERE variable_name LIKE 'Innodb_deadlocks';
12 BEGIN;
13 SELECT * FROM t1 WHERE id = 1 LOCK IN SHARE MODE;
14 connect con1,localhost,root,,;
15 BEGIN;
16 SELECT * FROM t1 WHERE id = 2 LOCK IN SHARE MODE;
17 connect con2,localhost,root,,;
18 BEGIN;
19 SELECT * FROM t1 WHERE id = 2 LOCK IN SHARE MODE;
20 SELECT * FROM t1 WHERE id = 1 FOR UPDATE;
21 connection default;
22 SELECT * FROM t1 WHERE id = 2 FOR UPDATE;
23 connection con2;
24 disconnect con1;
25 ROLLBACK;
26 disconnect con2;
27 connection default;
28 'Deadlock counter is valid';
29 1
30 ROLLBACK;
31 DROP TABLE t1;
32 DROP TABLE dl;