1 drop table if exists t1;
2 show variables like 'innodb_rollback_on_timeout';
4 innodb_rollback_on_timeout ON
5 create table t1 (a int unsigned not null primary key) engine = innodb;
6 insert into t1 values (1);
9 insert into t1 values (2);
15 insert into t1 values (5);
20 insert into t1 values (2);
21 ERROR HY000: Lock wait timeout exceeded; try restarting transaction