Thanks, Stephane. The abort transaction command can be useful. It's
already implemented in my version of Sequoia (2.10.5), but it wasn't
docummented. I've also created a JIRA issue concerning the console.ini
file and debug commands.
Regards,
Diego.
Stephane GIRON escribió:
Hello Diego,
I think you will be interested in reading :
https://forge.continuent.org/jira/browse/SEQUOIA-895
https://forge.continuent.org/jira/browse/SEQUOIA-898
which would have helped you when you met your problems. This could
help you to stop a transaction that prevents the system from shutting
down (or executing a administration task)
Thank you for your feedback,
Stephane
Diego a écrit :
I forgot to add, I'm using Sequoia 2.10.5.
Diego escribió:
Hi. I have two Sequoia controllers running a virtual database with
one PostgreSQL backend each. I was trying to perform a backup from
the administrative console, when I received this message multiple
times:
sequoia.controller.scheduler Waiting for 2 open transactions
It turned out that my web app had a bug where two database
connections where never closed. The problem is that when that
message appeared, all operations where blocked, and subsequent
attempts of beginning a transaction failed with this message:
controller.virtualdatabase.inteco Begin failed (Timeout in begin,
still waiting for 2 pending transactions to complete)
The bug on my web app is now fixed, but for fear of other bugs that
could lead to more unclosed connections, I would like to know if
there is a way to perform a forced backup or, even better, a way to
specify a timeout after which, if there are still open transactions,
cancel the backup attempt. I tried with the "dumpTimeout" option in
PostgreSQLPlainTextBackuper with no luck.
Thanks in advance.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
