Deadlock when running Oracle database with BPMS due to unsupported Oracle8iDialect
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.