[pgpool-general: 4276] Re: Pgpool - connection hangs in DISCARD ALL

[Tatsuo Ishii]

>>> It worked now for 3 days well but today I still had the same
>>> issue. Looks like the probability has been reduced, but not fixed in
>>> all cases.
>> [snip]
>>> root 1349 0.0 0.1 94248 864 ?  S 00:13 0:01 pgpool: nag hei
>>> 192.168.0.9(39886) DISCARD
>> Yeah, looks like pgpool is hanging while executing DISCARD. Assuming
>> you apply the fix in 3.4 stable tree, do you know how to reproduce the
>> problem?
> 
> Yes, patch is applied. I verified it again on the RPM build directory.
> 
> No, I don't know how to reproduce. It just happens on a production
> machine. But I attached a detailed stack trace in the previous post.

I suspect the logic for child_max_connections is not good. Can you
disable child_max_connections (i.e. child_max_connections = 0)?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp