We also faced this issue. Our solution is adding  `select ... for update` before `delete from ... where`. The isolation level must be Read Committed.