<div dir="ltr">There aren't any pgpool errors, and we continue to be very, very frustrated with the set up. It's extremely confusing to me ... because we've been using pgpool for years (4+) without any issues. Recently, in the past 2 - 4 weeks, we've begun seeing very strange problems:</div><div dir="ltr"><br></div><div dir="ltr">A) While our same 3 computers / hosts can connect reliably, no other host can. When other hosts attempt, they often hang / lock up the pgpool server, and we have to restart pgpool. I do not understand why only these 3 systems can connect. I don't believe it's a network issue, as I can connect from the command line on any of our other servers - so PostgreSQL is allowing the connections. This is version 3.1.3</div><div dir="ltr"><br></div><div dir="ltr">B) We set up a clean environment on a separate network, using pgpool and master/slave postgres, and it appears that when Tomcat connects, using the tomcat7 pooling, so that we are looking at:</div><div dir="ltr"><div> Tomcat -> Tomcat pool -> pgpool -> postgresql</div><div>We start having problems .... randomly. Sometimes we can connect. Sometimes we cannot connect.</div><div><br></div><div>The only errors I've been able to generate are the one I sent with the earlier stack trace, and no error is present in the PG or pgpool logs.</div><div><br></div><div>I'm rather stumped at this point.</div><div><br><img src="https://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/a294f62640fe8bddd6308f28c4de868d/spacer.gif" style="border:0px;width:0px;min-height:0px" width="0" height="0"><img src="http://t.yesware.com/t/bcbf2eb3a62359f40a40b4dc8b5023d159817a5b/a294f62640fe8bddd6308f28c4de868d/spacer.gif" style="border:0px;width:0px;min-height:0px" width="0" height="0"><font face="yw-bcbf2eb3a62359f40a40b4dc8b5023d159817a5b-a294f62640fe8bddd6308f28c4de868d--tob"></font></div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div><span style="font-size:13px;background-color:rgb(255,255,255)">--<br>Anthony Presley<u><br></u></span></div></div></div></div></div>
<br><br>-- <br><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><br>