[JBoss JIRA] Created: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
4:23 p.m.
integrity constraint violation in process that runs end to end with no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:25 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick updated JBPM-2387:
------------------------------------
Attachment: jbpm-issue.zip
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:58 p.m.
New subject: [JBoss JIRA] Updated: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick updated JBPM-2387:
------------------------------------
Attachment: end2end.jpdl.xml
I have removed all custom nodes (ignore previous comment about possible workaround) and
got the process down to a fork with a decision in each branch going into a join. Very
simple process but errors when you execute it. Hope this is helpful.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick commented on JBPM-2387:
-----------------------------------------
Should have said see the attached XML.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:27 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Ronald van Kuijk commented on JBPM-2387:
----------------------------------------
Would you please search the jira first and check whether this is a duplicate of another
issue on this same problem.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:33 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick commented on JBPM-2387:
-----------------------------------------
I did do a few JIRA searches and cannot find it in the open issues or fixed issues for
4.0CR1, but I may have missed something. If I did, my apologies.
I have just replaced the two decisions in attached jpdl file with custom nodes which
simply take the default transition - and it works! That is, the process completes without
errors and is flagged as isEnded.
Is their any fundamental difference between a decision node and a custom node - ie. is it
a viable workaround for me to replace all my decisions with custom nodes which take the
appropriate transition in the execute() method rather than wait to be signalled?
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:25 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2387:
-----------------------------------
there was a problem with ending executions. i think it should be fixed. i'll add
your process to the test suite and check if it works.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:12 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Ronald van Kuijk commented on JBPM-2387:
----------------------------------------
Bug JBPM-2303 Exception with a process containing a fork/join Joram Barrez
Major Resolved Resolved Done 03/Jun/09 25/Jun/09
Bug JBPM-2333 Failed to end ProcessInstance due to foreign key constraint Unassigned
Major Resolved Resolved Done 13/Jun/09 19/Jun/09
Bug JBPM-2335 Subprocess Element causes Exception if followed by an <end> Element
Joram Barrez Major Resolved Resolved Done 16/Jun/09 29/Jun/09
Bug JBPM-2382 Constraint Violations on MySQL on heavy load Unassigned Major Closed
Closed Duplicate Issue 02/Jul/09 02/Jul/09
Bug JBPM-2387 integrity constraint violation in process that runs end to end with no
wait Unassigned Major Open Open UNRESOLVED 03/Jul/09 05/Jul/09
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:39 a.m.
New subject: [JBoss JIRA] Updated: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens updated JBPM-2387:
------------------------------
Fix Version/s: jBPM 4.0
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Fix For: jBPM 4.0
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:39 a.m.
New subject: [JBoss JIRA] Assigned: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens reassigned JBPM-2387:
---------------------------------
Assignee: Tom Baeyens
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Fix For: jBPM 4.0
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:43 a.m.
New subject: [JBoss JIRA] Resolved: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens resolved JBPM-2387.
-------------------------------
Fix Version/s: (was: jBPM 4.0)
Resolution: Duplicate Issue
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick commented on JBPM-2387:
-----------------------------------------
I am trying to reproduce this issue against the trunk and am seeing the following error:
java.lang.ClassNotFoundException: org.jbpm.jpdl.internal.model.JpdlExecution (from
Hibernate). It seems this class/entity no longer exists.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:42 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2387:
-----------------------------------
correctly. use ExecutionImpl instead
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:29 a.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick commented on JBPM-2387:
-----------------------------------------
Feel free to ignore if this is not relevant to tracking/fixing this issue, but am simply
trying to run the attached test case against the trunk which I have built and installed
locally - and I am getting the ClassNotFoundException.
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:44 p.m.
New subject: [JBoss JIRA] Reopened: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens reopened JBPM-2387:
-------------------------------
this needs to be double checked
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:44 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens commented on JBPM-2387:
-----------------------------------
... in the distro
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:30 p.m.
New subject: [JBoss JIRA] Commented: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Alfie Kirkpatrick commented on JBPM-2387:
-----------------------------------------
I added a test to the ConcurrentEndTest in trunk and it passed fine. Patch below in case
it's useful.
The error about ClassNotFoundException was caused because I still had <mapping
resource="jbpm.jpdl.hbm.xml" /> from CR1 in my jbpm.hibernate.cfg.xml.
Perhaps this could be encapsulated a little more to shield from hbm/schema changes.
Index: modules/test-db/src/test/java/org/jbpm/test/execution/ConcurrentEndTest.java
===================================================================
--- modules/test-db/src/test/java/org/jbpm/test/execution/ConcurrentEndTest.java (revision
5251)
+++ modules/test-db/src/test/java/org/jbpm/test/execution/ConcurrentEndTest.java (working
copy)
@@ -21,8 +21,12 @@
*/
package org.jbpm.test.execution;
+import java.util.Map;
+
import org.jbpm.api.Execution;
import org.jbpm.api.ProcessInstance;
+import org.jbpm.api.activity.ActivityExecution;
+import org.jbpm.api.activity.ExternalActivityBehaviour;
import org.jbpm.test.JbpmTestCase;
@@ -68,4 +72,31 @@
ProcessInstance processInstance =
executionService.startProcessInstanceByKey("ConcurrentEnd");
assertEquals(Execution.STATE_ENDED, processInstance.getState());
}
+
+ public void testConcurrentEndScenario3() {
+ deployJpdlXmlString(
+ "<process name='ConcurrentEnd'>" +
+ " <start>" +
+ " <transition to='f' />" +
+ " </start>" +
+ " <fork name='f'>" +
+ " <transition to='a' />" +
+ " <transition to='b' />" +
+ " </fork>" +
+ " <custom name='a'
class='org.jbpm.test.activities.PassThroughActivity'>" +
+ " <transition to='join' />" +
+ " </custom>" +
+ " <custom name='b'
class='org.jbpm.test.activities.PassThroughActivity'>" +
+ " <transition to='join' />" +
+ " </custom>" +
+ " <join name='join'>" +
+ " <transition to='end' />" +
+ " </join>" +
+ " <end name='end' />" +
+ "</process>"
+ );
+
+ ProcessInstance processInstance =
executionService.startProcessInstanceByKey("ConcurrentEnd");
+ assertEquals(Execution.STATE_ENDED, processInstance.getState());
+ }
}
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:58 a.m.
New subject: [JBoss JIRA] Resolved: (JBPM-2387) integrity constraint violation in process that runs end to end with no wait
[
https://jira.jboss.org/jira/browse/JBPM-2387?page=com.atlassian.jira.plug...
]
Tom Baeyens resolved JBPM-2387.
-------------------------------
Fix Version/s: jBPM 4.0
Resolution: Done
i also verified the jbpm.jpdl.hbm.xml was not found in any of the source files.
good test, thanks. i don't believe we had one like that already :-) it's added.
good work overall. congrats and keep it up!
integrity constraint violation in process that runs end to end with
no wait
---------------------------------------------------------------------------
Key: JBPM-2387
URL: https://jira.jboss.org/jira/browse/JBPM-2387
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Runtime Engine
Affects Versions: jBPM 4.0.CR1
Reporter: Alfie Kirkpatrick
Assignee: Tom Baeyens
Fix For: jBPM 4.0
Attachments: end2end.jpdl.xml, jbpm-issue.zip
I am developing a process that, depending on various decisions, can potentially run from
start to finish without any wait. In this scenario I get the following exception:
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.jpdl.internal.model.JpdlExecution#1]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
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:172)
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.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:54)
at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:106)
at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:65)
at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:61)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:54)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at
org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:65)
at com.ioko.jbpm.JbpmTest.testEnd2End(JbpmTest.java:29)
Caused by: java.sql.SQLException: Integrity constraint violation FK_EXEC_PARENT table:
JBPM4_EXECUTION in statement [delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 38 more
This is a serious problem for my process. Attached is a maven project that reproduces the
problem. You should just be able to run mvn test to see the error.
The problem seems to be with the fork/join. If I take that out it runs ok. I tried to
workaround this issue by introducing a state with short timeout towards the start of the
process but then I get a different error. I can reproduce this fairly easily if it would
be of help in diagnosis.
I make a lot of use of custom nodes. Could a workaround be to use state with handlers
instead of custom nodes?
ps. I tried to read the filing bug guidelines but the site is under maintenance. I feel
this is a fairly clear cut issue and have provided test case so hope I haven't broken
any rules!
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5478
days inactive
5482
days old
17 comments
3 participants
participants (3)
-
Alfie Kirkpatrick (JIRA) -
Ronald van Kuijk (JIRA)
-
Tom Baeyens (JIRA)