<div dir="ltr">Can this be following configuration?<div><br>client_idle_limit = 0<br> # Client is disconnected after being idle for that many seconds<br> # (even inside an explicit transactions!)<br> # 0 means no disconnection<br><div><br></div><div>Regards<br>Umar Hayat</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Apr 12, 2021 at 2:26 AM Nikolay Mastilo (HM) <<a href="mailto:nikm71@hotmail.com">nikm71@hotmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Please help to understand why frontend clients lose connection
to pgpool after some idle and how can it be overcome. <br>
</p>
<pre cols="72">Regards,
Nikolay</pre>
<div>09.04.2021 12:36, Nikolay Mastilo (HM)
пишет:<br>
</div>
<blockquote type="cite">
<p>our clients are microservices running on k8s. and if they are
connected directly to database, the connection resume
successfully. <br>
</p>
<p>and if they are connected to pgpool, they cannot resume
connection after some time.</p>
<p>some clients outside of kubernetes (for ex. pgAdmin) <b>cannot
</b>resume connection after some time too. but the DBeaver
resumes connection successfully.</p>
<p>magic<br>
</p>
<div>09.04.2021 12:01, Anton Melser пишет:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>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.</p>
<p>Could you tell why doesn't pgpool accept requests
after 2 hours of idle and what we should do?</p>
</div>
</blockquote>
<div>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? </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<blockquote type="cite">
<div dir="ltr">
<div dir="ltr">
<div class="gmail_quote"> </div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</blockquote>
</div>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div>