IBM Support

JR49547: PROCESS CONTEXT DEADLOCK BETWEEN PROCESS INSTANCE DELETION AND REFRESH OF EXPIRED BPEL STARTER

Subscribe

You can track all active APARs for this component.

 

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