topic Re: Help needed with a web client System Error in Alfresco Archive

Help needed with a web client System Error

hikenboots — Thu, 06 Jul 2006 23:37:54 GMT

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

Re: Help needed with a web client System Error

ribz33 — Fri, 07 Jul 2006 14:00:45 GMT

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

Re: Help needed with a web client System Error

sirdodger — Fri, 07 Jul 2006 15:22:48 GMT

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.

Re: Help needed with a web client System Error

hikenboots — Fri, 07 Jul 2006 16:27:57 GMT

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

Re: Help needed with a web client System Error

hikenboots — Mon, 10 Jul 2006 14:44:41 GMT

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

Re: Help needed with a web client System Error

sirdodger — Mon, 10 Jul 2006 14:46:55 GMT

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.

Re: Help needed with a web client System Error

hikenboots — Tue, 11 Jul 2006 03:17:12 GMT

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?

Re: Help needed with a web client System Error

ribz33 — Tue, 11 Jul 2006 08:29:13 GMT

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

Re: Help needed with a web client System Error

derek — Tue, 11 Jul 2006 09:41:42 GMT

Hi,

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

Regards

Re: Help needed with a web client System Error

hikenboots — Tue, 11 Jul 2006 13:01:31 GMT

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.

Re: Help needed with a web client System Error

sirdodger — Mon, 17 Jul 2006 21:46:34 GMT

Check this out for information on the problem, and ways to solve it.

http://forums.mysql.com/read.php?39,16257,34537#msg-34537

Re: Help needed with a web client System Error

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

http://forums.alfresco.com/viewtopic.php?t=2538