<div dir="ltr"><div><div style>Hi Muhammad,</div><div style><br></div><div style>I asked to the developer team about that.</div><div style>They said me that the related client application is using its own pooling system.</div><div style>It sends a "SELECT 1;" query to pgpool every minute once the job is over.</div><div style>As a result, pgpool process never disconnects the backend.</div><div style>Then, we can see this pgpool child process is never released and we have a memory leak of about 1GB per 12 hours so I have to kill it manually.</div><div style><br></div><div style>I know we should not use pooling system on the application side anymore because we now have a pgpool cluster.</div><div style>Nevertheless, I would know how to set up pgpool in order to be got rid of such memory leaks.</div><div style><br></div>Thanks,<font face="arial, sans-serif"> </font></div><div><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><strong>Anselme Rabouan | Software Developer | Lifecycle Software Ltd</strong></div><div style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">T: 0203 0028304</div><div style="color:rgb(136,136,136);font-family:arial,sans-serif;background-color:rgb(255,255,255)"><img src="http://www.lifecycle-software.com/uploads/webimages/logo2.gif" width="96" height="42"><br><font size="1">NOTICE<br>This e-mail (including any attachments) is confidential and is intended for the above-named person(s). If you are not the intended recipient, please notify the sender immediately and delete this email from your system and do not disclose or use for any purpose.</font><br></div></div></div>
<br><div class="gmail_quote">On 18 September 2014 16:56, Muhammad Usama <span dir="ltr"><<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Anselme<br>
<br>
I have been looking into this issue, but unable to reproduce the<br>
memory leak, Can you please share more details on what kind of<br>
application and queries are causing this issue.<br>
<br>
Kind Regards<br>
Usama<br>
<div><div class="h5"><br>
<br>
On Mon, Sep 15, 2014 at 6:39 PM, Anselme Rabouan<br>
<<a href="mailto:anselme.rabouan@lifecycle-software.com">anselme.rabouan@lifecycle-software.com</a>> wrote:<br>
> Hi,<br>
><br>
> We have a pgpool cluster in streaming replication mode, under the latest<br>
> 3.3.4 version.<br>
> One of the pgpool child processes has a memory load which is rising about<br>
> 1GB per 12 hours.<br>
> I noticed that it is always the same application / query that brings about a<br>
> such behavior.<br>
> As a result, a "ps" command render something like:<br>
> ...<br>
> postgres 5861 0.0 0.0 91496 1260 ? S 14:18 0:00<br>
> pgpool: postgres mydb 192.168.1.2(57029) idle<br>
> postgres 5862 0.0 0.0 91496 1260 ? S 14:18 0:00<br>
> pgpool: postgres mydb 192.168.1.2(57020) idle<br>
> postgres 20640 0.2 0.0 91496 1436 ? S Sep11 15:32 pgpool:<br>
> postgres mydb 192.168.1.2(56340) idle<br>
> postgres 27435 0.5 39.9 1874960 1618096 ? S Sep14 7:53 pgpool:<br>
> postgres mydb 192.168.1.2(50879) idle<br>
> ...<br>
><br>
> And "psql -U postgres -x -c 'select backend_start, query_start,<br>
> state_change, waiting, state, query from pg_stat_activity where pid =2824'"<br>
> gives:<br>
> -[ RECORD 1 ]-+------------------------------<br>
> backend_start | 2014-09-14 15:11:34.13042+01<br>
> query_start | 2014-09-15 14:28:34.207835+01<br>
> state_change | 2014-09-15 14:28:34.208433+01<br>
> waiting | f<br>
> state | idle<br>
> query | select 1<br>
><br>
> The same, but one minute later gives:<br>
> -[ RECORD 1 ]-+------------------------------<br>
> backend_start | 2014-09-14 15:11:34.13042+01<br>
> query_start | 2014-09-15 14:29:34.292283+01<br>
> state_change | 2014-09-15 14:29:34.292839+01<br>
> waiting | f<br>
> state | idle<br>
> query | select 1<br>
><br>
> and so on...<br>
><br>
> You'll find as attachments, the pgpool configuration file and the log part<br>
> about the suspected pgpool child process.<br>
><br>
> Hope you could help me,<br>
><br>
> Anselme<br>
><br>
><br>
</div></div>> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
><br>
</blockquote></div><br></div>