[pgpool-general: 3253] Re: Problems Connecting via AppServer

[Anthony Presley]

This seems to be somewhat similar to:
  http://www.sraoss.jp/pipermail/pgpool-general/2012-August/000899.html

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.

--
Anthony Presley
email    Anthony at TimeForge.com

office    866-684-7191

TimeForge
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/7e2a60fce227ee043aeb6bd5d968ebf1?ytl=http%3A%2F%2Fwww.timeforge.com%2F>
  |  Blog
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/f3a3eb6c198570d1f7b8f5d5491c67ed?ytl=http%3A%2F%2Fwww.timeforge.com%2Fsite%2Fblog%2F>
  |  Facebook
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/ad572ed1cb342a159a2c17a18eb4ff22?ytl=http%3A%2F%2Fwww.facebook.com%2Ftimeforgelabor>
 |  Twitter
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/7c08dd1b3543cd277aaaa7e3bd687003?ytl=http%3A%2F%2Fwww.twitter.com%2Ftimeforge>
  |  Pinterest
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/4dfca117df1521ded24b48b5903dadc9?ytl=http%3A%2F%2Fwww.pinterest.com%2Ftimeforge%2F>
  |  App
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/ca255ad2d9b6010cf982c7eda916ab03?ytl=http%3A%2F%2Fwww.timeforge.com%2Fsite%2Fproducts%2Fmobile-app%2F>


*We value your feedback. ​​Please take a moment to complete our brief
customer satisfaction survey
<https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/f80c0b722731dfdbe97a1c8665bdf9be?ytl=https%3A%2F%2Fwww.surveymonkey.com%2Fs%2FYTJSCC9>
to
help us continue to improve our operations.*

On Fri, Oct 31, 2014 at 3:02 PM, Anthony Presley <anthony at timeforge.com>
wrote:

> Hi all!
>
> We've been using pgpool-ii for nearly 3 years, successfully, and we love
> it.
>
> 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
> perfectly.
>
> 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:
>   pgpool-II-93-devel-3.3.2-1.rhel6.x86_64
>
> FINE: Instantiating driver using class: org.postgresql.Driver
> [url=jdbc:postgresql://localhost:5433/scheduler?useUnicode=true&characterEncoding=utf-8]
> Oct 28, 2014 12:51:17 AM org.apache.tomcat.jdbc.pool.PooledConnection
> connectUsingDriver
> 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)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:269)
>         at
> org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:106)
>         ... 93 more
>
> Any ideas?
>
>
> --
> Anthony Presley
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141031/2bcd3e95/attachment.html>