Hi Mythreyi,
Sorry for the late reply, I missed that one in my mailbox.
I am testing the use of sequoia as a middleware component between a
web application running on Apache Tomcat5.5.7 and MSSQL Server using a
single db configuration.(load balancer and scheduler). (BackEndDriver-
Microsoft's JDBC Type 4 driver-- SQLServerDriver)
The rest of the configuration has the default values intact
When running the above setup,In storedprocedure calls, i am getting
errors of this kind..
...Error during command execution: Stored Procedure <id>failed Query
<queryid> is not in the list of currently scheduled queries..
There are probably other errors before that caused the transaction to be
aborted. A use case to reproduce the issue would be welcome.
I have inspected the sourcecode and found that in
VirtualDatabaseWorkerThread.java, for procedures that are not
read-only, a method call "setRequestParameters" is repeated in 2 places
if(!proc.isReadOnly)
logTransactionBegin(proc)
...
and later in setRequestParametersAndTransactionStarted(proc)
However the scheduler re-assigns an id incremented only by one..
I feel that this could be the cause of the mismatch..
These calls are performed before going to the scheduler so once the
query has been scheduled, the id will not change anymore. There is
probably some top level issue that prevents the query to be properly
scheduled and generates this error message.
Don't hesitate to send us a more detailed report of the errors you are
seeing on the controller and/or a use case to reproduce the issue.
Thanks for your interest in Sequoia,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
