[pgpool-general: 3162] Memory leaks

[Anselme Rabouan]

Hi,

We have a pgpool cluster in streaming replication mode, under the latest
3.3.4 version.
One of the pgpool child processes has a memory load which is rising about
1GB per 12 hours.
I noticed that it is always the same application / query that brings about
a such behavior.
As a result, a "ps" command render something like:
...
postgres  5861    0.0  0.0  91496     1260 ?        S    14:18   0:00
pgpool: postgres mydb 192.168.1.2(57029) idle
postgres  5862    0.0  0.0  91496     1260 ?        S    14:18   0:00
pgpool: postgres mydb  192.168.1.2(57020) idle
postgres  20640  0.2  0.0  91496     1436 ?        S    Sep11  15:32
pgpool: postgres mydb  192.168.1.2(56340) idle
*postgres  27435 0.5 39.9 1874960 1618096 ?    *S    Sep14   7:53 pgpool:
postgres mydb  192.168.1.2(50879) idle
...

And "psql -U postgres -x -c 'select backend_start, query_start,
state_change, waiting, state, query from pg_stat_activity where pid =2824'"
gives:
-[ RECORD 1 ]-+------------------------------
backend_start | 2014-09-14 15:11:34.13042+01
query_start   | 2014-09-15 *14:28:34*.207835+01
state_change  | 2014-09-15 *14:28:34*.208433+01
waiting       | f
state         | idle
query         | select 1

The same, but one minute later gives:
-[ RECORD 1 ]-+------------------------------
backend_start | 2014-09-14 15:11:34.13042+01
query_start   | 2014-09-15 *14:29:34*.292283+01
state_change  | 2014-09-15 *14:29:34*.292839+01
waiting       | f
state         | idle
query         | select 1

and so on...

You'll find as attachments, the pgpool configuration file and the log part
about the suspected pgpool child process.

Hope you could help me,

Anselme
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140915/aafd0096/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 31047 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140915/aafd0096/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool-proccess-having-memory-load-rising-logs
Type: application/octet-stream
Size: 11990 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140915/aafd0096/attachment-0003.obj>