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

[Yoshiyuki Asaba]

Hi,

I could reproduce the problem. I have fixed it.

Could you try CVS HEAD?

  % cvs -d :pserver:anonymous at cvs.pgfoundry.org:/cvsroot/pgpool login
  <Enter>
  % cvs -d :pserver:anonymous at cvs.pgfoundry.org:/cvsroot/pgpool checkout pgpool-II

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

From: Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
Subject: Re: [Pgpool-general] memory leak in PgPool II when load is high.
Date: Fri, 04 Jan 2008 18:13:26 +0900 (JST)

> 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.
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general