| about error ORA-01591 [message #232429] |
Fri, 20 April 2007 08:19  |
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
|
Member |
|
|
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
thanks
ram...
|
|
|
|
| Re: about error ORA-01591 [message #232431 is a reply to message #232429] |
Fri, 20 April 2007 08:34  |
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
|
Senior Member |
|
|
| Quote: | 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.
|
| Quote: | 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
