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
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
Created attachment 985044 [details] Pessimistic locking error stacktrace
Similar issue found for Postgresql DB and for persisting SessionInfo. See attachment. Should have same cause.
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.