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

[Yoshiyuki Asaba]

Valgrind may help. Can you try the following steps?

1. Set num_init_children to 1 in pgpool.conf
2. Launche pgpool with valgrind
  $ valgrind --leak-check=full pgpool -n -d -f pgpool.conf >>
valgrind.log  2>&1
3. Run your script
4. Stop pgpool

Thanks,

2011/7/8 takehiro wada <takehiro.wada at gmail.com>:
> 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
> *************************
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>



-- 
Yoshiyuki Asaba
ysyk.asaba at gmail.com