[pgpool-general: 7493] Re: pgpool2 in kubernetes dies

[Nikolay Mastilo (HM)]

Please help to understand why frontend clients  lose connection to 
pgpool after some idle and how can it be overcome.

Regards,
  Nikolay

09.04.2021 12:36, Nikolay Mastilo (HM) пишет:
>
> our clients are microservices running on k8s. and if they are 
> connected directly to database, the connection resume successfully.
>
> and if they are connected to pgpool, they cannot resume connection 
> after some time.
>
> some clients outside of kubernetes (for ex. pgAdmin) *cannot *resume 
> connection after some time too. but the DBeaver resumes connection 
> successfully.
>
> magic
>
> 09.04.2021 12:01, Anton Melser пишет:
>>
>>     And we have such issue - after approx 2 hours of idle our client
>>     service cannot resume connection with pgpool, we have to restart
>>     client service only that doesn't acceptable for us.
>>
>>     Could you tell why doesn't  pgpool accept requests after 2 hours
>>     of idle and what we should do?
>>
>> And you definitely don't have this with normal pgpool outside of 
>> Kubernetes and these clients? I am pretty sure I have python clients 
>> (inside the cluster) that sometimes aren't doing anything for 
>> multiple hours and they stay connected fine. Your clients are also 
>> inside your cluster, right?
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210412/8b93a8f5/attachment.htm>