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.
Last edited by vnktummala; 10-20-2009 at 08:43 AM.
Try hard to get what you like OR you will be forced to like what you get.
Click Here to Expand Forum to Full Width