[pgpool-general: 165] Re: Fwd: Pgpool 3.1.1: possible memory leak

[Tatsuo Ishii]

I'm not sure if your pgpool.conf is actual one.

> # Port number for pgpool
> port = 127001

> # Port number for pgpool communication manager
> pcp_port = 127001

pgpool and pcp process use same port number. I don't think pgpool is
working normally with this setting...
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi to all.
> 
> Anyone? According to me it's a rather serious problem...
> 
> Thank you in advance
> 
> Denis
> 
> ----- Messaggio originale -----
>> Da: "Denis Gasparin" <denis.gasparin at edistar.com>
>> A: pgpool-general at pgpool.net
>> Inviato: Venerdì, 13 gennaio 2012 19:14:12
>> Oggetto: [pgpool-general: 153] Fwd: Pgpool 3.1.1: possible memory leak
>> Sorry... the attachment was missing in previous mail.
>> 
>> Denis
>> 
>> 
>> 
>> 
>> Da: "Denis Gasparin" <denis.gasparin at edistar.com>
>> A: pgpool-general at pgpool.net
>> Inviato: Venerdì, 13 gennaio 2012 19:11:58
>> Oggetto: [pgpool-general: 152] Pgpool 3.1.1: possible memory leak
>> 
>> 
>> 
>> 
>> Hi.
>> 
>> 
>> We're using pgpool as connection pooler and after upgrading to 3.1.1
>> we noticed a memory leak that occurs when executing several queries
>> during the same connection.
>> 
>> 
>> You can take the following bash script as example (call it
>> feed_psql.sh).
>> (test_table is a table with three integer fields).
>> 
>> 
>> #!/bin/bash
>> i=0 ;
>> while [ true ];
>> do
>> echo 'insert into test_table values ('${i}', '${i}', '${i}');'
>> i=$((i+1));
>> echo 'insert into test_table values ('${i}', '${i}', '${i}');'
>> i=$((i+1));
>> sleep 1
>> done
>> 
>> 
>> Execute it so that its standard output is sent to standard input of
>> psql:
>> 
>> 
>> 
>> # sh feed_psql.sh | psql -U edi -h /var/run -p 127001 testdb
>> 
>> 
>> As you can see, the script is sending two queries per second to a
>> postgres db using the same pgpool connection.
>> 
>> 
>> Using top we monitored the memory usage of the pgpool child process
>> and, as you can see below, after few iterations memory keeps
>> growing...
>> 
>> 
>> 
>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
>> 20442 root 20 0 12088 1140 904 S 0 0.1 0:00.01 pgpool
>> 
>> 
>> After few iterations the RES field (The non-swapped physical memory a
>> task has used) and the VIRT one grow up:
>> 
>> 
>> 
>> 
>> 
>> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
>> 20442 root 20 0 13040 2032 908 S 0 0.1 0:00.05 pgpool
>> 
>> 
>> I attached also the pgpool.conf used.
>> Pgpool is connected to a postgresql 8.2 server.
>> 
>> 
>> 
>> Could you help us, please?
>> 
>> 
>> Denis
>> 
>> 
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>> 
>> 
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general