[ https://forge.continuent.org/jira/browse/SEQUOIA-438?page=all ] Stephane Giron closed SEQUOIA-438: ----------------------------------
Closing : bug fixed > statement .execute() takes a new connection when executing in a persistent > connection > ------------------------------------------------------------------------------------- > > Key: SEQUOIA-438 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-438 > Project: Sequoia > Type: Bug > Components: Core > Versions: Sequoia 2.7 > Reporter: Stephane Giron > Assignee: Stephane Giron > Fix For: Sequoia 2.8.1 > > > In RequestManager.statementExecute and > DistributedStatementExecute.scheduleRequest, we create a fake StoredProc for > which the persistentConnection and persistentConnectionId are not set > properly. > This will lead to this kind of error. > java.sql.SQLException: stored procedure 5 failed: > Backend DB1 - BackendWorkerThread for backend 'c1b1' with RAIDb level:1 > failed (Unknown prepared statement handler (my_stmt) given to EXECUTE) > at > org.continuent.sequoia.common.exceptions.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:88) > at > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.checkTaskCompletion(RAIDb1.java:893) > at > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:801) > at > org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecute(RAIDb1.java:275) > at > org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecute(RequestManager.java:887) > at > org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecute.executeScheduledRequest(DistributedStatementExecute.java:117) > at > org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java:153) > at > org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDatabase.java:322) > at > org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://forge.continuent.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
