Database Lock Contention on BPM_MEASUREMENT_ACTION_SEQ under Load (Doc ID 1944352.1)

Last updated on NOVEMBER 14, 2014

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Under load, multiple sessions are waiting for the following database update: "UPDATE BPM_MEASUREMENT_ACTION_SEQ SET SEQ_COUNT = SEQ_COUNT + :1 WHERE SEQ_NAME = :2" 

The following Exceptions are appearing in the BPM server log:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock
Error Code: 2049
Call: UPDATE BPM_MEASUREMENT_ACTION_SEQ SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
  bind => [2 parameters bound]
Query: DataModifyQuery(name="ACTION_SEQ" sql="UPDATE BPM_MEASUREMENT_ACTION_SEQ SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")
  at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
....
Caused by: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms