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
