connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
3	3
4	4
5	5
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, index a(a));
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--SK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
a
2
3
4
5
--SK middle row delete
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
--SK end row delete
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
3	3
2	2
1	1
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "rev:cf2", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
3	3
4	4
5	5
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "rev:cf2", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
3	3
2	2
1	1
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
set debug_sync='RESET';
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
create table t1 (id1 int, id2 int, value int, primary key (id1, id2), index sk (id1, value)) engine=rocksdb;
insert into t1 values (1, 1, 1),(1, 2, 1),(1, 3, 1),(1, 4, 1),(1, 5, 1),(2, 2, 2);
--First row delete with PRIMARY
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=100 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=1;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	3	100
1	4	100
1	5	100
--Middle row delete with PRIMARY
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=200 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=3;
set debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	4	100
1	5	100
--End row delete with PRIMARY
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=300 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=5;
set debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	4	100
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
set debug_sync='RESET';
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
create table t1 (id1 int, id2 int, value int, primary key (id1, id2), index sk (id1, value)) engine=rocksdb;
insert into t1 values (1, 1, 1),(1, 2, 1),(1, 3, 1),(1, 4, 1),(1, 5, 1),(2, 2, 2);
--First row delete with sk
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=100 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=1;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	3	100
1	4	100
1	5	100
--Middle row delete with sk
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=200 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=3;
set debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	4	100
1	5	100
--End row delete with sk
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=300 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=5;
set debug_sync='now SIGNAL go';
connection con;
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction (snapshot conflict)
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	4	100
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
3	3
4	4
5	5
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
4	4
5	5
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
4	4
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT, index a(a));
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--SK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
a
2
3
4
5
--SK middle row delete
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
a
2
4
5
--SK end row delete
SET debug_sync='rocksdb_concurrent_delete_sk SIGNAL parked WAIT_FOR go';
SELECT a FROM t1 FORCE INDEX(a) FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
a
2
4
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
3	3
2	2
1	1
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
2	2
1	1
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
2	2
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "rev:cf2", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
3	3
4	4
5	5
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
4	4
5	5
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk ASC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
2	2
4	4
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='RESET';
CREATE TABLE t1 (pk INT PRIMARY KEY COMMENT "rev:cf2", a INT);
INSERT INTO t1 VALUES(1,1), (2,2), (3,3), (4,4), (5,5);
--PK first row delete
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 5;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
3	3
2	2
1	1
--PK middle row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 3;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
2	2
1	1
--PK end row delete
SET debug_sync='rocksdb_concurrent_delete SIGNAL parked WAIT_FOR go';
SELECT * FROM t1 order by t1.pk DESC FOR UPDATE;
connection default;
SET debug_sync='now WAIT_FOR parked';
DELETE FROM t1 WHERE pk = 1;
SET debug_sync='now SIGNAL go';
connection con;
pk	a
4	4
2	2
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
set debug_sync='RESET';
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
create table t1 (id1 int, id2 int, value int, primary key (id1, id2), index sk (id1, value)) engine=rocksdb;
insert into t1 values (1, 1, 1),(1, 2, 1),(1, 3, 1),(1, 4, 1),(1, 5, 1),(2, 2, 2);
--First row delete with PRIMARY
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=100 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=1;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	3	100
1	4	100
1	5	100
--Middle row delete with PRIMARY
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=200 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=3;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	200
1	4	200
1	5	200
--End row delete with PRIMARY
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (PRIMARY) set value=300 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=5;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	300
1	4	300
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;
connect  con, localhost, root,,;
connection default;
set debug_sync='RESET';
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
create table t1 (id1 int, id2 int, value int, primary key (id1, id2), index sk (id1, value)) engine=rocksdb;
insert into t1 values (1, 1, 1),(1, 2, 1),(1, 3, 1),(1, 4, 1),(1, 5, 1),(2, 2, 2);
--First row delete with sk
connection con;
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=100 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=1;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	100
1	3	100
1	4	100
1	5	100
--Middle row delete with sk
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=200 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=3;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	200
1	4	200
1	5	200
--End row delete with sk
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
set debug_sync='rocksdb.get_row_by_rowid SIGNAL parked WAIT_FOR go';
update t1 force index (sk) set value=300 where id1=1;
connection default;
set debug_sync='now WAIT_FOR parked';
delete from t1 where id1=1 and id2=5;
set debug_sync='now SIGNAL go';
connection con;
select * from t1 where id1=1;
id1	id2	value
1	2	300
1	4	300
connection default;
disconnect con;
set debug_sync='RESET';
drop table t1;