[pgpool-general: 471] Re: PgPool rejects connections

[DonMartio]

Ok, i'm curious if this will solve your problem.
If so... hurray.. if not it will be interesting if there is a problem 
regarding
EC2. What kind of App do you have? Java, php, ruby?

Greetings so far
Martin


Am 18.05.2012 12:14, schrieb Jayaraj:
> Ok cool, no worries...
>
> let me have a go at version 3.1.3
>
> thanks
>
> regards
>
> ------------------------------------------------------------------------
> *From:* DonMartio <donmartio at larkos.de>
> *To:* Jayaraj <jraj90 at yahoo.com>
> *Cc:* Tatsuo Ishii <ishii at postgresql.org>; "pgpool-general at pgpool.net" 
> <pgpool-general at pgpool.net>
> *Sent:* Friday, 18 May 2012, 16:22
> *Subject:* Re: [pgpool-general: 461] Re: PgPool rejects connections
>
> Maybe there is another issue which is accidently gone
> with PGPool 3.1.3. It was just an assumption that our problem had 
> something todo
> with that syslog issue. However our problem was gone with pgpool-3.1.3.
>
> Greetings
> Martin
>
> Am 18.05.2012 10:02, schrieb Jayaraj:
>> I have already set that to sterr in the conf file
>>
>> However, I am using PGPool 3.1.2
>>
>> could this be a problem?
>>
>> thanks
>>
>> regards,
>> - jaya -
>>
>> ------------------------------------------------------------------------
>> *From:* DonMartio <donmartio at larkos.de> <mailto:donmartio at larkos.de>
>> *To:* Tatsuo Ishii <ishii at postgresql.org> <mailto:ishii at postgresql.org>
>> *Cc:* jraj90 at yahoo.com <mailto:jraj90 at yahoo.com>; 
>> pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net>
>> *Sent:* Friday, 18 May 2012, 15:11
>> *Subject:* Re: [pgpool-general: 461] Re: PgPool rejects connections
>>
>> Well, this sounds familiar to me. Which version of pgpool-II are you 
>> using?
>> We got those CLOSE_WAIT's too during stress tests on our php framework.
>> They are gone since the last version 3.1.3. I assume it got something to
>> do with a syslog issue.
>> May you try log_destination = 'stderr' in your pgpool.conf just to
>> clarify if this is the case.
>>
>>
>> Am 16.05.2012 09:54, schrieb Tatsuo Ishii:
>> > [Cced: to pgpool-general mailing list]
>> >
>> > I'm not familiar with EC2. Anyone on this list can help him?
>> > --
>> > Tatsuo Ishii
>> > SRA OSS, Inc. Japan
>> > English: http://www.sraoss.co.jp/index_en.php
>> > Japanese: http://www.sraoss.co.jp
>> >
>> >> Hi,
>> >>
>> >>      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.
>> >>
>> >> 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.
>> >>
>> >> Can someone advise me how can I solve this?
>> >>
>> >> Thanks
>> >>
>> >> Regards,
>> >> - Jaya -
>> > _______________________________________________
>> > pgpool-general mailing list
>> > pgpool-general at pgpool.net <mailto:pgpool-general at pgpool.net>
>> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>>
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120518/99d719e1/attachment.html>