[jBPM] - jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
10:19 a.m.
cheney-dut [http://community.jboss.org/people/cheney-dut] created the discussion
"jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value
mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/611023#611023
--------------------------------------------------------------
Today, i write a demo. i get the following exception when runing.
Anyone can help?
Thanks!
| 17895 2011-06-20 22:49:50,151[main] ERROR
event.def.AbstractFlushingEventListener.performExecutions - Could not synchronize database
state with session
org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction
(or unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
at
org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2435)
at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:397)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:147)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:95)
at
com.sinosig.claim.bpm.factory.ProcessInstanceTest.testNext(ProcessInstanceTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:76)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
17902 2011-06-20 22:49:50,158[main] WARN
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent -
Synchronization.beforeCompletion() call failed for
org.hibernate.ejb.AbstractEntityManagerImpl$1@1611aec, marking transaction as rollback
only
javax.persistence.OptimisticLockException: org.hibernate.StaleObjectStateException: Row
was updated or deleted by another transaction (or unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
at
org.hibernate.ejb.AbstractEntityManagerImpl.wrapStaleStateException(AbstractEntityManagerImpl.java:630)
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:588)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)
at
bitronix.tm.BitronixTransaction.fireBeforeCompletionEvent(BitronixTransaction.java:397)
at bitronix.tm.BitronixTransaction.commit(BitronixTransaction.java:147)
at bitronix.tm.BitronixTransactionManager.commit(BitronixTransactionManager.java:95)
at
com.sinosig.claim.bpm.factory.ProcessInstanceTest.testNext(ProcessInstanceTest.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at org.springframework.test.ConditionalTestCase.runBare(ConditionalTestCase.java:76)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another
transaction (or unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
at
org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1792)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2435)
at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2335)
at
org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2635)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:115)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at
org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:504)
... 21 more |
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/611023#611023]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4:50 a.m.
New subject: [jBPM] - Re: jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
Daniel Ch [http://community.jboss.org/people/danielch] created the discussion
"Re: jbpm5 Exception:Row was updated or deleted by another transaction (or
unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/613878#613878
--------------------------------------------------------------
Hi,
I am facing the same problem and I want to provide more information.
My JBPM datasource:
<datasources>
<xa-datasource>
<jndi-name>JbpmDS</jndi-name>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property
name="URL">jdbc:oracle:thin:@HOST:1521:SCHEMA</xa-datasource-property>
<xa-datasource-property
name="User">USER</xa-datasource-property>
<xa-datasource-property
name="Password">PASSWORD</xa-datasource-property>
<min-pool-size>1</min-pool-size>
<max-pool-size>5</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<prepared-statement-cache-size>32</prepared-statement-cache-size>
<metadata>
<type-mapping>Hypersonic SQL</type-mapping>
</metadata>
</xa-datasource>
Persistence.xml:
<persistence>
<persistence-unit name="org.jbpm.persistence.jpa"
transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>java:JbpmDS</jta-data-source>
<class>org.drools.persistence.info.SessionInfo</class>
<class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.info.WorkItemInfo</class>
<class>org.jbpm.process.audit.ProcessInstanceLog</class>
<class>org.jbpm.process.audit.NodeInstanceLog</class>
<class>org.jbpm.process.audit.VariableInstanceLog</class>
<properties>
<property name="hibernate.max_fetch_depth"
value="3"/>
<property name="hibernate.show_sql" value="true"/>
</properties>
</persistence-unit>
</persistence>
JBPM init process:
@PersistenceUnit(name = "org.jbpm.persistence.jpa")
private EntityManagerFactory emf;
...
KnowledgeBuilder kbuilder = KnowledgeBuilderFactory.newKnowledgeBuilder();
org.drools.io.Resource resource =
ResourceFactory.newClassPathResource("Test.bpmn");
env = KnowledgeBaseFactory.newEnvironment();
kbuilder.add(resource, ResourceType.BPMN2);
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);
kbase = kbuilder.newKnowledgeBase();
session = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null,
env);
JPAWorkingMemoryDbLogger logger = new JPAWorkingMemoryDbLogger(session);
session.getWorkItemManager().registerWorkItemHandler("EjbCall", new
EjbWorkItemHandler());
I want to use that single StatefulKnowledgeSession within my application (session should
be threadsafe).
ProcessInstance instance = session.startProcess("Test.bpmn", input);
Thats working for one single client request. However, by starting multiple request to that
single Session I will get the described error and I guess it is a threading issue.
Any suggestions or remarks?
Cheers
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/613878#613878]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
7:05 a.m.
New subject: [jBPM] - Re: jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
James Williams [http://community.jboss.org/people/williajd] created the discussion
"Re: jbpm5 Exception:Row was updated or deleted by another transaction (or
unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/613908#613908
--------------------------------------------------------------
Hi,
I had a similar problem and solved it by changing the data source implementation.
I found that my tests passed if I ran them against a MySQL database but failed against
hsqldb. After some experimentation I found that the problem was the data source I was
using. I switched to org.apache.commons.dbcp.BasicDataSource and it now works.
I hope this helps!
Cheers
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/613908#613908]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
9:36 a.m.
New subject: [jBPM] - Re: jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
Daniel Ch [http://community.jboss.org/people/danielch] created the discussion
"Re: jbpm5 Exception:Row was updated or deleted by another transaction (or
unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/613950#613950
--------------------------------------------------------------
Hey,
after some inspection of jbpm source code I thinks that jbpm takes usage of optimistic
locking. In my case a collision is detected and it is not handled in code :-(. Could
someone confirm my thoughts?
Thank you!
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/613950#613950]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
3:16 p.m.
New subject: [jBPM] - Re: jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
Daniel Ch [http://community.jboss.org/people/danielch] created the discussion
"Re: jbpm5 Exception:Row was updated or deleted by another transaction (or
unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/632625#632625
--------------------------------------------------------------
Hey guys,
unfortunately I skipped JBPM integration and started with Activiti. I agree with you
Mauricio that a retry mechanism will definitely help us to solve the problem. On the other
hand it should be a normal use case to start multiple process instances from one process
definition (database "logging" enabled) in a concurrency way.
Cheers
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/632625#632625]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
6:47 a.m.
New subject: [jBPM] - Re: jbpm5 Exception:Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]
Aliaksei Kushunin [http://community.jboss.org/people/a.kushunin] created the discussion
"Re: jbpm5 Exception:Row was updated or deleted by another transaction (or
unsaved-value mapping was incorrect):
[org.jbpm.persistence.processinstance.ProcessInstanceInfo#2]"
To view the discussion, visit: http://community.jboss.org/message/633270#633270
--------------------------------------------------------------
Hi Guys. I found problem in my case. I traced queries to DB and loked closely to server
logs and found out than exception was thrown during process finish, when process engine
tryies to remove record from ProcessInstanceInfo table.
The problem exist because query looks like: delete from ProcessInstanceInfo where
InstanceId=107 and OPTLOCK=1.(OPTLOCK is version column) As you can understand during
process flow version has changes several times and if you try to delele record with lower
version you get this error.
But If I start process, restart my app. server and than finish process no exception
occurs and ProcessInstanceInfo deleted correctly.
So I have question to comunity, does process engine use cache for ProcessInstances and how
can I drop this cach or turn iy off?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/633270#633270]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4579
days inactive
4705
days old
5 comments
4 participants
participants (4)
-
Aliaksei Kushunin -
cheney-dut
-
Daniel Ch
-
James Williams