oceanbase

1
drop table if exists t1;
2
set timeout to 10s
3
set global  ob_trx_timeout = 10000000;
4
create table t1(c1 int primary key, c2 int);
5
insert into t1 values(1,1);
6
insert into t1 values(2,2);
7
insert into t1 values(3,3);
8
create 2 sessions
9
trx timeout
10
begin;
11
insert into t1 values(4,4);
12
insert into t1 values(5,5);
13
insert into t1 values(6,6);
14
commit;
15
select * from t1;
16
c1	c2
17
1	1
18
2	2
19
3	3
20
4	4
21
5	5
22
6	6
23
begin;
24
insert into t1 values(7,7);
25
insert into t1 values(8,8);
26
insert into t1 values(9,9);
27
insert into t1 values(10,10);
28
commit;
29
ERROR 40000: Transaction rollbacked
30
select * from t1;
31
c1	c2
32
1	1
33
2	2
34
3	3
35
4	4
36
5	5
37
6	6
38
trx idle timeout
39
begin;
40
insert into t1 values(11,11);
41
insert into t1 values(12,12);
42
ERROR 25000: Transaction timeout occurred, please rollback the transaction, set the variable ob_trx_timeout to a larger value and then restart the transaction
43
commit;
44
ERROR 40000: Transaction rollbacked
45
select * from t1;
46
c1	c2
47
1	1
48
2	2
49
3	3
50
4	4
51
5	5
52
6	6
53
test two users
54
set global  ob_trx_timeout = 100000000;
55