[Bucardo-general] 5.6.0 double free in VAC on CentOS7 (continued)
Jeff Ross
rossj at cargotel.com
Tue Mar 31 15:42:44 UTC 2020
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.
More information about the Bucardo-general
mailing list