<div dir="ltr">This seems to be somewhat similar to:<div> <a href="http://www.sraoss.jp/pipermail/pgpool-general/2012-August/000899.html">http://www.sraoss.jp/pipermail/pgpool-general/2012-August/000899.html</a></div><div><br></div><div>However, it's been 2 years since this was last reported.</div><div><br></div><div>I've gone through that thread, and checked all of those suggested settings - still no luck.</div><div><img src="https://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/f4d4f997e86c6a0776072c2abbaa1f52/spacer.gif" style="border: 0px; width: 0px; height: 0px;" width="0" height="0"><img src="http://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/f4d4f997e86c6a0776072c2abbaa1f52/spacer.gif" style="border: 0px; width: 0px; height: 0px;" width="0" height="0"><font face="yw-bcbf2eb3a62359f40a40b4dc8b5023d159817a5b-f4d4f997e86c6a0776072c2abbaa1f52--tob" style></font></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><span style="font-size:13px;background-color:rgb(255,255,255)">--<br>Anthony Presley<u><br></u></span><a value="+18666847191"></a><div style="display:inline!important"><a value="+18666847191"><font face="arial, helvetica, sans-serif"><font color="#ff9900">email </font></font></a><font face="arial, helvetica, sans-serif"><a href="mailto:Anthony@TimeForge.com" style="color:rgb(17,85,204)" target="_blank">Anthony@TimeForge.com</a></font></div><br style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"></div><div><a value="+18666847191" style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"></a><div><a value="+18666847191" style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><font face="arial, helvetica, sans-serif"><font color="#ff9900">office </font><font color="#444444"></font></font></a><font face="arial, helvetica, sans-serif"><font color="#444444"><a value="+18666847191" style="color:rgb(17,85,204)">866-684-7191</a></font></font></div><div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif"><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/7e2a60fce227ee043aeb6bd5d968ebf1?ytl=http%3A%2F%2Fwww.timeforge.com%2F" style="color:rgb(17,85,204)" target="_blank">TimeForge</a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900">|</font><span style="color:rgb(80,0,80)"> </span><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/f3a3eb6c198570d1f7b8f5d5491c67ed?ytl=http%3A%2F%2Fwww.timeforge.com%2Fsite%2Fblog%2F" style="color:rgb(17,85,204)" target="_blank">Blog</a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900">| </font><span style="color:rgb(80,0,80)"> </span><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/ad572ed1cb342a159a2c17a18eb4ff22?ytl=http%3A%2F%2Fwww.facebook.com%2Ftimeforgelabor" style="color:rgb(17,85,204)" target="_blank">Facebook </a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900">| </font><span style="color:rgb(80,0,80)"> </span><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/7c08dd1b3543cd277aaaa7e3bd687003?ytl=http%3A%2F%2Fwww.twitter.com%2Ftimeforge" style="color:rgb(17,85,204)" target="_blank">Twitter</a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900"> | </font><span style="color:rgb(80,0,80)"> </span><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/4dfca117df1521ded24b48b5903dadc9?ytl=http%3A%2F%2Fwww.pinterest.com%2Ftimeforge%2F" style="color:rgb(17,85,204)" target="_blank">Pinterest</a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900"> | </font><span style="color:rgb(80,0,80)"> </span><a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/ca255ad2d9b6010cf982c7eda916ab03?ytl=http%3A%2F%2Fwww.timeforge.com%2Fsite%2Fproducts%2Fmobile-app%2F" style="color:rgb(17,85,204)" target="_blank">App</a><span style="color:rgb(80,0,80)"> </span><font color="#ff9900"> </font><br></font></div><div><br></div><div><b><font color="#666666">We value your feedback. Please take a moment to complete <a href="https://t.yesware.com/tl/cffec98422cd0346abb13689bf956cce5a15bf38/e0cc04102d138ed2a95497fedfdffc2c/f80c0b722731dfdbe97a1c8665bdf9be?ytl=https%3A%2F%2Fwww.surveymonkey.com%2Fs%2FYTJSCC9" style="color:rgb(17,85,204)" target="_blank">our brief customer satisfaction survey</a> to help us continue to improve our operations.</font></b></div></div></div></div></div>
<br><div class="gmail_quote">On Fri, Oct 31, 2014 at 3:02 PM, Anthony Presley <span dir="ltr"><<a href="mailto:anthony@timeforge.com" target="_blank">anthony@timeforge.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi all!</div><div><br></div><div>We've been using pgpool-ii for nearly 3 years, successfully, and we love it.</div><div><br></div><div>However, we're having some very, very strange issues when attempting to use Tomcat 6.x or 7.x to connect to pgpool.</div><div><br></div><div>We currently use PG 9.0, and native binary and WAL replication.</div><div><br></div><div>Specifically, our current set up looks like:</div><div> AppServer1,2,3 -> pgpool -> db1, db2<br></div><div><br></div><div>We currently send 100% of the reads to db2, and use db1 for inserts only.</div><div><br></div><div>pgpool runs on port 5433.</div><div><br></div><div>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.</div><div><br></div><div>I can connect to pgpool, using psql, from these machines - and it works perfectly.</div><div><br></div><div>However, when I start Tomcat, it hangs forever trying to connect to pgpool.</div><div><br></div><div>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.</div><div><br></div><div>In trying to decode the problem, we set up a second pgpool, on one of the problematic machines - and continued having the same problem.</div><div><br></div><div>We then upgraded to this pgpool:</div><div> pgpool-II-93-devel-3.3.2-1.rhel6.x86_64</div><div><br></div><div><div>FINE: Instantiating driver using class: org.postgresql.Driver [url=jdbc:postgresql://localhost:5433/scheduler?useUnicode=true&characterEncoding=utf-8]</div><div>Oct 28, 2014 12:51:17 AM org.apache.tomcat.jdbc.pool.PooledConnection connectUsingDriver</div><div>FINE: Unable to connect to database.</div><div>org.postgresql.util.PSQLException: The connection attempt failed.</div></div><div>.....</div><div>.....</div><div><div>Caused by: java.io.EOFException</div><div> at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:274)</div><div> at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:269)</div><div> at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:106)</div><div> ... 93 more</div></div><div><br></div><div>Any ideas?</div><div><br></div><br clear="all"><div><div><div dir="ltr"><span style="font-size:13px;background-color:rgb(255,255,255)">--<br>Anthony Presley</span></div></div></div><font face="yw-bcbf2eb3a62359f40a40b4dc8b5023d159817a5b-b93efa24f1baf7164c2ace03e3f9d743--tob"></font><img src="https://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/b93efa24f1baf7164c2ace03e3f9d743/spacer.gif" style="border:0;width:0px;min-height:0px" width="0" height="0"><img src="http://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/b93efa24f1baf7164c2ace03e3f9d743/spacer.gif" style="border:0;width:0px;min-height:0px" width="0" height="0"></div>
</blockquote></div><br></div>