ORA-01591: lock held by in-doubt distributed transaction
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01591: lock held by in-doubt distributed transaction

Threaded View

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    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
    •  



    Click Here to Expand Forum to Full Width