Loading...

Details

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 2.3.0.Final
Affects Version/s: 2.2.0.Final
Component/s: ODE
Labels:
None

Steps to Reproduce:

Hide

I have defined 2 BPEL workflow/process (described into deploy.xml file)
bpl:helloGoodbye
bplsub:helloGoodbyeSubplan
and an external web service the same of simple-invoke examples. The java class was modified inserting a sleep for testing pourpose.

The problem that I found will be reproduced:
The first time I don't have problem. When I send a new message (chenging the correlatioID field) the problem come.

I send a (startMainFlow) message to the helloGoodbye process (the message have a correlation ID) no problem
I send a (stop) message
I send a (restart) message

Show
I have defined 2 BPEL workflow/process (described into deploy.xml file) bpl:helloGoodbye bplsub:helloGoodbyeSubplan and an external web service the same of simple-invoke examples. The java class was modified inserting a sleep for testing pourpose. The problem that I found will be reproduced: The first time I don't have problem. When I send a new message (chenging the correlatioID field) the problem come. I send a (startMainFlow) message to the helloGoodbye process (the message have a correlation ID) no problem I send a (stop) message I send a (restart) message
Forum Reference:
http://community.jboss.org/message/602495#602495

Description

When I invoke my Bpel process I have the following exception:

2011-04-28 15:29:21,619 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing a persisted job: org.apache.ode.dao.jpa.scheduler.JobDAOImpl@10e874a

org.apache.ode.bpel.iapi.Scheduler$JobProcessorException

at org.apache.ode.bpel.engine.BpelEngineImpl.acquireInstanceLock(BpelEngineImpl.java:396)

at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:405)

at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:450)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:566)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:556)

at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:289)

at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:556)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2011-04-28 15:29:21,722 ERROR [org.apache.ode.scheduler.simple.SimpleScheduler] (ODEServer-5) Error while processing job, retrying in 5s

2011-04-28 15:29:21,749 WARN [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) SQL Error: 1062, SQLState: 23000

2011-04-28 15:29:21,752 ERROR [org.hibernate.util.JDBCExceptionReporter] (ODEServer-5) Duplicate entry 'hqejbhcnphr68grivn8wew' for key 1

2011-04-28 15:29:21,755 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] (ODEServer-5) Could not synchronize database state with session

org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

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 com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:101)

at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:269)

at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:89)

at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)

at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1423)

at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:137)

at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:298)

at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:246)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:601)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:541)

at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:528)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.BatchUpdateException: Duplicate entry 'hqejbhcnphr68grivn8wew' for key 1

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)

at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)

at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)

at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)

at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

... 24 more

2011-04-28 15:29:21,822 WARN [com.arjuna.ats.arjuna.logging.arjLoggerI18N] (ODEServer-5) [com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator_2] TwoPhaseCoordinator.beforeCompletion - failed for com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple@154690e

javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

at org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:513)