<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
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
cite="mid:1337328140.80020.YahooMailNeo@web113104.mail.gq1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff; font-family:times
new roman, new york, times, serif;font-size:12pt">
<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 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 <a class="moz-txt-link-rfc2396E" href="mailto:donmartio@larkos.de"><donmartio@larkos.de></a><br>
<b><span style="font-weight: bold;">To:</span></b>
Tatsuo Ishii <a class="moz-txt-link-rfc2396E" href="mailto:ishii@postgresql.org"><ishii@postgresql.org></a> <br>
<b><span style="font-weight: bold;">Cc:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:jraj90@yahoo.com">jraj90@yahoo.com</a>; <a class="moz-txt-link-abbreviated" 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 moz-do-not-send="true"
href="http://www.sraoss.co.jp/index_en.php"
target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
> Japanese: <a moz-do-not-send="true"
href="http://www.sraoss.co.jp" target="_blank">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 moz-do-not-send="true"
ymailto="mailto:pgpool-general@pgpool.net"
href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a moz-do-not-send="true"
href="http://www.pgpool.net/mailman/listinfo/pgpool-general"
target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
<br>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>