Debian Codegraph @

mysql-test/suite/innodb/r/mdev-117.result

raw
1 SET GLOBAL innodb_lock_wait_timeout=3;
2 CREATE TABLE t1 (col_int_key INT, KEY (col_int_key)) ENGINE=InnoDB;
3 INSERT INTO t1 VALUES (6);
4 connect con1,localhost,root,,test;
5 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
6 SET AUTOCOMMIT=OFF;
7 SELECT col_int_key FROM t1;
8 col_int_key
9 6
10 connection default;
11 DELETE IGNORE FROM t1;;
12 connection con1;
13 DELETE FROM t1 WHERE col_int_key IN (1, 40000000);
14 connection default;
15 disconnect con1;
16 drop table t1;
17 SET GLOBAL innodb_lock_wait_timeout=default;
18 call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");