Debian Codegraph @

mysql-test/suite/parts/r/partition_innodb_status_file.result

raw
1 CREATE TABLE t1 (a INT) ENGINE = InnoDB PARTITION BY HASH(a);
2 INSERT INTO t1 VALUES (0), (1), (2);
3 START TRANSACTION;
4 UPDATE t1 SET a = 5 WHERE a = 1;
5 # Connection con1
6 # InnoDB lock timeout and monitor thread runs every 15 seconds
7 SET innodb_lock_wait_timeout = 20;
8 START TRANSACTION;
9 UPDATE t1 SET a = 3 WHERE a = 1;
10 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
11 COMMIT;
12 # Connection default
13 COMMIT;
14 DROP TABLE t1;