George Elefter [02/01/08 14:22]:
[...] Because of a
wrong sql query passed from the application a pending request is placed
in the queue. Correcting this at the application level is not feasible
now. We want to go with the next db write ignoring the pending one.
Means that the sql error query execution should be terminated by the
sequoia level and not keep it pending write and blocking the successive
request. Is this one handled in any of the Sequoia version including
beta. We are using 2.10.9.
Hi George,
would "abort transaction" be of any use to you ? This is a command you can
issue from the command-line console to brutally kill transactions.
You may also wish to have a look at the following urls:
http://article.gmane.org/gmane.comp.db.sequoia.general/4919/match=abort+transaction
https://forge.continuent.org/jira/browse/SEQUOIA-895
https://forge.continuent.org/jira/browse/SEQUOIA-903
A+O.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
