[pgpool-general: 335] Re: Random Connection Failures and processes in status D

[DonMartio]

I built a rpm using the newes codebase of 3.1.2 but i got the same issue.
We have done some load tests on our webapp and after a few minutes we got
D processes as well.

The client_idle_limit does not change anything.
Doesn't pgpool check for dead conenctions? It appears that our php-loops
die infrequently because of memory issues.  This leads to a Fatal error 
which means no
destructor is called and therefore the connections won't close regularly.

Any suggestions or hints where to look?

Greetings
Martin


On 30.03.2012 09:57, DonMartio wrote:
> Hello again,
>
> since i can't find similiar issues except this one:
>
> http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg02458.html
>
> i think it's somehow my fault. I'll do some trial and error with the 
> config params.
> The client_idle_limit may is helpfull here even if the client is not 
> connected anymore.
> Just for proper understanding. Does this mean that a client is 
> disconnected even if
> there is running an 'expensive query'?
>
> Greetings
> Martin
>
> Am 29.03.2012 17:21, schrieb DonMartio:
>> Hello,
>>
>> we are evaluating pgpool the first time because we hit a serious 
>> connection Problem
>> (Increasing virtual xen maschines leads to increasing max_connections).
>> Running 2 Postres 9 Instances for failover reasons we thought it 
>> would be a good idea
>> to run pgpool in master slave mode.
>>
>> First tests ran well but we recognized a serious increase of loadavg 
>> on the pgpool maschine.
>> The reason is an increasing count of pgpool processes running in 
>> status D.
>> Netstat tells us that they are in CLOSE_WAIT. We can't kill them. We 
>> have to
>> restart pgpool.
>>
>> What ist going wrong here?
>> Any hint appreciated
>>
>> Greetings so far
>> Martin
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general