Thank you David. On the master side I had idle-in-transaction-session
set to 10 minutes so I did alter role bucardo to set it to 0 as suggested.
Jeff Ross
[email protected]
On 2020-03-31 09:14, David Christensen wrote:
On Mar 31, 2020, at 9:08 AM, Jeff Ross <[email protected]> wrote:
FATAL: terminating connection due to idle-in-transaction timeout
Well, this sounds like *a* potential issue (not necessarily *the* issue). What
do you have the idle_in_transaction_session_timeout parameter set to? If it’s
particularly low, (read: lower than some rate of changes) you could end up in a
situation where the CTL connection terminates like you display, and then bets
are off.
I would not expect this to be a persistent issue (i.e., a Bucardo restart
should reestablish these connections and pick up where it left off).
If you need the idle_in_transaction_session_timeout behavior, at the very
least, you could alter the “bucardo” user to disable this GUC for that user.
HTH,
David
--
David Christensen
Senior Software and Database Engineer
End Point Corporation
[email protected]
785-727-1171
--
The contents of this e-mail and any attachments are intended solely for the
use of the named addressee(s) and may contain confidential and/or
privileged information. Any unauthorized use, copying, disclosure, or
distribution of the contents of this e-mail is strictly prohibited by the
sender and may be unlawful. If you are not the intended recipient, please
notify the sender immediately and delete this e-mail.
_______________________________________________
Bucardo-general mailing list
[email protected]
https://bucardo.org/mailman/listinfo/bucardo-general
