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

[Josh Berkus]

On 10/24/2013 05:22 PM, Tatsuo Ishii wrote:
>>> 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?

I can check on that as an option.  Might not be feasible.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com