-
ORA-01591: lock held by in-doubt distributed transaction
Hi All,
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.
update 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.
Thanks,
Last edited by vnktummala; 10-20-2009 at 08:43 AM.
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Click Here to Expand Forum to Full Width
|
|