[pgpool-general: 2217] Re: More I/O Error in Tomcat

[Tatsuo Ishii]

>> This error happens between Tomcat and pgpool.  I suspect Tomcat
>> establishes persistent connections to pgpool and pgpool disconnects it
>> because client_idle_limit is not 0. Is this your case?
> 
> Yes, that sounds likely.  If we need to disable client_idle_timeout,
> though, the number of DB connections bloats hopelessly; this is an
> application with many databases, so we end up with several idle pgPool
> connections per database.  Without client_idle_timeout, how would we
> handle this?

Why don't you turn off Tomcat side persistent connections?

>>>  As soon as the client clears
>>> them, I should be able to send you pgpool debug logs (offlist).  The
>>> problem is 100% reproduceable.
>> 
>> Please do so (along with pgpool.conf).
> 
> Let me test client_idle_timeout first.

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