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

[Bill Moran]

In response to Ashada Karunaratna <csc_slpa at yahoo.com>:
> 
> 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?
>    
>   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.


I believe you misunderstood Yoshiyuki's question.  Without a reproducible
test case, it's unlikely that anyone will be able to help you.  If you
want to help fix this, you're going to have to provide a lot more
detail, and a program that reproduces the problem is the easiest way to
do so.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran at collaborativefusion.com
Phone: 412-422-3463x4023