Hello! I have a problem since a long time with my jbpm database.
I work on a program which use Apache Tomcat 5.0 and Jbpm 3.1.2 and a mysql database. The workflow well run but when when the server is running all the night, we have strange problems in the morning... The workflow have some bugs and we solve them by re-deploy the process definition (sometimes, we have just to redeploy the processdefinition on an another application on the same server and it run!!!!) We take the log on the server : | | 2007-04-03 09:48:21 StandardWrapperValve[Faces Servlet]: Servlet.service() for servlet Faces Servlet | threw exception | javax.faces.el.EvaluationException: Exception while invoking expression #{transfertBean.selectTransf | ert} | at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153) | at javax.faces.component.UICommand.broadcast(UICommand.java:86) | at javax.faces.component.UIData.broadcast(UIData.java:513) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:281) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:257) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:412) | at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343) | at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) | at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:232) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) | at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol | .java:705) | at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) | at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) | at java.lang.Thread.run(Thread.java:595) | Caused by: org.jbpm.JbpmException: couldn't get pooled task instances list for actors '[ADMIN, ADMIN | ]' | at org.jbpm.db.TaskMgmtSession.findPooledTaskInstances(TaskMgmtSession.java:122) | at bsa.common.jbpm.view.ProcessManageBean.findTask(ProcessManageBean.java:480) | at bsa.common.jbpm.view.ProcessManageBean.isProcess(ProcessManageBean.java:529) | at bsa.transfert.view.TransfertBean.checkPageTransfertBooleanProcess(TransfertBean.java:937) | at bsa.transfert.view.TransfertBean.selectTransfert(TransfertBean.java:646) | 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.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129) | ... 38 more | Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.loader.Loader.doList(Loader.java:2148) | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) | at org.hibernate.loader.Loader.list(Loader.java:2024) | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) | at org.jbpm.db.TaskMgmtSession.findPooledTaskInstances(TaskMgmtSession.java:118) | ... 47 more | Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exc | eption: | | ** BEGIN NESTED EXCEPTION ** | | java.net.SocketException | MESSAGE: Broken pipe | | STACKTRACE: | | java.net.SocketException: Broken pipe | at java.net.SocketOutputStream.socketWrite0(Native Method) | at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) | at java.net.SocketOutputStream.write(SocketOutputStream.java:136) | at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65) | at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123) | at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692) | at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) | at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) | at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) | at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) | at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) | at org.hibernate.loader.Loader.doQuery(Loader.java:662) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) | at org.hibernate.loader.Loader.doList(Loader.java:2145) | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) | at org.hibernate.loader.Loader.list(Loader.java:2024) | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) | at org.jbpm.db.TaskMgmtSession.findPooledTaskInstances(TaskMgmtSession.java:118) | at bsa.common.jbpm.view.ProcessManageBean.findTask(ProcessManageBean.java:480) | at bsa.common.jbpm.view.ProcessManageBean.isProcess(ProcessManageBean.java:529) | at bsa.transfert.view.TransfertBean.checkPageTransfertBooleanProcess(TransfertBean.java:937) | at bsa.transfert.view.TransfertBean.selectTransfert(TransfertBean.java:646) | 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.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:129) | at javax.faces.component.UICommand.broadcast(UICommand.java:86) | at javax.faces.component.UIData.broadcast(UIData.java:513) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:281) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:257) | at org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:412) | at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:343) | at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) | at javax.faces.webapp.FacesServlet.service(FacesServlet.java:137) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:232) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186 | ) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) | at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) | at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) | at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) | at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) | at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol | .java:705) | at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) | at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) | at java.lang.Thread.run(Thread.java:595) | | | ** END NESTED EXCEPTION ** | | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4034425#4034425 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4034425 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user