Debian Codegraph @

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

raw
1 set global innodb_lock_wait_timeout=42;
2 select @@innodb_lock_wait_timeout;
3 @@innodb_lock_wait_timeout
4 42
5 set innodb_lock_wait_timeout=1;
6 select @@innodb_lock_wait_timeout;
7 @@innodb_lock_wait_timeout
8 1
9 select @@innodb_lock_wait_timeout;
10 @@innodb_lock_wait_timeout
11 42
12 set global innodb_lock_wait_timeout=347;
13 select @@innodb_lock_wait_timeout;
14 @@innodb_lock_wait_timeout
15 42
16 set innodb_lock_wait_timeout=10;
17 select @@innodb_lock_wait_timeout;
18 @@innodb_lock_wait_timeout
19 10
20 select @@innodb_lock_wait_timeout;
21 @@innodb_lock_wait_timeout
22 347
23 SET @connection_b_id = <connection_b_id>;
24 create table t1(a int primary key)engine=innodb;
25 begin;
26 insert into t1 values(1),(2),(3);
27 select * from t1 for update;
28 commit;
29 a
30 1
31 2
32 3
33 begin;
34 insert into t1 values(4);
35 set innodb_lock_wait_timeout=3;
36 select * from t1 for update;
37 commit;
38 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
39 drop table t1;
40 set global innodb_lock_wait_timeout=<initial_timeout>;