[jboss-user] [jBPM] - JBPM4.3 jobExecutor threads cause database deadlock exception

Prachi M do-not-reply at jboss.com
Mon Aug 9 01:40:09 EDT 2010


Prachi M [http://community.jboss.org/people/mukh.prac] replied to the discussion

"JBPM4.3 jobExecutor threads cause database deadlock exception"

To view the discussion, visit: http://community.jboss.org/message/556414#556414

--------------------------------------------------------------
Hi Zengping,

I am facing the same issue with jBPM 4.3 + Tomcat 6.0 + DB2 environment.
The stack trace says:


org.jbpm.api.JbpmException: couldn't extract bytes out of blob org.jbpm.pvm.internal.lob.BlobStrategyBlob.get(BlobStrategyBlob.java:27) org.jbpm.pvm.internal.lob.Lob.extractBytes(Lob.java:102) org.jbpm.pvm.internal.repository.DeploymentImpl.getBytes(DeploymentImpl.java:182) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:197) org.jbpm.pvm.internal.repository.DeploymentImpl_$$_javassist_29.getBytes(DeploymentImpl_$$_javassist_29.java) org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:62) org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46) org.jbpm.pvm.internal.repository.RepositorySessionImpl.getObject(RepositorySessionImpl.java:129) org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:72) org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:71) org.jbpm.pvm.internal.query.AbstractQuery.untypedUniqueResult(AbstractQuery.java:75) org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.uniqueResult(ProcessDefinitionQueryImpl.java:145) org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionByKey(RepositorySessionImpl.java:153) org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:58) org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:38) org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45) org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:55) org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55) org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:70) com.ms.msqe.trmworkflow.bpm.service.impl.WorkflowServiceImpl.submitRelease(WorkflowServiceImpl.java:93) com.ms.msqe.trmworkflow.controllerservlet.SubmitReleaseController.onSubmit(SubmitReleaseController.java:56) org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272) org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:727) javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

root cause

*com.ibm.db2.jcc.b.SqlException:* [jcc][10120][11936][3.53.95] Invalid operation: Lob is closed. ERRORCODE=-4470, SQLSTATE=null com.ibm.db2.jcc.b.bd.a(bd.java:660) com.ibm.db2.jcc.b.bd.a(bd.java:60) com.ibm.db2.jcc.b.bd.a(bd.java:94) com.ibm.db2.jcc.b.ce.d(ce.java:67) com.ibm.db2.jcc.b.ce.r(ce.java:56) com.ibm.db2.jcc.b.ce.length(ce.java:41) org.hibernate.lob.SerializableBlob.length(SerializableBlob.java:54) org.jbpm.pvm.internal.lob.BlobStrategyBlob.get(BlobStrategyBlob.java:25) org.jbpm.pvm.internal.lob.Lob.extractBytes(Lob.java:102) org.jbpm.pvm.internal.repository.DeploymentImpl.getBytes(DeploymentImpl.java:182) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:197) org.jbpm.pvm.internal.repository.DeploymentImpl_$$_javassist_29.getBytes(DeploymentImpl_$$_javassist_29.java) org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:62) org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46) org.jbpm.pvm.internal.repository.RepositorySessionImpl.getObject(RepositorySessionImpl.java:129) org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:72) org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:71) org.jbpm.pvm.internal.query.AbstractQuery.untypedUniqueResult(AbstractQuery.java:75) org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.uniqueResult(ProcessDefinitionQueryImpl.java:145) org.jbpm.pvm.internal.repository.RepositorySessionImpl.findProcessDefinitionByKey(RepositorySessionImpl.java:153) org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:58) org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:38) org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42) org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45) org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:55) org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53) org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55) org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:70) com.ms.msqe.trmworkflow.bpm.service.impl.WorkflowServiceImpl.submitRelease(WorkflowServiceImpl.java:93) com.ms.msqe.trmworkflow.controllerservlet.SubmitReleaseController.onSubmit(SubmitReleaseController.java:56) org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:272) org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:268) org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560) javax.servlet.http.HttpServlet.service(HttpServlet.java:727) javax.servlet.http.HttpServlet.service(HttpServlet.java:820)


Please provide some pointers. Did you resolve the problem?

Thanks,
Prachi

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

Reply to this message by going to Community
[http://community.jboss.org/message/556414#556414]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100809/db858bc8/attachment-0001.html 


More information about the jboss-user mailing list