Oracle: lock held by in-doubt distributed transactionPermanent link for this heading

Last update: 4 August 2017

SummaryPermanent link for this heading

This article describes the error message triggered as a result of a locked resource in a pending transaction as well as the solution.

Error message:

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

InformationPermanent link for this heading

An attempt was made to access resource that is locked by a dead two-phase commit transaction that is in prepared state.

SolutionPermanent link for this heading

Warning: Please consider that the solution provided below requires a complete domain restart!

  • Stop all COO-services of the affected domain.
    Note: Before stopping the COO-services ensure that all kernel instances have been stopped.
  • Check if there are any pending transactions left on the Oracle database.

       select * from sys.dba_pending_transactions

select * from dba_2pc_pending

    

Applies toPermanent link for this heading

  • Fabasoft Folio (all versions)
  • Fabasoft eGov-suite (all versions)

while using an Oracle database

Download PDF

Download PDF