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 > Sequoia@lists.forge.continuent.org > https://forge.continuent.org/mailman/listinfo/sequoia -- Emmanuel Cecchet FTO @ Frog Thinker Open Source Development & Consulting -- Web: http://www.frogthinker.org email: m...@frogthinker.org Skype: emmanuel_cecchet _______________________________________________ Sequoia mailing list Sequoia@lists.forge.continuent.org https://forge.continuent.org/mailman/listinfo/sequoia
