Hi,
Our DBA has brought to our attention the following issue:
I wonder what is the "BEFORE_BOX_BODY" point, and what may be causing this or if it has any possible resolution from our (developers) side. If it is the wwv_flow_data this then, would be, the Oracle Apex engine, am I correct?
Thank you!
============================================================
*** 2021-04-26 14:46:55.040
*** SESSION ID:(2996.33432) 2021-04-26 14:46:55.040
*** CLIENT ID:(JOHN DOE:13371553952624) 2021-04-26 14:46:55.040
*** SERVICE NAME:(prod) 2021-04-26 14:46:55.040
*** MODULE NAME:(MMS/APEX:APP 200:40) 2021-04-26 14:46:55.040
*** CLIENT DRIVER:(jdbcthin : 18.3.0.0.0) 2021-04-26 14:46:55.040
*** ACTION NAME:(PAGE 40) 2021-04-26 14:46:55.040
*** 2021-04-26 14:46:55.040
DEADLOCK DETECTED ( ORA-00060 )
See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-001E0009-00205026-00000000-00000000 279 2996 X 677 308 X
TX-000E001D-0040E3C4-00000000-00000000 677 308 X 279 2996 X
session 2996: DID 0001-0117-000F1816 session 308: DID 0001-02A5-0008E350
session 308: DID 0001-02A5-0008E350 session 2996: DID 0001-0117-000F1816
Rows waited on:
Session 2996: obj - rowid = 00413F36 - AAQT82AF6AABLkGAAy
(dictionary objn - 4276022, file - 378, block - 309510, slot - 50)
Session 308: obj - rowid = 00413F36 - AAQT82AF6AABLkGAAz
(dictionary objn - 4276022, file - 378, block - 309510, slot - 51)
----- Information for the OTHER waiting sessions -----
Session 308:
sid: 308 ser: 56101 audsid: 256875724 user: 1328/APEX_180200
flags: (0x8000041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 677 O/S info: user: oracle, term: UNKNOWN, ospid: 56490
image: oracle@db0.bpb.bz
client details:
O/S info: user: tomcat, term: unknown, ospid: 1234
machine: db0.bpb.bz program: Oracle REST Data Services
client info: 9770562200791252:JOHN DOE
application name: MMS/APEX:APP 200:40, hash value=1937631860
action name: Processes - point: BEFORE_BOX_BODY, hash value=1685858885
current SQL:
UPDATE WWV_FLOW_DATA SET ITEM_VALUE_VC2 = :B5 , ITEM_VALUE_CLOB = :B4 , SESSION_STATE_STATUS = DECODE(SESSION_STATE_STATUS,'R','I','U'), IS_ENCRYPTED = :B3 WHERE FLOW
_INSTANCE = :B2 AND ITEM_ID = :B1
----- End of information for the OTHER waiting sessions -----
Information for THIS session:
----- Current SQL Statement for this session (sql_id=47s8s1zw21nff) -----
DELETE FROM WWV_FLOW_DATA WHERE FLOW_INSTANCE = :B2 AND ITEM_ID = :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x23fcf49c8 1117 package body APEX_180200.WWV_FLOW_SESSION_STATE
0x8fc2eee0 854 package body APEX_180200.WWV_FLOW_DISP_PAGE_PLUGS
0x24a6edfb8 4606 package body APEX_180200.WWV_FLOW
0x27daab3f8 173 procedure APEX_180200.F
0x1e53ca0b8 2 anonymous block
================================================================================