Debian Codegraph @

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

raw
1 SET @save_innodb_timeout=@@innodb_lock_wait_timeout;
2 SET GLOBAL innodb_lock_wait_timeout=1;
3 set session transaction isolation level read committed;
4 create table innodb_bug52663 (what varchar(5), id integer, count integer, primary key
5 (what, id)) engine=innodb;
6 insert into innodb_bug52663 values ('total', 0, 0);
7 begin;
8 connect addconroot, localhost, root,,;
9 set session transaction isolation level read committed;
10 begin;
11 connection default;
12 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
13 select * from innodb_bug52663;
14 what id count
15 total 0 1
16 connection addconroot;
17 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
18 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
19 select * from innodb_bug52663;
20 what id count
21 total 0 0
22 connection default;
23 commit;
24 connection addconroot;
25 update innodb_bug52663 set count = count + 1 where what = 'total' and id = 0;
26 commit;
27 select * from innodb_bug52663;
28 what id count
29 total 0 2
30 connection default;
31 select * from innodb_bug52663;
32 what id count
33 total 0 2
34 drop table innodb_bug52663;
35 SET GLOBAL innodb_lock_wait_timeout=@save_innodb_timeout;