Invalid Error: resource deadlock would occur

[levcom]

I'm performing a row insertion transaction (the primary key "" - already exists), but I'm getting a "duplicate key error" (Constraint Error: Duplicate key violates primary key constraint. If this is an unexpected constraint violation please double check with the known index limitations section in our documentation (docs - sql - indexes)).

After this I cannot perform another insert or select operation and receive the following error.
Error: Invalid Error: resource deadlock would occur: resource deadlock would occur

Perhaps I need to process the transaction in some special way?
How can you identify and resolve the blockage that has occurred?

As I understand the question in Over-Eager Unique Constraint Checking. But how to correctly handle the error so that there are no deadlocks?

[wangfenjin]

we may need to close the error connection and create a new one