Home » RDBMS Server » Server Administration » about error ORA-01591
about error ORA-01591 [message #232429] Fri, 20 April 2007 08:19 Go to next message
Messages: 32
Registered: March 2007
Location: vishakapatnam
hai all
when our developers firing a trigger an error comes out like this

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

let me know immly how to solve this problem

Re: about error ORA-01591 [message #232431 is a reply to message #232429] Fri, 20 April 2007 08:34 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Locks From In-Doubt Transactions

A query or DML statement that requires locks on a local database can be blocked indefinitely due to the locked resources of an in-doubt distributed transaction. In this case, Oracle issues the following error message:

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

In this case, Oracle rolls back the SQL statement immediately. The user who executed the statement can try to re-execute the statement later. If the lock persists, the user should contact an administrator to report the problem, including the ID of the in-doubt distributed transaction.

The chances of the above situations occurring are rare considering the low probability of failures during the critical portions of the two-phase commit. Even if such a failure occurs, and assuming quick recovery from a network or system failure, problems are automatically resolved without manual intervention. Thus, problems usually resolve before they can be detected by users or database administrators.

Action: DBA should query the pending_trans$ and related tables, and attempt to repair network connection(s) to coordinator and commit point. If timely repair is not possible, DBA should contact DBA at commit point if known or end user for correct outcome, or use heuristic default if given to issue a heuristic commit or abort command to finalize the local portion of the distributed transaction.

[Updated on: Fri, 20 April 2007 08:35]

Report message to a moderator

Previous Topic: how to create an user
Next Topic: weird redo log behaviour?
Goto Forum:

Current Time: Tue Oct 25 16:43:27 CDT 2016

Total time taken to generate the page: 0.07604 seconds