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

[David Christensen]

Anything in the PostgreSQL logs around this time?
--
David Christensen
Senior Software and Database Engineer
End Point Corporation
david at endpoint.com
785-727-1171


> On Mar 31, 2020, at 10:42 AM, Jeff Ross <rossj at cargotel.com> wrote:
> 
> Not sure that's going to help--or maybe this is another issue.
> 
> Getting this in the logs now:
> 
> (18916) [Tue Mar 31 11:37:32 2020] KID (load_sync) Warning! Aborting due to exception for metro.load_events:? Error was CTL request
> (18916) [Tue Mar 31 11:37:32 2020] KID (load_sync) Kid has died, error is: CTL request Line: 4997
> (24401) [Tue Mar 31 11:37:32 2020] KID (load_sync) Warning! Aborting due to exception for metro.load:? Error was CTL request
> (24401) [Tue Mar 31 11:37:32 2020] KID (load_sync) Kid has died, error is: CTL request Line: 4997
> 
> 
> bucardo status shows it moved on from the load table to the load_events table but I don't think the load table ever synced back up.
> 
> 
> Jeff Ross
> rossj at cargotel.com
> 
> On 2020-03-31 09:32, Jeff Ross wrote:
>> 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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: Message signed with OpenPGP
URL: <https://bucardo.org/pipermail/bucardo-general/attachments/20200402/33274e2b/attachment.sig>