ORA-01591: lock held by in-doubt distributed transaction
Got a mail from one of the developers that he is getting "ORA-01591: lock held by in-doubt distributed transaction 10.45.34659" error.
The query he is running is just a simple update query connecting directly to the schema.
set =3134 where =1020
I have verified in dba_2pc_pending view and force rollback the transaction with the above ID and the issue is resolved.
I am trying to understand why the simple update query is showing in distributed transactions? Appreciate your inputs.
10-20-2009, 09:42 AM
I am sorry, looks like some thing mess-up with my post. Please don't mind.
10-20-2009, 09:46 AM
ORA-01501 tells affected query found a locked resource - in this case I assume the updated table. Resource was locked by a dead distributed transaction.
The simple "update" query did not cause the distributed transaction issue - it just happened to bump into a locked table.
10-20-2009, 09:58 AM
Yes, I see some transactions in dba_2pc_table and rolled back those transactions to release the lock. I am trying to find from which dblink / machine those transactions are distributing. If you have some thing on your finger tips please share.