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