Bug 778386 (SOA-869)

Summary: bpm_orchestration2 generates "[JDBCExceptionReporter] Concurrent update" errors on multi-cpu systems
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: nwallace <nwallace>
Component: JBPM - within SOAAssignee: Thomas Diesler <thomas.diesler>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 4.2 CR3   
Target Milestone: ---   
Target Release: 4.2 CP03   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-869
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
/opt/RC3/soa-4.2.0.CR3.zip /opt/RC3/standalone-soa-4.2.0.CR3.zip
Last Closed: 2008-10-30 12:30:26 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:
Bug Depends On:    
Bug Blocks: 777950    

Description nwallace 2008-09-26 06:04:30 UTC
Date of First Response: 2008-10-30 08:30:26
project_key: SOA

Seeing this exception (server.log attached) - in CR3 with bmp_orchestration2 - with HSQLDB.

Steps to recreate:
1) cp jboss-soa-p.4.2.0/jboss-as/tools/resources/jbpm-console-development.war jboss-soa-p.4.2.0/jboss-as/server/all/deploy/jbpm.esb/jbpm-console.war 
2) ant deploy
3) ant deployProcess
4) ant startProcess

13:20:51,135 ERROR [JDBCExceptionReporter] Concurrent update in table JBPM_TOKEN: another transaction has updated or deleted the same row [90131-66]
13:20:51,136 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [org.jbpm.graph.exe.Token#1]
        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)

Comment 1 nwallace 2008-09-26 06:04:30 UTC
Link: Added: This issue is related to SOA-410


Comment 2 nwallace 2008-09-26 06:04:30 UTC
Link: Added: This issue is a dependency of SOA-480


Comment 3 nwallace 2008-09-26 06:04:30 UTC
Link: Added: This issue related SOA-415


Comment 4 nwallace 2008-09-26 06:05:01 UTC
Link: Added: This issue is related to SOA-417


Comment 5 nwallace 2008-09-26 06:05:39 UTC
Can we have confirmation that fixes are in place for 4.2CP03.

Comment 6 Julian Coleman 2008-10-30 12:30:26 UTC
Already done.