Cause: Your session and another session are waiting for a resource locked by the other. This condition is known as a deadlock. To resolve the deadlock, one or more statements were rolled back for the other session to continue work.

Action: Either:


Enter a ROLLBACK statement and re-execute all statements since the last commit or

Wait until the lock is released, possibly a few minutes, and then re-execute the rolled back statements.