Concurrent Processing Issues with Distributed Transactions Glitch
This is my first post in Pythian blog, and I wanted to share interesting use-cases that we've dealt with recently. I believe someone may see similar cases in the future, so these are the troubleshooting steps to get to the source and apply workaround to fix it. So, the root problem was that concurrent processing doesn't start up, and Internal Manger log file reports error (same error also throwing Oracle forms trying to access Concurrent -> Administer form)
CP-GENERIC ORACLE ERROR (ERROR=ORA-01591: lock held by in-dou) (ROUTINE=get_lk_handle)
===================== PARSING IN CURSOR #139830878745608 len=66 dep=1 uid=0 oct=3 lid=0 tim=1398844275853403 hv=1493897133 ad='1c121bb90' sqlid='19x1189chq3xd' SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE END OF STMT PARSE #139830878745608:c=0,e=137,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,plh=0,tim=1398844275853402 BINDS #139830878745608: Bind#0 oacdty=01 mxl=128(128) mxlc=00 mal=00 scl=00 pre=00 oacflg=03 fl2=1206001 frm=01 csi=31 siz=128 off=0 kxsbbbfp=7f2ce9db2d80 bln=128 avl=11 flg=05 value="FNDCPLK_ICM" ... ERROR #139830878745608:err=1591 tim=1398844275855101 ... =====================
SQL> select * from DBMS_LOCK_ALLOCATED; select * from DBMS_LOCK_ALLOCATED * ERROR at line 1: ORA-01591: lock held by in-doubt distributed transaction 35.15.13775
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('35.15.13775'); BEGIN DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('35.15.13775'); END; * ERROR at line 1: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.DBMS_TRANSACTION", line 96 ORA-06512: at line 1 SQL> COMMIT FORCE '35.15.13775'; COMMIT FORCE '35.15.13775' * ERROR at line 1: ORA-02058: no prepared transaction found with ID 35.15.13775 SQL> rollback force '35.15.13775'; rollback force '35.15.13775' * ERROR at line 1: ORA-02058: no prepared transaction found with ID 35.15.13775 SQL>
SELECT KTUXEUSN, KTUXESLT, KTUXESQN, KTUXESTA Status, KTUXECFL Flags FROM x$ktuxe WHERE ktuxesta!='INACTIVE'; KTUXEUSN KTUXESLT KTUXESQN STATUS FLAGS ---------- ---------- ---------- ---------------- ------------------------ 35 15 13775 PREPARED SCO|COL|REV|DEAD
- Written back in 2005: https://www.freelists.org/post/oracle-l/lock-held-by-indoubt-distributed-transaction,4
- Newer post, written in February 2011: https://halimdba.blogspot.com/2011/02/ora-01591-lock-held-by-in-doubt.html
Share this
You May Also Like
These Related Stories
Oracle autonomous transaction processing - a good start
Lightweight transactions in Cassandra
![](https://www.pythian.com/hubfs/Imported_Blog_Media/shutterstock_1938610885-scaled.jpg)
No Comments Yet
Let us know what you think