Fixes are available
APAR status
Closed as program error.
Error description
Process context deadlock between process instance deletion and refresh of expired BPEL starter. . The code executes a number of delete statements on process/task-related tables, among them PROCESS_CONTEXT_T, which is a central table for BPEL transaction processing. On this table a deadlock occurs, and is detected by the DBMS, [2014/02/24 15:54:15:257] 7B70C0 WAS.clientinfopluslogging.prepareStatement X nullEntry; com.ibm.ws.rsadapter.jdbc.WSJccSQLJPDQConnection@a154c7d1, DELETE FROM PMWBCL.PROCESS_CONTEXT_T WHERE (PIID = ?) , TYPE FORWARD ONLY (1003), CONCUR READ ONLY (1007) [2014/02/24 15:54:15:257] 7B70C0 WAS.clientinfopluslogging.prepareStatement X null Exit; com.ibm.ws.rsadapter.jdbc.WSJccPreparedStatement@2604e2a2 [2014/02/24 15:54:15:257] 7B70C0 com.ibm.bpe.util.TraceBPE. .com.ibm.bpe.database.DbAccProcessContext.deleteDbByPIID(DbAccPr ocessContext.java:923) X nullset 1 = _PI:90030144.63fb2646.bb0ffef5.73317cb5 [2014/02/24 15:54:38:211] 7B70C0 com.ibm.bpe.util.TraceBPE. .com.ibm.bpe.database.TomPreparedStatement.executeUpdate(TomPrep aredStatement.java:230) X null [jcc][50053][12311][3.62.73] T2zOS exception: [jcc][T2zos] T2zosPreparedStatement.readExecuteInternal:nativeExecute:9972: DB2 engine SQL error, SQLCODE = -913, SQLSTATE = 57033, error tokens = 00C90088;00000304;WASBDB0A.INSTA24 .X'000049' '.X'14' ERRORCODE=-913, SQLSTATE=57033 com.ibm.db2.jcc.am.SqlException:[jcc][50053][12311][3.62.7.3] T2zOS exception: [jcc][T2zos] T2zosPreparedStatement.readExecuteInternal:nativeExecute:9972: DB2 engine SQL error, SQLCODE = -913, SQLSTATE = 57033, error tokens = 00C90088 ;00000304;WASBDB0A.INSTA24 .X'000049' '.X'14' ERRORCODE=-913, SQLSTATE=57033
Local fix
n/a
Problem summary
The deadlock arises between a thread that attempts to delete a process instance upon completion, and a thread that attempts to refresh the starter token in the context of the same process instance. The deletion transaction starts with deleting process instance data from various tables and eventually comes to the PROCESS_CONTEXT_T table, where it hangs. The other thread has in the meantime started a refresh action (triggered by a "BPELStarterExpiredEngineMessage"), which has initially acquired a lock on PROCESS_CONTEXT_T and needs to access further DB information in order to complete. The database detects this as a deadlock and rolls back the delete operation (which completes normally in a subsequent retry).
Problem conclusion
This APAR changes the processing of the "delete upon completion" operation in a way that it aquires an exclusive lock on PROCESS_CONTEXT_T right at the beginning of the transaction. FIX AVAILABILITY: iFix for 8.0.1.2 is/will be available on Fix Central; search for APAR JR49547 at http://www.ibm.com/support/fixcentral/ Fix is also targetted for inclusion in next fixpack for BPM V8.0.1 When obtaining any of the above fixes, be sure to download the accompanying readme, for itself, and any prerequisite fixes, and review them thoroughly.
Temporary fix
Comments
APAR Information
APAR number
JR49547
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-03-06
Closed date
2014-05-07
Last modified date
2015-04-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R801 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021