[pgpool-general: 3253] Re: Problems Connecting via AppServer
anthony at timeforge.com
Sat Nov 1 05:27:25 JST 2014
This seems to be somewhat similar to:
However, it's been 2 years since this was last reported.
I've gone through that thread, and checked all of those suggested settings
- still no luck.
email Anthony at TimeForge.com
*We value your feedback. Please take a moment to complete our brief
customer satisfaction survey
help us continue to improve our operations.*
On Fri, Oct 31, 2014 at 3:02 PM, Anthony Presley <anthony at timeforge.com>
> Hi all!
> We've been using pgpool-ii for nearly 3 years, successfully, and we love
> However, we're having some very, very strange issues when attempting to
> use Tomcat 6.x or 7.x to connect to pgpool.
> We currently use PG 9.0, and native binary and WAL replication.
> Specifically, our current set up looks like:
> AppServer1,2,3 -> pgpool -> db1, db2
> We currently send 100% of the reads to db2, and use db1 for inserts only.
> pgpool runs on port 5433.
> We've started deploying new appservers, and have found that they do not
> all connect to the pgpool instance. No change in Tomcat version (we've
> tried both Tomcat 6.x and 7.x), and using the same JDBC drivers.
> I can connect to pgpool, using psql, from these machines - and it works
> However, when I start Tomcat, it hangs forever trying to connect to pgpool.
> I can connect to pgpool using psql, from those machines - to port 5433 -
> without problems. So, I'm assuming it's not a firewall / network problem.
> In trying to decode the problem, we set up a second pgpool, on one of the
> problematic machines - and continued having the same problem.
> We then upgraded to this pgpool:
> FINE: Instantiating driver using class: org.postgresql.Driver
> Oct 28, 2014 12:51:17 AM org.apache.tomcat.jdbc.pool.PooledConnection
> FINE: Unable to connect to database.
> org.postgresql.util.PSQLException: The connection attempt failed.
> Caused by: java.io.EOFException
> at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:274)
> ... 93 more
> Any ideas?
> Anthony Presley
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general