EVOLUTION-MANAGER

Edit File: rocksdb_deadlock_detect_rr.result

set @prior_rocksdb_lock_wait_timeout = @@rocksdb_lock_wait_timeout;
set @prior_rocksdb_deadlock_detect = @@rocksdb_deadlock_detect;
set global rocksdb_lock_wait_timeout = 100000;
set global rocksdb_deadlock_detect = ON;
create table t (i int primary key);
create table r1 (id int primary key, value int);
insert into r1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
create table r2 like r1;
insert into r2 select * from r1;
connect  con1,localhost,root,,;
begin;
update r2 set value=100 where id=9;
connect  con2,localhost,root,,;
begin;
update r1 set value=100 where id=8;
select * from r2 for update;;
connection con1;
select * from r1 for update;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
rollback;
connection con2;
id	value
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	10
rollback;
connection con1;
begin;
insert into t values (1);
connection con2;
begin;
insert into t values (2);
connect  con3,localhost,root,,;
begin;
insert into t values (3);
connection con1;
select * from t where i = 2 for update;
connection con2;
select * from t where i = 3 for update;
connection con3;
select * from t;
i
3
insert into t values (4), (1);
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
# Transaction should be rolled back
select * from t;
i
rollback;
connection con2;
i
rollback;
connection con1;
i
rollback;
connection default;
create table t1 (id int primary key, value int, value2 int, index(value)) engine=rocksdb;
insert into t1 values (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5),(6,6,6),(7,7,7),(8,8,8),(9,9,9),(10,10,10);
connection con1;
begin;
update t1 force index (value) set value2=value2+1 where value=3;
connection con2;
begin;
update t1 force index (value) set value2=value2+1 where value=2;
update t1 force index (value) set value2=value2+1 where value=4;
connection con1;
update t1 force index (value) set value2=value2+1 where value=4;
connection con2;
update t1 force index (value) set value2=value2+1 where value=3;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
connection con1;
rollback;
connection con2;
rollback;
drop table t1;
connection default;
disconnect con1;
disconnect con2;
disconnect con3;
set global rocksdb_lock_wait_timeout = @prior_rocksdb_lock_wait_timeout;
set global rocksdb_deadlock_detect = @prior_rocksdb_deadlock_detect;
drop table t,r1,r2;