Re: need help about deadlock by insert statements

Darek, first of all, thanks for your reply.

In your explanation, there should be 2 trace files, one is related to the transaction with insert statement on table U by session A, the other is related to the transaction with update statement on table T by session B.

But (sorry I did not mentioned in my original message) in my case, both deadlock trace files are refering to an insert statement on the same table. The inserts in both traces are identical and some binding variables are used on the values clause. And there are no lock table DML executed within the transactions that causes the deadlock. In fact, it is a UNIX script that execute serveral processes in background, which in turns insert records onto a table in the database.

Do you or anyone have any further clues on why this is so? Received on Thu Aug 20 1998 - 05:29:33 CDT