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
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
