<div dir="ltr">I have the same problem with PuppetDB fortend.<div>When I stop the service of PuppetDB, all connections from pgpool is CLOSE_WAIT and in DISCARD state, even with connection timeout set to 1 minute.</div><div>
here is the summery from gdb:</div><div><br></div><div>the hanged function is:</div><div>__select_no_cancel() from /lib64/libc.so.6.</div><div><br></div><div>stacktrace output:</div><div><br></div><div>0 __select_no_cancel() from /lib64/libc.so.6.<br>
</div><div>1 pool_check_fd</div><div>2 pool_read</div><div>3 read_kind_from_backend</div><div>4 ProcessBackendResponse</div><div>5 pool_process_query</div><div>6 fork_a_child()</div><div>7 reaper</div><div>8 pool_sleep</div>
<div>9 main</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jun 19, 2014 at 2:29 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">You said your developer found pgpool child process in DISCARD state.<br>
<br>
Please attach gdb to the process in DISCARD state and take<br>
backtrace. Also I need actual netsta -anp outputs.<br>
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> Hi Tatsuo,<br>
><br>
> We are facing this same problem, and as I see it remains unsolved (or<br>
> perhaps they didn't report the solution).<br>
> We are using pgpool 3.3.3, with two postgres 9.1 in streaming<br>
> replication. The OS is Debian 3.2.54-2 (64bits).<br>
><br>
> The log shows messages like this:<br>
><br>
> ProcessFrontendResponse: failed to read kind from frontend. frontend<br>
> abnormally exited<br>
><br>
> I'm not sure but it looks like one for each connection left unclosed.<br>
><br>
> Also, a ps -ef returns a lot of pgpool children in DISCARD state. And<br>
> the netstat -anp, gives the correspondent TCP connection in CLOSE_WAIT<br>
> state.<br>
><br>
> The developer has checked the client process is closing the<br>
> connections and we try connecting directly to the postgres and it<br>
> worked fine.<br>
><br>
> When you say "to attach debugger", do you mean change log_statment =<br>
> true or debug_level to a value other than 0 or any other procedure?<br>
><br>
> Many thanks,<br>
><br>
> --<br>
> Juanjo Pérez<br>
><br>
> <a href="http://www.oteara.com" target="_blank">www.oteara.com</a><br>
><br>
> El 02/04/14 01:05, Tatsuo Ishii escribió:<br>
>>> We have a client on 3.3 experiencing the the problem noted here:<br>
>>><br>
>>> <a href="http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001283.html" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/2012-December/001283.html</a><br>
>>><br>
>>> strace is showing the child processes at:<br>
>>><br>
>>> clone(child_stack=0,<br>
>>> flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD,<br>
>>> child_tidptr=0x7fcf659f3a10) = 6258<br>
>>><br>
>>> I didn't see any resolution of that issue; is there data we can gather<br>
>>> to assist?<br>
>> I followed the old 2012 posting with:<br>
>><br>
>>> That means pgpool does not close the socket connected to by your<br>
>>> applications. Is it possible to attach debugger to such that pgpool<br>
>>> process to see what pgpool is doing?<br>
>> But I got no response until now. Can you please do this?<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>> _______________________________________________<br>
>> pgpool-general mailing list<br>
>> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
>><br>
><br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div></div></blockquote></div><br></div>