[jboss-user] [jBPM] New message: "jbpm 4.3 - org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update"

[Martin Porter]

User development,

A new message was posted in the thread "jbpm 4.3 - org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update":

http://community.jboss.org/message/521504#521504

Author  : Martin Porter
Profile : http://community.jboss.org/people/jedizippy

Message:
--------------------------------------------------------------
 
We have a subprocess that essentially is composed to two activities. The first calls a <custom> java class which in turn moves to the second <custom> activity which performs a wait until a signal is recieved. The main process is composed of a number of steps that basically call this subprocess with continue="async". We also have a version of this subprocess that just does the calls the custom java class amd another one that only does the custom wait state.
 
We are now running into an issue with a contraint violation which is the primary key of the JBPM4_EXECUTION table. This seems to happen at varying points throughout the workflow. Somtimes just after the main process is persisted (upon calling the first sub-process invocation).
 
Sometimes it is in one of the sub processes after they have executed the the wait (so is presumably persisted to the database).
 
In fact it seems completely random. Has anyone ran into this ? It seems (cannot be sure) that this could have been caused by removing continue="async" from some of the steps in the subprocesses however we cannot be sure !.
 
It seems strange to be getting unique key constraint violations on the execution table !?
 
We are using the JobExecutor with the default configuration (we have not changed it just imported it).
 
17:06:16.106 | DEBUG | pool-1-thread-2 | d.o.s.p.c.BusinessServiceResponseHandler | Order Id [Ord2717322722] Waiting For
Response - Start Time [1264089976104]
17:06:16.110 | DEBUG | pool-1-thread-2 | d.o.s.p.c.BusinessServiceResponseHandler | Order Id [Ord2717322722] Wait Execut
ed !
17:06:16.245 | WARN | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | SQL Error: 1, SQLState: 23000
17:06:16.245 | WARN | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | SQL Error: 1, SQLState: 23000
17:06:16.249 | ERROR | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | ORA-00001: Unique Constraint (WIEDMANNJ_DEV.SYS_C
0017598) verletzt
17:06:16.249 | ERROR | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | ORA-00001: Unique Constraint (WIEDMANNJ_DEV.SYS_C
0017598) verletzt
17:06:16.261 | WARN | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | SQL Error: 1, SQLState: 23000
17:06:16.261 | WARN | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | SQL Error: 1, SQLState: 23000
17:06:16.268 | ERROR | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | ORA-00001: Unique Constraint (WIEDMANNJ_DEV.SYS_C
0017598) verletzt
17:06:16.268 | ERROR | pool-1-thread-2 | o.h.u.JDBCExceptionReporter | ORA-00001: Unique Constraint (WIEDMANNJ_DEV.SYS_C
0017598) verletzt
17:06:16.327 | ERROR | pool-1-thread-2 | o.h.e.d.AbstractFlushingEventListener | Could not synchronize database state wi
th session
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) [hibernate-core-3.3.1.GA.jar:3.3
.1.GA]
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [hibernate-core-3.3.1.GA.jar
:3.3.1.GA]
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [hibernate-core-3.3.1.GA.jar:3.3.1.
GA]
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) [hibernate-core-3.3.1.GA.jar:3.
3.1.GA]
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) [hibernate-core-3.3.1.GA.jar:3.
3.1.GA]
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244) [hibernate-core-3.3.1.GA.j
ar:3.3.1.GA]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252) [hibernate-c
ore-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688) [hibernate-c
ore-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) [hibernate-core-3.3.1.GA.jar:3.3.
1.GA]
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:32
1) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) [hibernate-core-
3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:56) [jbpm-pvm-4.3-pat
ched.jar:na]
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:107) [jbpm-pvm-4.3-patched.jar:n
a]
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:64) [jbpm-pvm-4.3-patched.jar:
na]
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61) [jbpm
-pvm-4.3-patched.jar:na]
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) [jbp
m-pvm-4.3-patched.jar:na]
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) [jbpm-pvm-4.3-patche
d.jar:na]
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55) [jbpm-pvm-4.3-patched.jar:na]
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43) [jbpm-pvm-4.3-patched.jar:na]
at org.jbpm.pvm.internal.jobexecutor.JobParcel.run(JobParcel.java:48) [jbpm-pvm-4.3-patched.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_11]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [na:1.6.0_11]
at java.util.concurrent.FutureTask.run(FutureTask.java:138) [na:1.6.0_11]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_11]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_11]
at java.lang.Thread.run(Thread.java:619) [na:1.6.0_11]

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/521504#521504