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

[takehiro wada]

Hi
This porblem occurs in 2.6.9-67, 2.6.26-2 and 2.6.38-8 of Linux Kernels of
Redhat, Debian and Ubuntu without depending on operating mode of pgpool as
far as I confirmed.
On our production environment, this problem occurs, operating mode of pgpool
is streaming replication.

My pgpool.conf of testcase is below.

pgpool.conf
--------------------------------------------
pid_file_name       = '/var/run/pgpool/pgpool.pid'
port                = 10000
backend_hostname0   = 'localhost'
backend_port0       = 5432
--------------------------------------------

thanks

2011/7/7 Tatsuo Ishii <ishii at sraoss.co.jp>

> I have tried with your shell script with pgpool-II CVS HEAD. Between
> 16:56 and 17:26, about 30k SELECTs have been executed so far. As you
> can see RSS was growing from 1904 to 1912 but VSZ remained unchanged
> 23208. Thus I think there's no memory leaking.  Pgpool-II is operated
> in streaming replication mode. This is Linux kernel 2.6.27. What mode
> are you operating? What platform are you using?
>
> Thu Jul  7 16:56:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1904 ?      S    ?          0:03
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:01:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1904 ?      S    ?          0:04
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:06:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1908 ?      S    ?          0:05
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:11:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1908 ?      S    ?          0:06
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:16:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1908 ?      S    ?          0:07
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:21:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1908 ?      S    ?          0:08
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> Thu Jul  7 17:26:43 JST 2011
> F   UID   PID  PPID PRI  NI    VSZ   RSS WCHAN  STAT TTY        TIME
> COMMAND
> 1    48 29388 29356  20   0  23208  1912 ?      S    ?          0:09
> pgpool: t-ishii postgres 127.0.0.1(46350) idle
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>



-- 
*************************
Name:Takehiro Wada
mail:takehiro.wada at gmail.com
*************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110708/2cbde475/attachment.html>