Deadlock when running Oracle database with BPMS due to unsupported Oracle8iDialect

Solution Unverified - Updated -

Issue

  • Deadlock occurred in BPMS table;
  • Deadlock when running Oracle and the following query:

    delete from BPMS.ProcessInstanceInfo where InstanceId=:1  and OPTLOCK=:2
    
  • Deadlock when using Oracle8iDialect:

    WARN  [org.jbpm.services.task.persistence.TaskTransactionInterceptor] (http-/10.10.10.10:8080-7) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.LockAcquisitionException: could not execute statement
    ...
        at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParameters(JPATaskPersistenceContext.java:475) [jbpm-human-task-core-6.0.3-redhat-6.jar:6.0.3-redhat-6]
    ...
    Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement
        at org.hibernate.dialect.Oracle8iDialect$2.convert(Oracle8iDialect.java:449) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1]
    ...
    Caused by: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
    

Environment

  • Red Hat BPM Suite (BPMS) 6.0.3
  • Oracle 12c

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In