[Pgpool-general] memory leak in PgPool II when load is high.

[Yoshiyuki Asaba]

Hi,

From: Ashada Karunaratna <csc_slpa at yahoo.com>
Subject: Re: [Pgpool-general] memory leak in PgPool II when load is high.
Date: Thu, 27 Dec 2007 22:37:38 -0800 (PST)

>   Thank you for the reply. The program I am evaluating uses set of
>   web services and it cannot be easily execute without properly
>   setting up the system which may take many hours. This program was
>   running without any issue with Postgres directly for years by
>   now. This system connects to the PgPool controller via a
>   PoolingDataSource() and it should runs for days without restarting
>   the service. Program get the DB connections from the pool using
>   "getConnection()" method of PoolingDataSource and release it with
>   close() method of connection. This way it reuses the connections
>   that were created ealier.

Can you show us a sample program using PoolingDataSource?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp



>    
>   Regards,
>    
>   ashada
> Yoshiyuki Asaba <y-asaba at sraoss.co.jp> wrote:
>   Hi,
> 
> From: Ashada Karunaratna 
> Subject: [Pgpool-general] memory leak in PgPool II when load is high.
> Date: Thu, 27 Dec 2007 21:16:31 -0800 (PST)
> 
> > However during the evaluation process I could notice that some of PgPool child processes started using very high amount of memory suddenly( more thatn 70 Mb by a process ) causing Linux system to crash due to Swapping. I have below listed an output of Top command sorted by "%Mem" field to provide better understanding on the issue. Acutely I cannot understand why each pgpool process is consuming so much memory. Whole pgpool processes set consumes more memory than Postgres DB at the moment
> 
> Could you provide a reproducible program?
> 
> Regards,
> --
> Yoshiyuki Asaba
> y-asaba at sraoss.co.jp
> 
> 
>        
> ---------------------------------
> Looking for last minute shopping deals?  Find them fast with Yahoo! Search.