Hi Emmanuel, No, I haven't heard about the persistent connection. Sorry. 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?
Thank you very much. On Tue, Feb 24, 2009 at 7:58 AM, Emmanuel Cecchet <[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] > > 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
