Hi, I could reproduce the problem. I have fixed it.
Could you try CVS HEAD? % cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/pgpool login <Enter> % cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot/pgpool checkout pgpool-II Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] From: Yoshiyuki Asaba <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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 > [EMAIL PROTECTED] > > > > > > > Regards, > > > > ashada > > Yoshiyuki Asaba <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > > > > > --------------------------------- > > Looking for last minute shopping deals? Find them fast with Yahoo! Search. > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
