topic Loosing and not recreating MySQL database session in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/loosing-and-not-recreating-mysql-database-session/m-p/71011#M45927 <HTML><HEAD></HEAD><BODY><SPAN>I have installed Alfresco with JDK 1.5.0, MySQL 4.1 working on FreeBSD 6.0. After an hour or somewhat more after starting the service if no activity is performed seems that database connection iis lost and new one is not created. While I actively work with Alfresco everything is ok.</SPAN><BR /><SPAN>MySQL is on the same server so there are no network connectivity issues.</SPAN><BR /><SPAN>I have tried with AutoReconnect=true, but nothing changed.</SPAN><BR /><SPAN>I also tried org.gjt.mm.mysql and com.mysql driver versions with the same results.</SPAN><BR /><BR /><SPAN>This is the message I get:</SPAN><BR /><BR /><SPAN>avax.faces.FacesException: Error calling action method of component with id loginForm:submit</SPAN><BR /><BR /><SPAN>caused by:</SPAN><BR /><SPAN>javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}</SPAN><BR /><BR /><SPAN>caused by:</SPAN><BR /><SPAN>org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:</SPAN><BR /><BR /><SPAN>caused by:</SPAN><BR /><SPAN>org.hibernate.TransactionException: JDBC begin failed:</SPAN><BR /><BR /><SPAN>caused by:</SPAN><BR /><SPAN>com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** 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:2637) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1554) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) at com.mysql.jdbc.Connection.execSQL(Connection.java:3118) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:5215) at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:781) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:282) at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:225) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy14.isCurrentUserTheSystemUser(Unknown Source) at org.alfresco.repo.security.permissions.impl.acegi.ACLEntryVoter.vote(ACLEntryVoter.java:189) at net.sf.acegisecurity.vote.AffirmativeBased.decide(AffirmativeBased.java:69) at net.sf.acegisecurity.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:394) at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:77) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:40) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy22.getCurrentUserName(Unknown Source) at org.alfresco.web.bean.LoginBean.login(LoginBean.java:286) 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 org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63) at javax.faces.component.UICommand.broadcast(UICommand.java:106) at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90) at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164) at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:105) at org.alfresco.web.app.servlet.AlfrescoFacesServlet.service(AlfrescoFacesServlet.java:49) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:744) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:674) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:866) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** Last packet sent to the server was 607 ms ago.</SPAN></BODY></HTML> Mon, 04 Sep 2006 17:10:12 GMT phaethon 2006-09-04T17:10:12Z Loosing and not recreating MySQL database session https://connect.hyland.com/t5/alfresco-archive/loosing-and-not-recreating-mysql-database-session/m-p/71011#M45927 I have installed Alfresco with JDK 1.5.0, MySQL 4.1 working on FreeBSD 6.0. After an hour or somewhat more after starting the service if no activity is performed seems that database connection iis lost and new one is not created. While I actively work with Alfresco everything is ok.MySQL is on the s Mon, 04 Sep 2006 17:10:12 GMT https://connect.hyland.com/t5/alfresco-archive/loosing-and-not-recreating-mysql-database-session/m-p/71011#M45927 phaethon 2006-09-04T17:10:12Z Re: Loosing and not recreating MySQL database session https://connect.hyland.com/t5/alfresco-archive/loosing-and-not-recreating-mysql-database-session/m-p/71012#M45928 <HTML><HEAD></HEAD><BODY><A href="http://forums.alfresco.com/viewtopic.php?t=2538" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=2538</A></BODY></HTML> Tue, 05 Sep 2006 07:56:06 GMT https://connect.hyland.com/t5/alfresco-archive/loosing-and-not-recreating-mysql-database-session/m-p/71012#M45928 kevinr 2006-09-05T07:56:06Z