portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arnaudin Xavier ...@alienor.com>
Subject Re: Problem with Mysql and connector/J
Date Tue, 06 Jul 2004 13:29:17 GMT
Hi,

I have found my problem. On mysql server in my config file, connexion 
timeout has defined as 60 seconds. So in torque.properties i have 
defined this :

torque.dsfactory.default.pool.defaultMaxConnections=10
torque.dsfactory.default.pool.maxExpiryTime=60 ------> this parameter is 
defined as 3600 second by default.
torque.dsfactory.default.pool.connectionWaitTimeout=60

Now there is no timeout connexion

Arnaudin Xavier a écrit :

> Hi all.
>
> Sorry for my english.
>
> I have problem with jetspeed 1.5 using with mysql 4.0.20.
> I'm using connector/j 3.0.14 production or 3.1-nightly-20040702 there 
> is same error.
>
> The portal have timeout error when user attempt to click after one 
> minute.
>
> If i'm surfing on web portal there is no problem. If i wait 60 
> seconds, when i re-clicked on my pane the message appairs
>
>
>  There has been an Error!
>
> Reason:
>
>      org.apache.jetspeed.om.profile.ProfileException: 
> org.apache.jetspeed.services.security.RoleException: Failed to 
> retrieve role 'responsable': 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:1858)
>     at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2270)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2693)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1532)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
>     at com.mysql.jdbc.Connection.execSQL(Connection.java:2273)
>     at com.mysql.jdbc.Connection.setAutoCommit(Connection.java:493)
>     at 
> org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:415)

>
>     at 
> org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:489)

>
>     at 
> org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:458)

>
>     at 
> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743)
>     at org.apache.torque.Torque.getConnection(Torque.java:306)
>     at 
> org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
>     at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1365)
>     at 
> org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelectVillageRecords(BaseTurbineRolePeer.java:366)

>
>     at 
> org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelectVillageRecords(BaseTurbineRolePeer.java:334)

>
>     at 
> org.apache.jetspeed.om.security.turbine.BaseTurbineRolePeer.doSelect(BaseTurbineRolePeer.java:303)

>
>     at 
> org.apache.jetspeed.services.security.turbine.TurbineRoleManagement.getRole(TurbineRoleManagement.java:522)

>
>     at 
> org.apache.jetspeed.services.security.JetspeedRoleManagement.getRole(JetspeedRoleManagement.java:212)

>
>     at 
> org.apache.jetspeed.services.JetspeedSecurity.getRole(JetspeedSecurity.java:397) 
>
>     at 
> org.apache.jetspeed.services.profiler.JetspeedProfilerService.fallbackProfile(JetspeedProfilerService.java:436)

>
>     at 
> org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:245)

>
>     at 
> org.apache.jetspeed.services.profiler.JetspeedProfilerService.getProfile(JetspeedProfilerService.java:528)

>
>     at org.apache.jetspeed.services.Profiler.getProfile(Profiler.java:87)
>     at 
> org.apache.jetspeed.modules.actions.JetspeedAccessController.doPerform(JetspeedAccessController.java:74)

>
>     at org.apache.turbine.modules.Action.perform(Action.java:87)
>     at 
> org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:122)
>     at org.apache.turbine.Turbine.doGet(Turbine.java:529)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>     at 
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)

>
>     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:117) 
>
>     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:793) 
>
>     at 
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)

>
>     at 
> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571) 
>
>     at 
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644) 
>
>     at java.lang.Thread.run(Thread.java:534)
>
>
> ** END NESTED EXCEPTION **
>
>
> I have found that mysql connexion closed and jetspeed tried to use it 
> first open another connexion.
> Could you help me or any idea ?
>
>
>


-- 

________________________
Xavier Arnaudin
Analyste-Développeur Alienor 
Tel +33 (0)5 57 19 65 00
Fax +33 (0)5 57 19 65 01


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message