blob: 79e886a8682675ab9a2cc2bc01d4deaea227d928 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
create table t (a int primary key, b int) ENGINE=TokuDB;
insert into t values (1,0);
insert into t values (2,1);
insert into t values (3,2);
set session transaction isolation level repeatable read;
begin;
select * from t lock in share mode;
a b
1 0
2 1
3 2
connect conn1,localhost,root;
set session transaction isolation level repeatable read;
begin;
update t set b=b+1 where a=2;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction
connection default;
commit;
disconnect conn1;
drop table t;
|
