Help needed with a web client System Error

[hikenboots]

Can someone tell me what's going on with this? Restarting alfresco and clearing the web browser data don't seem to help for very long. Running FC4/ Alfresco. FWIW, I'm running Tomcat on 8081 w/ shutdown port of 8004 because of my email server (Scalix) runs it's own instance of tomcat as well.  Don't know if that relates; v1.2 worked fine. When I click on aribtrary links in the 1.3 web client, I get:

javax.faces.el.EvaluationException: Exception while invoking expression #{BrowseBean.clickSpace}

caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed:

caused by:
org.hibernate.TransactionException: JDBC begin failed:

caused by:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913) 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 $Proxy9.getNamespaceURI(Unknown Source) at org.alfresco.service.namespace.QName.resolveToQName(QName.java:417) at org.alfresco.web.bean.repository.Repository.resolveToQName(Repository.java:596) at org.alfresco.web.config.NodeTypeEvaluator.applies(NodeTypeEvaluator.java:45) at org.alfresco.config.DefaultLookupAlgorithm.process(DefaultLookupAlgorithm.java:41) at org.alfresco.config.BaseConfigService.processSection(BaseConfigService.java:360) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:171) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:117) at org.alfresco.web.app.AlfrescoNavigationHandler.handleDispatch(AlfrescoNavigationHandler.java:418) at org.alfresco.web.app.AlfrescoNavigationHandler.handleNavigation(AlfrescoNavigationHandler.java:119) at org.alfresco.web.bean.BrowseBean.navigateBrowseScreen(BrowseBean.java:1652) at org.alfresco.web.bean.BrowseBean.updateUILocation(BrowseBean.java:1595) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1114) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1096) 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.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:73) 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.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) 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 2 ms ago.

Hide Details

javax.faces.el.EvaluationException: Exception while invoking expression #{BrowseBean.clickSpace} at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153) at javax.faces.component.UICommand.broadcast(UICommand.java:86) 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:73) 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.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed: at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:548) 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 $Proxy9.getNamespaceURI(Unknown Source) at org.alfresco.service.namespace.QName.resolveToQName(QName.java:417) at org.alfresco.web.bean.repository.Repository.resolveToQName(Repository.java:596) at org.alfresco.web.config.NodeTypeEvaluator.applies(NodeTypeEvaluator.java:45) at org.alfresco.config.DefaultLookupAlgorithm.process(DefaultLookupAlgorithm.java:41) at org.alfresco.config.BaseConfigService.processSection(BaseConfigService.java:360) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:171) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:117) at org.alfresco.web.app.AlfrescoNavigationHandler.handleDispatch(AlfrescoNavigationHandler.java:418) at org.alfresco.web.app.AlfrescoNavigationHandler.handleNavigation(AlfrescoNavigationHandler.java:119) at org.alfresco.web.bean.BrowseBean.navigateBrowseScreen(BrowseBean.java:1652) at org.alfresco.web.bean.BrowseBean.updateUILocation(BrowseBean.java:1595) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1114) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1096) 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) … 24 more Caused by: org.hibernate.TransactionException: JDBC begin failed: at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:6Cool at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290) at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:520) … 48 more Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913) 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 $Proxy9.getNamespaceURI(Unknown Source) at org.alfresco.service.namespace.QName.resolveToQName(QName.java:417) at org.alfresco.web.bean.repository.Repository.resolveToQName(Repository.java:596) at org.alfresco.web.config.NodeTypeEvaluator.applies(NodeTypeEvaluator.java:45) at org.alfresco.config.DefaultLookupAlgorithm.process(DefaultLookupAlgorithm.java:41) at org.alfresco.config.BaseConfigService.processSection(BaseConfigService.java:360) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:171) at org.alfresco.config.BaseConfigService.getConfig(BaseConfigService.java:117) at org.alfresco.web.app.AlfrescoNavigationHandler.handleDispatch(AlfrescoNavigationHandler.java:418) at org.alfresco.web.app.AlfrescoNavigationHandler.handleNavigation(AlfrescoNavigationHandler.java:119) at org.alfresco.web.bean.BrowseBean.navigateBrowseScreen(BrowseBean.java:1652) at org.alfresco.web.bean.BrowseBean.updateUILocation(BrowseBean.java:1595) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1114) at org.alfresco.web.bean.BrowseBean.clickSpace(BrowseBean.java:1096) 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.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:73) 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.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) 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 2 ms ago. at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:4913) at com.mchange.v2.c3p0.impl.NewProxyConnection.setAutoCommit(NewProxyConnection.java:781) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63) … 50 more
Return to application
Logout

[ribz33]

I had the same error sometimes and i didnt understand why !

[sirdodger]

I am getting the same error on login.

javax.faces.FacesException: Error calling action method of component with id loginForm:submit

caused by:
javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}

caused by:
org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection

caused by:
org.hibernate.exception.JDBCConnectionException: Cannot open connection

caused by:
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2555) at com.mysql.jdbc.Connection.(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:360) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:122) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:125) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1309) 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 $Proxy22.authenticate(Unknown Source) at org.alfresco.web.bean.LoginBean.login(LoginBean.java:282) 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:106) 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.coyote.http11.Http11Processor.process(Http11Processor.java:868) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) 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 1 ms ago.

[hikenboots]

I am getting the same error on login.

…

That's when I notice it as well.  I have to restart alfresco and then it works fine for a good while but the problem comes back.  I stop/start alfresco every night and alfresco.log shows this error (as well as the web client) upon what appears to be alfresco starting.  FWIW

[hikenboots]

I updated the dev server this weekend and installed a new JDK java version "1.5.0_07" but I still get the aforementioned error and had to restart the Alfresco app this am.  This is a real problem, I have two sites which were waiting on 1.3 to go live and I'm now puting them off again.    If anyone has any idea of why this is happening, please post.  This wasn't an issue with 1.2.

Linux hq.xxxxxxxx.com 2.6.17-1.2141_FC4smp #1 SMP Fri Jun 30 15:08:52 EDT 2006 i686 i686 i386 GNU/Linux

java version "1.5.0_07"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_07-b03)
Java HotSpot(TM) Client VM (build 1.5.0_07-b03, mixed mode, sharing)

[root@hq ~]# rpm -qa | grep mysql
mysql-4.1.20-1.FC4.1
php-mysql-5.0.4-10.5
mysql-server-4.1.20-1.FC4.1

09:08:49,679 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to execute command: imconvert /opt/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_14769.gif  /opt/alfresco/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_14770.png
09:08:53,594 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
09:08:53,745 INFO  [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
09:08:54,185 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_07-b03; maximum heap size 493.063MB
09:08:54,186 WARN  [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - WARNING - maximum heap size 493.063MB is less than recommended 512MB
09:08:54,187 INFO  [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 1.3.0 schema 14 - Installed version 1.3.0 schema 14

[sirdodger]

I was having this problem with version 1.2.  So far, 1.3 seems to have fixed the problem, but I haven't used it much, and the problem was intermittent.

[hikenboots]

The problem lies with mysql.  After 8 hours of connection inactivity mysql, by default, drops the alfresco connection.  This timeout period is customizable in /etc/my.cnf as such:

[mysqld]
…
wait_timeout=500

Change the number of seconds to 120 and it produces the error in 2 minutes, change it to 480 and it bombs in 8 minutes, etc.

I'm going to test a (soon to be deprecated) auto reconnect feature:
/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/repository.properties:

# Database configuration
…
db.url=jdbc:mysql:///${db.name}?autoReconnect=true
…

Append ?autoReconnect=true to the url.  I guess I'll know in 8 hours if this works.  But I'll be out of town so no reports tomorrow.

Seems that alfresco needs to "tickle" the connection once in a while to eliminate this behavior.  Anyone have suggestions?

[ribz33]

Hi,
great job hikenboots to had located problem. I had thunk about waiting 8h…
And in default configuration of mysql server interactive timeout is configure on 28800 sec = 8h !

So i had done some test with interactive_timeout=10 sec ( i hate wait ! lol) and problem come.

So we can say that Alfresco had an interactive connection with database and if there is no activity during 8h (by default) Mysql close connection and Alfresco is not able to reconnect.

I had tried also your idea:
db.url=jdbc:mysql:///${db.name}?autoReconnect=true
but when i restart my tomcat server Alfresco application didnt start with this new parameter.

Hikenboots do you succeed to restart alfresco with this new value ?

Now, that we are thinking to had located problem someone had an idea to solve it better as possible ?
Because, in my case i dont know how long alfresco can stay inactive that can be 1h or 1 week lol

Thx in advance,
bst regards

[derek]

Hi,

You can control the connection checks, timeouts, etc. using the C3P0 connection pool.

Regards

[hikenboots]

Hi,
I had tried also your idea:
db.url=jdbc:mysql:///${db.name}?autoReconnect=true
but when i restart my tomcat server Alfresco application didnt start with this new parameter.

Hikenboots do you succeed to restart alfresco with this new value ?

Now, that we are thinking to had located problem someone had an idea to solve it better as possible ?

Alfresco did restart with the new connection url but the error returned this am so I went with the wait_timeout=86400  for now.  Thanks for the tip on C3PO, Derek.  If anyone has a chance to work with it/research it, please post your results.