<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Ok cool, no worries...</span></div><div><span><br></span></div><div><span>let me have a go at version 3.1.3</span></div><div><span><br></span></div><div><span>thanks</span></div><div><span><br></span></div><div><span>regards</span></div><div><br></div> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> DonMartio <donmartio@larkos.de><br> <b><span style="font-weight: bold;">To:</span></b> Jayaraj <jraj90@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> Tatsuo Ishii <ishii@postgresql.org>; "pgpool-general@pgpool.net"
<pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 18 May 2012, 16:22<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 461] Re: PgPool rejects connections<br> </font> </div> <br><div id="yiv1758448893">
<div>
Maybe there is another issue which is accidently gone<br>
with PGPool 3.1.3. It was just an assumption that our problem had
something todo <br>
with that syslog issue. However our problem was gone with
pgpool-3.1.3.<br>
<br>
Greetings<br>
Martin<br>
<br>
Am 18.05.2012 10:02, schrieb Jayaraj:
<blockquote type="cite">
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; ">
<div><span>I have already set that to sterr in the conf file</span></div>
<div><span><br>
</span></div>
<div><span>However, I am using PGPool 3.1.2</span></div>
<div><span><br>
</span></div>
<div><span>could this be a problem?</span></div>
<div><span><br>
</span></div>
<div><span>thanks</span></div>
<div><span><br>
</span></div>
<div><span>regards,</span></div>
<div><span>- jaya -</span></div>
<div><br>
</div>
<div style="font-size: 12pt; font-family: times, serif; ">
<div style="font-size: 12pt; font-family: times, serif; ">
<div dir="ltr"> <font size="2" face="Arial">
<hr size="1"> <b><span style="font-weight:bold;">From:</span></b>
DonMartio <a rel="nofollow" class="yiv1758448893moz-txt-link-rfc2396E" ymailto="mailto:donmartio@larkos.de" target="_blank" href="mailto:donmartio@larkos.de"><donmartio@larkos.de></a><br>
<b><span style="font-weight:bold;">To:</span></b>
Tatsuo Ishii <a rel="nofollow" class="yiv1758448893moz-txt-link-rfc2396E" ymailto="mailto:ishii@postgresql.org" target="_blank" href="mailto:ishii@postgresql.org"><ishii@postgresql.org></a> <br>
<b><span style="font-weight:bold;">Cc:</span></b>
<a rel="nofollow" class="yiv1758448893moz-txt-link-abbreviated" ymailto="mailto:jraj90@yahoo.com" target="_blank" href="mailto:jraj90@yahoo.com">jraj90@yahoo.com</a>; <a rel="nofollow" class="yiv1758448893moz-txt-link-abbreviated" ymailto="mailto:pgpool-general@pgpool.net" target="_blank" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a> <br>
<b><span style="font-weight:bold;">Sent:</span></b>
Friday, 18 May 2012, 15:11<br>
<b><span style="font-weight:bold;">Subject:</span></b>
Re: [pgpool-general: 461] Re: PgPool rejects connections<br>
</font> </div>
<br>
Well, this sounds familiar to me. Which version of pgpool-II
are you using?<br>
We got those CLOSE_WAIT's too during stress tests on our php
framework.<br>
They are gone since the last version 3.1.3. I assume it got
something to <br>
do with a syslog issue.<br>
May you try log_destination = 'stderr' in your pgpool.conf
just to <br>
clarify if this is the case.<br>
<br>
<br>
Am 16.05.2012 09:54, schrieb Tatsuo Ishii:<br>
> [Cced: to pgpool-general mailing list]<br>
><br>
> I'm not familiar with EC2. Anyone on this list can help
him?<br>
> --<br>
> Tatsuo Ishii<br>
> SRA OSS, Inc. Japan<br>
> English: <a rel="nofollow" target="_blank" href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a><br>
> Japanese: <a rel="nofollow" target="_blank" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a><br>
><br>
>> Hi,<br>
>><br>
>> I have been using PgPool-II for my postgres
DBs on the Amazon EC2 instances. However, I have been
experiencing some issues. After a certain period of time, it
no longer allows new connections from clients / application
to the PgPool. It seems to get stuck in a TCP CLOSE_WAIT
session. This basically accumulates to alot more which then
disallows any further connections to the PgPool.<br>
>><br>
>> So at one point I had to temporarily set all
connections directly to Postgres. The issue is resolved by
restarting PgPool. Then after a certain period of time, it
happens again, then another restart of Pgpool is required.<br>
>><br>
>> Can someone advise me how can I solve this?<br>
>><br>
>> Thanks<br>
>><br>
>> Regards,<br>
>> - Jaya -<br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a rel="nofollow" ymailto="mailto:pgpool-general@pgpool.net" target="_blank" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a rel="nofollow" target="_blank" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
<br>
</div>
</div>
</div>
</blockquote>
<br>
</div>
</div><br><br> </div> </div> </div></body></html>