topic Re: System error on logon after one day in Alfresco Archive

System error on logon after one day

janvg — Mon, 17 Jul 2006 07:34:09 GMT

Every morning if I try to login to my Alfresco server (Windows, alfresco 1.3.0 ) I get this error. Rebooting the server solves the problem, but 24 h later it just returns ? Any idea ? javax.faces.FacesException: Error calling action method of component with id loginForm:submitcaused by:javax.faces.e

Re: System error on logon after one day

nullman — Mon, 17 Jul 2006 12:27:08 GMT

I have been struggling with the exact same problem since I installed the 1.3.0 Community version alomost two weeks ago. I did a full re-install this weekend and it did not help.

I had made a separate thread just this morning, but I'll delete it and add the post here instead.

————

I get an error each and every monrning when I try to log into Alfresco. I've uninstalled it and re-installed it and get the exact same problem every time. If anyone has a suggestion or can let me know if they have the same problem it would be appreciated.

As soon as I login with my username and password and select Login I see this:

System Error

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.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.net.SocketException MESSAGE: Software caused connection abort: recv failed STACKTRACE: java.net.SocketException: Software caused connection abort: recv failed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:129) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902) 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 $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.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 15 ms ago.

Hide Details

javax.faces.FacesException: Error calling action method of component with id loginForm:submit
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:74)
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.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: javax.faces.el.EvaluationException: Exception while invoking expression #{LoginBean.login}
at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:153)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
… 24 more
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 $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)
… 25 more
Caused by: org.hibernate.TransactionException: JDBC begin failed:
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)
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.net.SocketException MESSAGE: Software caused connection abort: recv failed STACKTRACE: java.net.SocketException: Software caused connection abort: recv failed
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)
at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1902)
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 $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.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 15 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

This is installed on a Windows 2003 Server using the latest 1.3.0 Community Edition bundle, nothing special. The only other thing the server is being used for is as a My Documents folder for a few users. If I select Return to Application at the bottom of the error page any try again it works the rest of the day.

Thanks

Re: System error on logon after one day

kevinr — Mon, 17 Jul 2006 12:43:07 GMT

Hello,

We believe this problem is with the connection pooling library we are using for our JDBC connections.

It appears that MySQL is timing out it's connections after a set period but the connection pool library is not reconnecting them until an error occurs. So we need to configure the connection pool to throw away connections and recreate them after a period.

I will look into the configuration for the library - it's called C3PO - and see if it can be configured to do this. It may also be possible to configure your MySQL db instance to not timeout connections also - but this is less desirable than fixing the Alfresco config.

Thanks for spotting this one, well get it solved!

Kevin

Re: System error on logon after one day

hikenboots — Mon, 17 Jul 2006 14:31:16 GMT

Here is a work around if you are using unix; ugly but it works. This makes MySql wait 24 hours before killing the connection, by which time whe cron job is restarting alfresco to refresh the connection. I've been using this on three servers for a week. Be sure you don't have any users working at 3 am.

set your script location and cron this up:
# Restarts Alfresco due to Mysql Timeout Issue
00 03 * * * /some_dir/bin/alf.sh>/dev/null

create alf.sh:
#! /bin/bash
#
# Restarts alfresco every 24 hours to get around the mysql timeout issue

JAVA_HOME=/usr/local/jdk1.5.0_07
export JAVA_HOME
PATH=$JAVA_HOME/bin:$PATH
export PATH

cd /opt/alfresco

##Stop Alfresco
/opt/alfresco/alfresco.sh stop
sleep 10

##Start Alfresco
/opt/alfresco/alfresco.sh start &

exit

/etc/my.cnf:
[mysqld]
wait_timeout=86400
…(rest of file)

Re: System error on logon after one day

kevinr — Mon, 17 Jul 2006 15:04:28 GMT

Here is some more info on the issue:
http://forum.hibernate.org/viewtopic.php?t=934779

It should be possible to correctly configure our hibernate C3PO pool to retry once this issue occurs. Once we have a working config i'll let you know.

Thanks,

Kevin

Re: System error on logon after one day

nullman — Mon, 17 Jul 2006 16:22:26 GMT

Thanks. The good news is I am on the east coast and log in before anyone else in the office on the west coast (U.S.). As noted, I don't restart the service, I just select the link at the bottom, or reload the login page and try again to get the error to go away. I don't think any test users have seen the error.

I was getting worried that I had messed something up playing with the XML files to get things configured the way we needed. Because of that I did a reinstall in the wee hours of the morning on Sunday, but ran into the same error when I logged on this morning. I am just glad to know others have the same problem and it wasn't something I did that caused it.

Re: System error on logon after one day

kevinr — Mon, 17 Jul 2006 16:54:07 GMT

The following config solution should work:

Edit the file "core-services-context.xml", find and edit the Datasource bean section as follows:


    <!– Datasource bean –>
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass">
            <value>${db.driver}</value>
        </property>
        <property name="jdbcUrl">
            <value>${db.url}</value>
        </property>
        <property name="user">
            <value>${db.username}</value>
        </property>
        <property name="password">
            <value>${db.password}</value>
        </property>
        <property name="initialPoolSize" >
            <value>${db.pool.initial}</value>
        </property>
        <property name="maxPoolSize" >
            <value>${db.pool.max}</value>
        </property>
        <property name="maxIdleTime" >
            <value>${db.pool.maxIdleTime}</value>
        </property>
        <property name="numHelperThreads" >
            <value>1</value>
        </property>
    </bean>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Add these properties to the section # Database configuration in the file "repository.properties" as follows:


db.pool.initial=10
db.pool.max=20
db.pool.maxIdleTime=120
‍‍‍‍‍

This should fix the problem, please let us know if it works for you.

Thanks,

Kevin

Re: System error on logon after one day

csiege — Mon, 17 Jul 2006 17:06:15 GMT

Kevin,

Do you recommend these changes for 1.3 Enterprise running on sqlserver 2005 also?

thanks.

Chris

Re: System error on logon after one day

nullman — Mon, 17 Jul 2006 23:21:47 GMT

I made both changes. db.pool.initial=10 and db.pool.max=20 were already there. I added db.pool.maxIdleTime=120. Stopped and then restarted Alfresco. It's up and running fine.

I'll let you know in the morning if it resloved the error.

Thanks,
Mike

Re: System error on logon after one day

kevinr — Tue, 18 Jul 2006 09:12:17 GMT

Do you recommend these changes for 1.3 Enterprise running on sqlserver 2005 also?

To be honest without testing specifically with SQLServer I'm not sure if it's required - I would guess the answer is "yes" assuming SQLServer eventually times out unused connections. It probably won't hurt as refreshing a connection (every 2 hours in this case) in not a bad thing anyway.

Thanks,

Kevin

Re: System error on logon after one day

nullman — Tue, 18 Jul 2006 12:50:37 GMT

Kevin,

I am happy to report that I did not receive an error when I logged in this morning. Thanks so much for your help with this!

Mike

Re: System error on logon after one day

kevinr — Tue, 18 Jul 2006 13:01:55 GMT

No problem, glad we solved the issue!

Kevin

Re: System error on logon after one day

hikenboots — Tue, 18 Jul 2006 13:07:26 GMT

Kevin,

I am happy to report that I did not receive an error when I logged in this morning. Thanks so much for your help with this!

Mike

Ditto. All is well here (I tried it with an MySQL timeout of 5 minutes with no error.) Many thanks for the fix!

Re: System error on logon after one day

nuro — Thu, 24 May 2007 17:01:03 GMT

Hi,

I hope this thread is still being watched. We are running into this exact same problem with our install of Alfresco 2.0, but I see these fixes are for 1.3. We are crashing very frequently and I have had to suspend testing on this great product because of this.

Could someone please post the fix for this in relation to 2.0 files & values?

Our Info: Alfresco 2.0 Community Version, mySQL DB & Tomcat all running on Ubuntu.

Thanks,
Paul

Re: System error on logon after one day

derek — Tue, 29 May 2007 09:04:34 GMT

Hi,

What are the maximum number of connections allowed by your MySQL server?
Have you played with any of the connection properties available on the connection pool provided in 2.0?
Do you have any custom code in the product?

We moved to the DBCP connection pool as the default configuration. It provides the connections, so you can configure the pool to match the database-specific timeouts and limits.

Regards

Re: System error on logon after one day

nuro — Tue, 29 May 2007 15:15:20 GMT

Thanks for the reply,

Sorry for the non-expert answers I'm about to give here, but as with many companies I had to step up and try and configure Alfresco because it's a "Web-App" and because I'm the "Web-Guy" It's now mine to fix… Even though I don't have all the knowledge yet to administer mySQL.

Your Question 1 Answer: I"ll find out what the max-connections are in our mySQL, but it's most likely still the default setting.

Your Question 2 Answer: No, I haven't adjusted any connection properties in DBCP. What config file do they reside it. I can modify that if necessary.

Your Question 3 Answer: No custom code, yet. Got to get this stable first.

So, I"ll need to set the mySQL and DBCP pool/connection/timeout properties to match corrrect? I can do that, but the files and default locations of them would be a great help.

Thanks!

Re: System error on logon after one day

derek — Tue, 29 May 2007 15:38:44 GMT

Hi,

In the installation, you should have a file named custom-connection-pool-context.xml.sample in your tomcat/shared/classes/alfresco/extension directory. You can enable that config by removing the .sample extension and set any of the properties in there. You may find that merely activating that extension is enough, though.

Mostly, we don't see any issues with the default configuration, so you should still check that that the maximum number of connections (as per custom-repository.properties) doesn't exceed the number of allowed connections for the alfresco user in MySQL.

Good luck.

Re: System error on logon after one day

mrboogiee — Wed, 12 Aug 2009 09:07:47 GMT

Hi,

I'm currently installing Alfresco 3.2 on a Ubuntu 9.04 install via the repositories, but I am getting the same error as described above. I've tried setting the variables as told in the previous posts, but it doesn't resolve the problem. Could it be that I miss some software components? or is there a configuration parameter that I might have missed or something? I really don't know where to look any further, and I also can't find anything on the web where this error is related to 3.2.

The exact error message I receive is as follows:

javax.faces.FacesException: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
caused by:
org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
caused by:
javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
caused by:
javax.faces.el.EvaluationException: Exception getting value of property nodeProperties of base of type : org.alfresco.web.bean.NavigationBean
caused by:
javax.faces.el.EvaluationException: Bean: org.alfresco.web.bean.NavigationBean, property: nodeProperties
caused by:
java.lang.reflect.InvocationTargetException
caused by:
java.lang.NullPointerException

with the following under the details:

javax.faces.FacesException: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:425)
at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:109)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy185.doFilter(Unknown Source)
at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.alfresco.repo.webdav.auth.BaseNTLMAuthenticationFilter.doFilter(BaseNTLMAuthenticationFilter.java:264)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:109)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy185.doFilter(Unknown Source)
at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:636)
Caused by: org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)
… 40 more
Caused by: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:405)
at javax.faces.component.UIGraphic.getValue(UIGraphic.java:99)
at javax.faces.component.UIGraphic.getUrl(UIGraphic.java:38)
at org.apache.myfaces.shared_impl.renderkit.html.HtmlImageRendererBase.encodeEnd(HtmlImageRendererBase.java:56)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:539)
at javax.faces.webapp.UIComponentTag.encodeEnd(UIComponentTag.java:498)
at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:366)
at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_h_005fgraphicImage_005f0(browse_jsp.java:1473)
at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:648)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
… 50 more
Caused by: javax.faces.el.EvaluationException: Exception getting value of property nodeProperties of base of type : org.alfresco.web.bean.NavigationBean
at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:99)
at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)
at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
at org.apache.commons.el.ExpressionString.evaluate(ExpressionString.java:114)
at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:386)
… 61 more
Caused by: javax.faces.el.EvaluationException: Bean: org.alfresco.web.bean.NavigationBean, property: nodeProperties
at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:461)
at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)
… 65 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:457)
… 66 more
Caused by: java.lang.NullPointerException
at org.alfresco.web.bean.NavigationBean.getCurrentNode(NavigationBean.java:705)
at org.alfresco.web.bean.NavigationBean.getNodeProperties(NavigationBean.java:656)
… 71 more

Re: System error on logon after one day

derek — Wed, 12 Aug 2009 09:59:17 GMT

Hi,

I'm currently installing Alfresco 3.2 on a Ubuntu 9.04 install via the repositories, but I am getting the same error as described above. I've tried setting the variables as told in the previous posts, but it doesn't resolve the problem. Could it be that I miss some software components? or is there a configuration parameter that I might have missed or something? I really don't know where to look any further, and I also can't find anything on the web where this error is related to 3.2.

The exact error message I receive is as follows:
javax.faces.FacesException: javax.faces.el.EvaluationException: Cannot get value for expression '/images/icons/#{NavigationBean.nodeProperties.icon}.gif'
……

Hi,
On 3.2, the properties can all be set via a single properties file, alfresco-global.properties (http://wiki.alfresco.com/wiki/Repository_Configuration#Global_Property_Overrides)
But first take a look at the alfresco.log file and check that everything started up correctly. There should be no further components or settings required to just get a basic login, but naturally it should work if the web-app started fine.
Regards

Re: System error on logon after one day

mrboogiee — Wed, 12 Aug 2009 10:26:21 GMT

Hi,

My alfresco.log tells me the following:

12:20:06,222 INFO [org.alfresco.config.JBossEnabledWebApplicationContext] Refreshing org.alfresco.config.JBossEnabledWebApplicationContext@659718b5: display name [Root WebApplicationContext]; startup date [Wed Aug 12 12:20:06 CEST 2009]; root of context hierarchy
12:20:06,793 INFO [org.alfresco.config.JBossEnabledWebApplicationContext] Bean factory for application context [org.alfresco.config.JBossEnabledWebApplicationContext@659718b5]: org.springframework.beans.factory.support.DefaultListableBeanFactory@35bb9953
12:20:09,089 INFO [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
12:20:09,142 INFO [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised Presentation Web Script Container (in 189.72719ms)
12:20:10,468 INFO [org.alfresco.web.scripts.DeclarativeRegistry] Registered 171 Web Scripts (+0 failed), 173 URLs
12:20:10,526 INFO [org.alfresco.web.scripts.AbstractRuntimeContainer] Initialised WebFramework Web Script Container (in 1371.1992ms)
12:20:11,333 INFO [org.alfresco.web.site.FrameworkHelper] Successfully Initialized Web Framework

So that seems to me that everything started just fine. I also can login, but I can't go to fe the company home without receiving the above mentioned error message. I've tried tweaking the database connection settings, but that didn't make any difference.