DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Threaded View

  1. #1
    Join Date
    Mar 2006
    Charlotte, NC

    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.

    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

    Click Here to Expand Forum to Full Width

    We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.