<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Thank you for the reply.</p>
<p>client_idle_limit is already set to 0, but clients still lose
connection.</p>
<p>Can there be an impact that pgpool is running in k8s ?<br>
</p>
<p><br>
</p>
<pre class="moz-signature" cols="72">Regards,
Nikolay
</pre>
<div class="moz-cite-prefix">12.04.2021 8:53, Umar Hayat пишет:<br>
</div>
<blockquote type="cite" cite="mid:CACnGOt13d-jPL5CeVX4qhPLoJFxcVgVgL=GXv8BFWV0LBH=hpQ@mail.gmail.com">
<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" moz-do-not-send="true">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" moz-do-not-send="true">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote>
</div>
</blockquote>
</body>
</html>