Hi Emmanuel, It is working properly now. I only put "persistentConnection=true" on the JDBC url. And, I also changed MySQL to use 1hour idle time. For example, "set global connect_timeout=3600". Then, the errors were gone. Thank you very much.
On Wed, Feb 25, 2009 at 6:55 PM, Emmanuel Cecchet <[email protected]>wrote: > Hi > > No, I haven't heard about the persistent connection. Sorry. > So it is unlikely that your issue is related to SEQUOIA-855 since it is > related to persistent connections. > > Could you tell me how to turn on the persistent connection? Do I also > > need to setup on Sequoia's configuration files? Or, just on MySQL Server? > The persistentConnection flag is an option of the Sequoia driver (check > the driver doc). > The idle connection timeout is an option of MySQL server that closes > connections that have been idle for too long. > > Hope this helps, > Emmanuel > > > > > > > > > On Tue, Feb 24, 2009 at 7:58 AM, Emmanuel Cecchet > > <[email protected] <mailto:[email protected]>> wrote: > > > > Hi, > > > > Are you really using persistent connections? > > Is there any reason why you did leave the connection timeout in your > > MySQL server configuration? > > > > Thanks for your feedback, > > Emmanuel > > > > > I am running Sequoia 2.10.10 with distributed virtual databases > > across > > > two controllers; backends are MySQL 5.1.30. > > > The reason why I send this is that I could still see the same error > > > fixed in 2.10.5 from 2.10.10. > > > Is there any one who knows about this issue? Thanks very much in > > advance. > > > > > > > > > Stephane Giron closed SEQUOIA-855: > > > ---------------------------------- > > > > > > Resolution: Fixed > > > Fix Version: (was: Sequoia 2.10.5) > > > > > > (was: Sequoia 3.0 beta3) > > > sequoia 2.10.10 > > > > > > Fixed in 2.10 branch > > > > > > > Long idled persistent connections can see exceptions when > > sending a new > > > > request to MySQL > > > > > > > > > > ---------------------------------------------------------------------------------------- > > > > > > > > Key: SEQUOIA-855 > > > > URL: https://forge.continuent.org/jira/browse/SEQUOIA-855 > > > > > > > Project: Sequoia > > > > Type: Bug > > > > > > > Components: Core > > > > Versions: Sequoia 3.0 beta1, Sequoia 2.10.2 > > > > Reporter: Stephane Giron > > > > Assignee: Stephane Giron > > > > Priority: Critical > > > > > > > Fix For: sequoia 2.10.10 > > > > > > > > > > > > > > > If a client gets a persistent connection to sequoia against > > MySQL (or other > > > > databases that drop connection after an idle timeout), and > > does not execute > > > > > > > queries against it for a long time, it will see an exception > > if the > > > > connection was closed by the underlying database. > > > > Trace of this kind of error : > > > > > > org.continuent.sequoia.common.exceptions.driver.DriverSQLException: > > Message > > > > > > > of cause: No enabled backend to execute request 5 > > > > at > > > > > > > org.continuent.sequoia.driver.Connection.statementExecuteQuery(Connection.java:2849) > > > > at > > > > > > > org.continuent.sequoia.driver.Statement.executeQuery(Statement.java:468) > > > > > > > at > > > > > > > org.continuent.sequoia.driver.Statement.executeQuery(Statement.java:441) > > > > Caused by: > > > > > > > org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException: > > > > No enabled backend to execute request 5 > > > > > > > SerializableStackTrace of each cause: > > > > > > > org.continuent.sequoia.common.exceptions.driver.protocol.ControllerCoreException: > > > > No enabled backend to execute request 5 > > > > at > > > > > > > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.executeLPRF(RAIDb1_LPRF.java:207) > > > > > > > at > > > > > > > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1_LPRF.execSingleBackendReadRequest(RAIDb1_LPRF.java:96) > > > > at > > > > > > > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecuteQuery(RAIDb1.java:160) > > > > > > > at > > > > > > > org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:592) > > > > at > > > > > > > org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(DistributedRequestManager.java:1351) > > > > > > > at > > > > > > > org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteStatementExecuteQuery.java:95) > > > > at > > > > > > > org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:157) > > > > > > > at > > > > > > > org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:335) > > > > at > > > > > > > org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) > > > > > > > > > > > > > > > > > > -- > > > 여호와는 네게 복을 주시고 너를 지키시기를 원하며 > > > 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 > > > 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 > > > (민수기 6:24-26) > > > > > > ------------------------------------------------------------------------ > > > > > > _______________________________________________ > > > Sequoia mailing list > > > [email protected] > > <mailto:[email protected]> > > > https://forge.continuent.org/mailman/listinfo/sequoia > > > > > > -- > > Emmanuel Cecchet > > FTO @ Frog Thinker > > Open Source Development & Consulting > > -- > > Web: http://www.frogthinker.org > > email: [email protected] <mailto:[email protected]> > > Skype: emmanuel_cecchet > > > > _______________________________________________ > > Sequoia mailing list > > [email protected] > > <mailto:[email protected]> > > https://forge.continuent.org/mailman/listinfo/sequoia > > > > > > > > > > -- > > 여호와는 네게 복을 주시고 너를 지키시기를 원하며 > > 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 > > 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 > > (민수기 6:24-26) > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Sequoia mailing list > > [email protected] > > https://forge.continuent.org/mailman/listinfo/sequoia > > > -- > Emmanuel Cecchet > FTO @ Frog Thinker > Open Source Development & Consulting > -- > Web: http://www.frogthinker.org > email: [email protected] > Skype: emmanuel_cecchet > > _______________________________________________ > Sequoia mailing list > [email protected] > https://forge.continuent.org/mailman/listinfo/sequoia > -- 여호와는 네게 복을 주시고 너를 지키시기를 원하며 여호와는 그 얼굴을 네게 비추사 은혜 베푸시기를 원하며 여호와는 그 얼굴을 네게로 향하여 드사 평강 주시기를 원하노라 (민수기 6:24-26)
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
