[jboss-user] [jBPM] New message: "cannot end the process (jbpm 4.3)"

Bwi Chen do-not-reply at jboss.com
Tue Feb 9 23:45:44 EST 2010 

User development,

A new message was posted in the thread "cannot end the process (jbpm 4.3)":

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

Author  : Bwi Chen
Profile : http://community.jboss.org/people/ScarleTAKE

Message:
--------------------------------------------------------------
hi
i work with jbpm 4.3
os:windows 2000
db:mysql5
 
i created a process and it include three sub-processes(fork), when any one of sub-processes reject, the main process will go to End.
i hit exception:Cannot delete or update a parent row: a foreign key constraint fails
 
it happen because jbpm do not delete tasks of sub-processes(others, and thay not end yet).
when i delete the relation from db, it won't happen. but many task info still in db.
 
is that a bug of jbpm4.3?
 
what can i do?
please help me.
 
thank you very much.
 
 
log
11:26:11,286 DEBUG [org.jbpm.pvm.internal.query.TaskQueryImpl] setting
parameter assignee: user2
11:26:11,286 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- committing hibernate tx 20229682
-------------------------------------------------------
11:26:11,286 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- beginning hibernate tx 15203587
--------------------------------------------------------
11:26:11,296 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- committing hibernate tx 25584663
-------------------------------------------------------
11:26:11,296 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- beginning hibernate tx 26866755
--------------------------------------------------------
11:26:11,536 DEBUG [org.jbpm.pvm.internal.model.op.Signal] signalling
activity(review), signalName=rejected
11:26:11,546 DEBUG [org.jbpm.pvm.internal.model.op.ExecuteActivity]
executing activity(rejected)
11:26:11,546 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleSign.10015] ends with state ended
11:26:11,656 DEBUG [org.jbpm.pvm.internal.model.op.Signal] signalling
activity(Subprocess2), signalName=null
11:26:11,656 DEBUG [org.jbpm.pvm.internal.model.op.ExecuteActivity]
executing activity(join2)
11:26:11,656 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleFork.10001.10007] ends
11:26:11,667 DEBUG [org.jbpm.pvm.internal.id.DatabaseDbidGenerator] last id
-2 was consumed.  acquiring new block...
11:26:11,667 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- beginning hibernate tx 33032422
--------------------------------------------------------
11:26:11,677 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- committing hibernate tx 32813276
-------------------------------------------------------
11:26:11,697 DEBUG [org.jbpm.pvm.internal.id.DatabaseDbidGenerator]
acquired new id block [20001-30000]
11:26:11,697 DEBUG [org.jbpm.pvm.internal.id.DatabaseIdComposer] generated
execution id SimpleFork.10001.20001
11:26:11,697 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl] created
execution[SimpleFork.10001.20001]
11:26:11,697 DEBUG [org.jbpm.pvm.internal.model.op.ExecuteActivity]
executing activity(end1)
11:26:11,707 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleFork.10001] ends with state ended
11:26:11,707 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleFork.10001.10004] ends with state ended
11:26:11,707 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleFork.10001.10010] ends with state ended
11:26:11,707 DEBUG [org.jbpm.pvm.internal.model.ExecutionImpl]
execution[SimpleFork.10001.20001] ends with state ended
11:26:11,727 ERROR [org.hibernate.util.JDBCExceptionReporter] Cannot delete
or update a parent row: a foreign key constraint fails
(`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY
(`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`))
11:26:11,727 ERROR [org.hibernate.event.def.AbstractFlushingEventListener]
Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#10004]
      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.DefaultAutoFlushEventListener.onAutoFlush(
DefaultAutoFlushEventListener.java:64)
      at org.hibernate.impl.SessionImpl.autoFlushIfRequired(
SessionImpl.java:996)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1141)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(
AbstractQueryImpl.java:835)
      at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.findProcessInstanceByIdIgnoreSuspended(
DbSessionImpl.java:211)
      at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessInstance(
DbSessionImpl.java:251)
      at org.jbpm.pvm.internal.model.ExecutionImpl.end(
ExecutionImpl.java:382)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:82)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:45)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.fire(
ExecutionImpl.java:566)
      at org.jbpm.pvm.internal.model.ExecutionImpl.take(
ExecutionImpl.java:472)
      at org.jbpm.jpdl.internal.activity.JoinActivity.execute(
JoinActivity.java:93)
      at org.jbpm.jpdl.internal.activity.JoinActivity.execute(
JoinActivity.java:49)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(
ExecutionImpl.java:616)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:417)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:399)
      at org.jbpm.pvm.internal.model.ExecutionImpl.end(
ExecutionImpl.java:379)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at
org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(
JavassistLazyInitializer.java:197)
      at
org.jbpm.pvm.internal.model.ExecutionImpl_$$_javassist_31.end(ExecutionImpl_$$_javassist_31.java)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:82)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:45)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(
ExecutionImpl.java:616)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:417)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:403)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at
org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(
JavassistLazyInitializer.java:197)
      at
org.jbpm.pvm.internal.model.ExecutionImpl_$$_javassist_31.signal(ExecutionImpl_$$_javassist_31.java)
      at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:194)
      at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(
CompleteTaskCmd.java:65)
      at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(
CompleteTaskCmd.java:32)
      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(
DefaultCommandService.java:42)
      at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(
StandardTransactionInterceptor.java:54)
      at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(
EnvironmentInterceptor.java:53)
      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(
EnvironmentInterceptor.java:40)
      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(
RetryInterceptor.java:55)
      at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(
SkipInterceptor.java:43)
      at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(
TaskServiceImpl.java:96)
      at samples.test.FlowServiceImpl.approve(FlowServiceImpl.java:33)
      at
samples.test.FlowServiceImpl$$FastClassByCGLIB$$12bcdbb0.invoke(<generated>)
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(
Cglib2AopProxy.java:700)
      at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
      at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
TransactionInterceptor.java:106)
      at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
      at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(
Cglib2AopProxy.java:635)
      at
samples.test.FlowServiceImpl$$EnhancerByCGLIB$$8bf75daa.approve(<generated>)
      at samples.test.LoopTest.testApproveTask(LoopTest.java:90)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.testng.internal.MethodHelper.invokeMethod(
MethodHelper.java:644)
      at org.testng.internal.Invoker.invokeMethod(Invoker.java:557)
      at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:711)
      at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1013)
      at org.testng.internal.TestMethodWorker.invokeTestMethods(
TestMethodWorker.java:137)
      at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121
)
      at org.testng.TestRunner.runWorkers(TestRunner.java:908)
      at org.testng.TestRunner.privateRun(TestRunner.java:617)
      at org.testng.TestRunner.run(TestRunner.java:498)
      at org.testng.SuiteRunner.runTest(SuiteRunner.java:329)
      at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:324)
      at org.testng.SuiteRunner.privateRun(SuiteRunner.java:296)
      at org.testng.SuiteRunner.run(SuiteRunner.java:201)
      at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:915)
      at org.testng.TestNG.runSuitesLocally(TestNG.java:879)
      at org.testng.TestNG.run(TestNG.java:787)
      at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:75)
      at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:127)
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY
(`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`))
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      at com.mysql.jdbc.PreparedStatement.executeInternal(
PreparedStatement.java:1332)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1604)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1519)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1504)
      at org.hibernate.persister.entity.AbstractEntityPersister.delete(
AbstractEntityPersister.java:2551)
      ... 89 more
11:26:11,767 INFO  [org.jbpm.pvm.internal.svc.DefaultCommandService]
exception while executing command
org.jbpm.pvm.internal.cmd.CompleteTaskCmd at 18590c5
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#10004]
      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.DefaultAutoFlushEventListener.onAutoFlush(
DefaultAutoFlushEventListener.java:64)
      at org.hibernate.impl.SessionImpl.autoFlushIfRequired(
SessionImpl.java:996)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1141)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
      at org.hibernate.impl.AbstractQueryImpl.uniqueResult(
AbstractQueryImpl.java:835)
      at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.findProcessInstanceByIdIgnoreSuspended(
DbSessionImpl.java:211)
      at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessInstance(
DbSessionImpl.java:251)
      at org.jbpm.pvm.internal.model.ExecutionImpl.end(
ExecutionImpl.java:382)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:82)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:45)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.fire(
ExecutionImpl.java:566)
      at org.jbpm.pvm.internal.model.ExecutionImpl.take(
ExecutionImpl.java:472)
      at org.jbpm.jpdl.internal.activity.JoinActivity.execute(
JoinActivity.java:93)
      at org.jbpm.jpdl.internal.activity.JoinActivity.execute(
JoinActivity.java:49)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(
ExecutionImpl.java:616)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:417)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:399)
      at org.jbpm.pvm.internal.model.ExecutionImpl.end(
ExecutionImpl.java:379)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at
org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(
JavassistLazyInitializer.java:197)
      at
org.jbpm.pvm.internal.model.ExecutionImpl_$$_javassist_31.end(ExecutionImpl_$$_javassist_31.java)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:82)
      at org.jbpm.jpdl.internal.activity.EndActivity.execute(
EndActivity.java:45)
      at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(
ExecuteActivity.java:60)
      at
org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(
ExecutionImpl.java:656)
      at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(
ExecutionImpl.java:616)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:417)
      at org.jbpm.pvm.internal.model.ExecutionImpl.signal(
ExecutionImpl.java:403)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at
org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(
JavassistLazyInitializer.java:197)
      at
org.jbpm.pvm.internal.model.ExecutionImpl_$$_javassist_31.signal(ExecutionImpl_$$_javassist_31.java)
      at org.jbpm.pvm.internal.task.TaskImpl.complete(TaskImpl.java:194)
      at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(
CompleteTaskCmd.java:65)
      at org.jbpm.pvm.internal.cmd.CompleteTaskCmd.execute(
CompleteTaskCmd.java:32)
      at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(
DefaultCommandService.java:42)
      at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(
StandardTransactionInterceptor.java:54)
      at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(
EnvironmentInterceptor.java:53)
      at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(
EnvironmentInterceptor.java:40)
      at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(
RetryInterceptor.java:55)
      at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(
SkipInterceptor.java:43)
      at org.jbpm.pvm.internal.svc.TaskServiceImpl.completeTask(
TaskServiceImpl.java:96)
      at samples.test.FlowServiceImpl.approve(FlowServiceImpl.java:33)
      at
samples.test.FlowServiceImpl$$FastClassByCGLIB$$12bcdbb0.invoke(<generated>)
      at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
      at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(
Cglib2AopProxy.java:700)
      at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
      at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(
TransactionInterceptor.java:106)
      at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
      at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(
Cglib2AopProxy.java:635)
      at
samples.test.FlowServiceImpl$$EnhancerByCGLIB$$8bf75daa.approve(<generated>)
      at samples.test.LoopTest.testApproveTask(LoopTest.java:90)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.testng.internal.MethodHelper.invokeMethod(
MethodHelper.java:644)
      at org.testng.internal.Invoker.invokeMethod(Invoker.java:557)
      at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:711)
      at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1013)
      at org.testng.internal.TestMethodWorker.invokeTestMethods(
TestMethodWorker.java:137)
      at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:121
)
      at org.testng.TestRunner.runWorkers(TestRunner.java:908)
      at org.testng.TestRunner.privateRun(TestRunner.java:617)
      at org.testng.TestRunner.run(TestRunner.java:498)
      at org.testng.SuiteRunner.runTest(SuiteRunner.java:329)
      at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:324)
      at org.testng.SuiteRunner.privateRun(SuiteRunner.java:296)
      at org.testng.SuiteRunner.run(SuiteRunner.java:201)
      at org.testng.TestNG.createAndRunSuiteRunners(TestNG.java:915)
      at org.testng.TestNG.runSuitesLocally(TestNG.java:879)
      at org.testng.TestNG.run(TestNG.java:787)
      at org.testng.remote.RemoteTestNG.run(RemoteTestNG.java:75)
      at org.testng.remote.RemoteTestNG.main(RemoteTestNG.java:127)
Caused by:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb/jbpm4_execution`, CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY
(`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`))
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      at com.mysql.jdbc.PreparedStatement.executeInternal(
PreparedStatement.java:1332)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1604)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1519)
      at com.mysql.jdbc.PreparedStatement.executeUpdate(
PreparedStatement.java:1504)
      at org.hibernate.persister.entity.AbstractEntityPersister.delete(
AbstractEntityPersister.java:2551)
      ... 89 more
11:26:11,787 DEBUG [org.jbpm.pvm.internal.tx.HibernateSessionResource]
----- rolling back hibernate tx 31691786
-----------------------------------------------------
11:26:11,807 DEBUG
[org.springframework.orm.hibernate3.HibernateTransactionManager] Initiating
transaction rollback
11:26:11,807 DEBUG
[org.springframework.orm.hibernate3.HibernateTransactionManager] Rolling
back Hibernate transaction on Session
[org.hibernate.impl.SessionImpl at e7bb91]
11:26:11,807 DEBUG
[org.springframework.orm.hibernate3.HibernateTransactionManager] Closing
Hibernate Session [org.hibernate.impl.SessionImpl at e7bb91] after transaction
11:26:11,807 DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils]
Closing Hibernate Session

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

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

More information about the jboss-user mailing list