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

Josh Berkus josh at agliodbs.com
Fri Oct 25 09:48:56 JST 2013

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.

More information about the pgpool-general mailing list