[Pgpool-general] unexpected EOF on client connection

Tatsuo Ishii ishii at sraoss.co.jp
Tue Sep 13 01:39:43 UTC 2011


>> I couldn't find anything possibly related to your problem at a first
>> grance(in theory client_idle_limit and authentication_timeout are not
>> related but you might want to change them to see anything could be
>> changed).
> 
> OK, I'll give that a try.  Should I just try increasing them by 10 or 20s?

I'd suggest giving them 0. This will prevent to initiate those
functionalities which the directives are related.

Also you hve child_life_time being 300. I don't expect this is related
but could you set it to 0 and see anything gest changed for just in
case?

>> Do you have anything between pgpool and PostgreSQL? It has been
>> reported that some firewall hardware/software kills TCP connections if
>> they are idle for n seconds.
> 
> Nope, there are no firewalls, or anything else that I'm aware of
> sitting between pgpool and the database servers.

Ok.

Another possibility is, pgpool child process is dying for unknown
reason. Do you see anything bad (for example child dies segfault) in
the pgpool log?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list