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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
