<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
        <table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                <tbody>
                        <tr>
                                <td>
                                        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
                                                <tbody>
                                                        <tr>
                                                                <td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
                                                                        <h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
                                                                        <!-- To have a header image/logo replace the name below with your img tag -->
                                                                        <!-- Email clients will render the images when the message is read so any image -->
                                                                        <!-- must be made available on a public server, so that all recipients can load the image. -->
                                                                        <a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
                                                                </td>
                                                        </tr>
                                                        <tr>
                                                                <td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
StaleObjectStateException
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/grisha78">gregory picavet</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/556341#556341">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi There,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>my logs contain a lot of StaleObjectStateException thrown by the JobExecutor (see below for details). It appears that the jobs are executed at the end, but i can't explain that exceptions</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>i've found this issue : <a class="jive-link-external-small" href="https://jira.jboss.org/browse/JBPM-1953">https://jira.jboss.org/browse/JBPM-1953</a>, but i'm running with a single threaded JobExecutor, and only one node is running in my jboss cluster</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>versions used :</p><p><p>jbpm 3.2.6SP1</p><p>jboss 4.2.3GA</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thank you for your help</p></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div id="_mcePaste">2010-08-04 12:11:36,776 DEBUG [org.hibernate.jdbc.ConnectionManager] JMS SessionPool Worker-1 opening JDBC connection</div><div id="_mcePaste">2010-08-04 12:11:36,776 DEBUG [org.hibernate.SQL] JMS SessionPool Worker-1</div><div id="_mcePaste">    /* update</div><div id="_mcePaste">        org.jbpm.graph.exe.Token */ update</div><div id="_mcePaste">            JBPM_TOKEN</div><div id="_mcePaste">        set</div><div id="_mcePaste">            VERSION_=?,</div><div id="_mcePaste">            NAME_=?,</div><div id="_mcePaste">            START_=?,</div><div id="_mcePaste">            END_=?,</div><div id="_mcePaste">            NODEENTER_=?,</div><div id="_mcePaste">            NEXTLOGINDEX_=?,</div><div id="_mcePaste">            ISABLETOREACTIVATEPARENT_=?,</div><div id="_mcePaste">            ISTERMINATIONIMPLICIT_=?,</div><div id="_mcePaste">            ISSUSPENDED_=?,</div><div id="_mcePaste">            LOCK_=?,</div><div id="_mcePaste">            NODE_=?,</div><div id="_mcePaste">            PROCESSINSTANCE_=?,</div><div id="_mcePaste">            PARENT_=?,</div><div id="_mcePaste">            SUBPROCESSINSTANCE_=?</div><div id="_mcePaste">        where</div><div id="_mcePaste">            ID_=?</div><div id="_mcePaste">            and VERSION_=?</div><div id="_mcePaste">2010-08-04 12:11:36,778 DEBUG [org.hibernate.jdbc.AbstractBatcher] JMS SessionPool Worker-1 about to close PreparedStatement (open PreparedStatements: 1, globally: 1)</div><div id="_mcePaste">2010-08-04 12:11:36,778 DEBUG [org.hibernate.jdbc.ConnectionManager] JMS SessionPool Worker-1 skipping aggressive-release due to flush cycle</div><div id="_mcePaste">2010-08-04 12:11:36,778 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] JMS SessionPool Worker-1 Could not synchronize database state with session</div><div id="_mcePaste">org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.graph.exe.Token#236]</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1765)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2407)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)</div><div id="_mcePaste">at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)</div><div id="_mcePaste">at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</div><div id="_mcePaste">at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)</div><div id="_mcePaste">at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)</div><div id="_mcePaste">at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)</div><div id="_mcePaste">at org.jboss.mq.SpySession.run(SpySession.java:323)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)</div><div id="_mcePaste">at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756)</div><div id="_mcePaste">at java.lang.Thread.run(Thread.java:595)</div><div id="_mcePaste">2010-08-04 12:11:36,781 DEBUG [org.hibernate.jdbc.ConnectionManager] JMS SessionPool Worker-1 aggressively releasing JDBC connection</div><div id="_mcePaste">2010-08-04 12:11:36,781 DEBUG [org.hibernate.jdbc.ConnectionManager] JMS SessionPool Worker-1 releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]</div><div id="_mcePaste">2010-08-04 12:11:36,781 WARN  [com.arjuna.ats.arjuna.logging.arjLoggerI18N] JMS SessionPool Worker-1 [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@da7e5d</div><div id="_mcePaste">org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.graph.exe.Token#236]</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1765)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2407)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)</div><div id="_mcePaste">at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)</div><div id="_mcePaste">at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</div><div id="_mcePaste">at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)</div><div id="_mcePaste">at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)</div><div id="_mcePaste">at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)</div><div id="_mcePaste">at org.jboss.mq.SpySession.run(SpySession.java:323)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)</div><div id="_mcePaste">at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756)</div><div id="_mcePaste">at java.lang.Thread.run(Thread.java:595)</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.ejb.impl.JobListenerBean] JMS SessionPool Worker-0 getting job id from jms message...</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.ejb.impl.JobListenerBean] JMS SessionPool Worker-0 retrieved jobId '1765' via jms message</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.configuration.JbpmContextInfo] JMS SessionPool Worker-0 creating jbpm context with service factories '[tx, message, scheduler, logging, persistence, authentication]'</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.JbpmContext] JMS SessionPool Worker-0 creating org.jbpm.JbpmContext@1c55cdc</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.ejb.impl.CommandServiceBean] JMS SessionPool Worker-0 executing org.jbpm.ejb.impl.ExecuteJobCommand@5380d6</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.jbpm.persistence.db.DbPersistenceService] JMS SessionPool Worker-0 using current hibernate session</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.jdbc.JDBCContext] JMS SessionPool Worker-0 successfully registered Synchronization</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.impl.SessionImpl] JMS SessionPool Worker-0 opened session at timestamp: 5246634790027264</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.impl.SessionImpl] JMS SessionPool Worker-0 initializing proxy: [org.jbpm.job.Job#1765]</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.loader.Loader] JMS SessionPool Worker-0 loading entity: [org.jbpm.job.Job#1765]</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.jdbc.AbstractBatcher] JMS SessionPool Worker-0 about to open PreparedStatement (open PreparedStatements: 0, globally: 0)</div><div id="_mcePaste">2010-08-04 12:11:36,784 DEBUG [org.hibernate.jdbc.ConnectionManager] JMS SessionPool Worker-0 opening JDBC connection</div><div id="_mcePaste">2010-08-04 12:11:36,785 DEBUG [org.hibernate.SQL] JMS SessionPool Worker-0</div><div id="_mcePaste">    /* load org.jbpm.job.Job */ select</div><div id="_mcePaste">        job0_.ID_ as ID1_26_0_,</div><div id="_mcePaste">        job0_.VERSION_ as VERSION3_26_0_,</div><div id="_mcePaste">        job0_.DUEDATE_ as DUEDATE4_26_0_,</div><div id="_mcePaste">        job0_.PROCESSINSTANCE_ as PROCESSI5_26_0_,</div><div id="_mcePaste">        job0_.TOKEN_ as TOKEN6_26_0_,</div><div id="_mcePaste">        job0_.TASKINSTANCE_ as TASKINST7_26_0_,</div><div id="_mcePaste">        job0_.ISSUSPENDED_ as ISSUSPEN8_26_0_,</div><div id="_mcePaste">        job0_.ISEXCLUSIVE_ as ISEXCLUS9_26_0_,</div><div id="_mcePaste">        job0_.LOCKOWNER_ as LOCKOWNER10_26_0_,</div><div id="_mcePaste">        job0_.LOCKTIME_ as LOCKTIME11_26_0_,</div><div id="_mcePaste">        job0_.EXCEPTION_ as EXCEPTION12_26_0_,</div><div id="_mcePaste">        job0_.RETRIES_ as RETRIES13_26_0_,</div><div id="_mcePaste">        job0_.NAME_ as NAME14_26_0_,</div><div id="_mcePaste">        job0_.REPEAT_ as REPEAT15_26_0_,</div><div id="_mcePaste">        job0_.TRANSITIONNAME_ as TRANSIT16_26_0_,</div><div id="_mcePaste">        job0_.ACTION_ as ACTION17_26_0_,</div><div id="_mcePaste">        job0_.GRAPHELEMENTTYPE_ as GRAPHEL18_26_0_,</div><div id="_mcePaste">        job0_.GRAPHELEMENT_ as GRAPHEL19_26_0_,</div><div id="_mcePaste">        job0_.NODE_ as NODE20_26_0_,</div><div id="_mcePaste">        job0_.CLASS_ as CLASS2_26_0_</div><div id="_mcePaste">    from</div><div id="_mcePaste">        JBPM_JOB job0_</div><div id="_mcePaste">    where</div><div id="_mcePaste">        job0_.ID_=?</div><div id="_mcePaste">2010-08-04 12:11:36,786 ERROR [org.jboss.jms.asf.StdServerSession] JMS SessionPool Worker-1 failed to commit/rollback</div><div id="_mcePaste">javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1401)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)</div><div id="_mcePaste">at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:351)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)</div><div id="_mcePaste">at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)</div><div id="_mcePaste">at org.jboss.mq.SpySession.run(SpySession.java:323)</div><div id="_mcePaste">at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)</div><div id="_mcePaste">at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756)</div><div id="_mcePaste">at java.lang.Thread.run(Thread.java:595)</div><div id="_mcePaste">Caused by: org.hibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [org.jbpm.graph.exe.Token#236]</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.check(AbstractEntityPersister.java:1765)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2407)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)</div><div id="_mcePaste">at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)</div><div id="_mcePaste">at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)</div><div id="_mcePaste">at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)</div><div id="_mcePaste">at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</div><div id="_mcePaste">at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</div><div id="_mcePaste">at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)</div><div id="_mcePaste">at org.hibernate.transaction.CacheSynchronization.beforeCompletion(CacheSynchronization.java:59)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)</div><div id="_mcePaste">at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)</div><div id="_mcePaste">at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)</div><div id="_mcePaste">... 9 more</div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/556341#556341">going to Community</a></p>
        <p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>