[Bucardo-general] 5.6.0 double free in VAC on CentOS7 (continued)

[Jeff Ross]

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
rossj at cargotel.com

On 2020-03-31 09:14, David Christensen wrote:
>> On Mar 31, 2020, at 9:08 AM, Jeff Ross <rossj at cargotel.com> 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
> david at endpoint.com
> 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.