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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content