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
