Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1179269

Summary: 118 OptimisticLockExceptions in jbpm-bpmn2 module using Oracle 11gR2 and 12c databases
Product: [Retired] JBoss BPMS Platform 6 Reporter: Jiri Svitak <jsvitak>
Component: jBPM CoreAssignee: Alessandro Lazarotti <alazarot>
Status: CLOSED EOL QA Contact: Marek Baluch <mbaluch>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.1.0CC: ksuta, kverlaen, mbaluch
Target Milestone: ER5   
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2020-03-27 20:00:10 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On: 1049238    
Bug Blocks:    
Attachments:
Description Flags
stacktrace-from-jenkins-one-of-the-tests.log
none
Pessimistic locking error stacktrace none

Description Jiri Svitak 2015-01-06 14:12:22 UTC 
Created attachment 976818 [details]
stacktrace-from-jenkins-one-of-the-tests.log

Description of problem:
113 OptimisticLockExceptions in jbpm-bpmn2 module using Oracle 11gR2 and 12c databases. The failed tests include:
org.jbpm.bpmn2.IntermediateEventTest.*
org.jbpm.bpmn2.StandaloneBPMNProcessTest.*
The typical stack trace is attached.

This can be related to a problem with indexes, however bugzilla BZ1049238 requesting additional DDLs, which would prepare databases for production use, have unfortunately not been fixed yet.

Version-Release number of selected component (if applicable):
BPM Suite 6.1.0.ER3


Steps to Reproduce:
You can use QE single job https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/BxMS/view/BxMS-6.1/view/jBPM/view/all/job/bpms-6.1-jbpm-community-db-single/

Actual results:
118 OptimisticLockExceptions in jbpm-bpmn2 module using Oracle 11gR2 and 12c databases

Expected results:
All community db unit tests pass on all supported databases.

Additional info:
Oracle 11gR2
Oracle 12c
Comment 1 Maciej Swiderski 2015-01-12 10:47:57 UTC 
failing tests where when pessimistic lock was used and was caused by lack of entity manager flush after resist but before lock was acquired. 

jbpm
master:
https://github.com/droolsjbpm/jbpm/commit/b632d5c702ffd196d715f1c83d796e3e38425229

6.2.x:
https://github.com/droolsjbpm/jbpm/commit/780382ddfdbf4b243c18276937e5173b11e0c171

drools
master:
https://github.com/droolsjbpm/drools/commit/3362adee721d84e96e464e863aa620da1d3f172e

6.2.x:
https://github.com/droolsjbpm/drools/commit/5b28f61d7855067798664d9ee9c947eb3891c3c8
Comment 2 Karel Suta 2015-01-28 09:16:00 UTC 
Created attachment 985044 [details]
Pessimistic locking error stacktrace
Comment 3 Karel Suta 2015-01-28 09:18:06 UTC 
Similar issue found for Postgresql DB and for persisting SessionInfo. See attachment. Should have same cause.
Comment 4 Jiri Svitak 2015-02-20 16:32:42 UTC 
In jbpm-bpmn2 module there is now 98 failures less for Oracle11gR2 and 113 less for Oracle12c. Other failures are due to different problems.

Verified in BPM Suite 6.1.0.ER5.