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

[Tatsuo Ishii]

> Tatsuo,
> 
> Tomcat+JDBC application connecting to PostgreSQL via pgPool II version
> 3.3.0, installed from RPM, in Master-Slave load-balancing mode
> (streaming replication, 1 replica).  pgPool query caching is turned off.
> 
> Currently we're getting repeated errors like this every few minutes on
> Tomcat: "An I/O Error occurred while sending to the backend."
> No errors show up in the PostgreSQL logs.

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?

>  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).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp