[Pgpool-general] pgpool-II-3.0.3and4 memory leaks

[Tatsuo Ishii]

I am not familiar with Python and am not sure what kind of queries are
actually sent. How long did it take before observing the memory leak?
minutes? hours? days?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> I'm using pgpool-II-3.0.3 and I have a memory problem of pgpool-II-3.0.3.
> -------
> $ ps uaxww | grep i18n_generic_search
>  postgres 11188  0.0 40.0 3722712 2452996 ?     S    Jun20   7:54 pgpool:
> postgres postgres 127.0.0.1(49676) idle
> * physical memory is used 2GB the above process.
> -------
> 
> I have been looking into the problem by creating a testcase.
>>From the testcase, what I found is that the mount of used memory keeps
> growing while an application executes SQLs in the period that the
> application is connecting to pgpool.
> Have you had any similar case so far?
> 
> testcase
> --------------------
> import psycopg2
> import time
> import sys
> 
> try:
>     connection = psycopg2.connect( database='postgres',
>                                    user='postgres'    ,
>                                    host='127.0.0.1'   , << pgpool server's
> host
>                                    port='10000'       , << pgpool server's
> port
>                                    password='postgres')
> except:
>     print ("Could Not connect to PostgreSQL or pgpool Server")
> 
> ### main ###
> cursor = connection.cursor()
> 
> while 1:
>   cursor.execute("select datname from pg_database")
>   rows = cursor.fetchall()
>   time.sleep(0.1)
> 
> cursor.close()
> connection.close()
> 
> exit()
> --------------------