<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>its a Ruby</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, 18:27<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 461] Re: PgPool rejects connections<br>
</font> </div> <br><div id="yiv749174583">
<div>
Ok, i'm curious if this will solve your problem.<br>
If so... hurray.. if not it will be interesting if there is a
problem regarding<br>
EC2. What kind of App do you have? Java, php, ruby?<br>
<br>
Greetings so far<br>
Martin<br>
<br>
<br>
Am 18.05.2012 12:14, 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>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, 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="yiv749174583moz-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>
Jayaraj <a rel="nofollow" class="yiv749174583moz-txt-link-rfc2396E" ymailto="mailto:jraj90@yahoo.com" target="_blank" href="mailto:jraj90@yahoo.com"><jraj90@yahoo.com></a> <br>
<b><span style="font-weight:bold;">Cc:</span></b>
Tatsuo Ishii <a rel="nofollow" class="yiv749174583moz-txt-link-rfc2396E" ymailto="mailto:ishii@postgresql.org" target="_blank" href="mailto:ishii@postgresql.org"><ishii@postgresql.org></a>;
<a rel="nofollow" class="yiv749174583moz-txt-link-rfc2396E" ymailto="mailto:pgpool-general@pgpool.net" target="_blank" href="mailto:pgpool-general@pgpool.net">"pgpool-general@pgpool.net"</a>
<a rel="nofollow" class="yiv749174583moz-txt-link-rfc2396E" 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, 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="yiv749174583">
<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, 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="yiv749174583moz-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="yiv749174583moz-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="yiv749174583moz-txt-link-abbreviated" ymailto="mailto:jraj90@yahoo.com" target="_blank" href="mailto:jraj90@yahoo.com">jraj90@yahoo.com</a>;
<a rel="nofollow" class="yiv749174583moz-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>
</blockquote>
<br>
</div>
</div><br><br> </div> </div> </div></body></html>