[pgpool-general: 3870] Problem with ABORT and DISCARD ALL querys in idle

[Anthony Sotolongo]

Hi to all, Sorry for my english, the problem:

I am using  pgpool with  postgresql streaming replication
Versions
-pgpool-II version 3.4.1 (tataraboshi) (http://www.pgpool.net/mediawiki/images/pgpool-II-3.4.1.tar.gz)
-postgresql PostgreSQL 9.3.9

Have in pgpool.conf
                      

-client_idle_limit = 300
-reset_query_list = 'ABORT; DISCARD ALL'

I use to prevent that some client exceed 5 min(client_idle_limit), and pgpool can close the connect with client, but pgpool no close the connect with (ABORT or DISCARD ALL querys),
when i execute on master or slave:
select pid,state,xact_start,query_start,state_change,query  from pg_stat_activity;

i get:

pid  | state  |          xact_start           |
     query_start          |         state_change
     |                                       query

                                        

------+--------+-------------------------------+-------------------------------+-------------------------------+-------------------------------------------------

     -----------------------------------

      4351 | idle   |                               | 2015-07-13
     09:57:11.52977-03  | 2015-07-13 09:57:11.530004-03 |  DISCARD ALL

      4601 | idle   |                               | 2015-07-13
     10:21:36.21236-03  | 2015-07-13 10:21:36.212696-03 |  DISCARD ALL

      4184 | idle   |                               | 2015-07-13
     09:43:12.427339-03 | 2015-07-13 09:43:12.428155-03 |  DISCARD ALL

      4457 | idle   |                               | 2015-07-13
     10:06:24.988995-03 | 2015-07-13 10:06:24.98923-03  |  DISCARD ALL

      5936 | active | 2015-07-13 12:18:59.426768-03 | 2015-07-13
     12:18:59.426768-03 | 2015-07-13 12:18:59.426775-03 | select
     pid,state,xact_start,query_start,state_ch

     ange,query  from pg_stat_activity;

      4193 | idle   |                               | 2015-07-13
     09:47:37.27413-03  | 2015-07-13 09:47:37.274514-03 |  DISCARD ALL

      4490 | idle   |                               | 2015-07-13
     10:06:16.192748-03 | 2015-07-13 10:06:16.19298-03  |  DISCARD ALL

      4203 | idle   |                               | 2015-07-13
     09:44:24.666702-03 | 2015-07-13 09:44:24.667234-03 |  DISCARD ALL

      4204 | idle   |                               | 2015-07-13
     09:44:24.714707-03 | 2015-07-13 09:44:24.714869-03 |  DISCARD ALL

      4205 | idle   |                               | 2015-07-13
     09:44:24.704854-03 | 2015-07-13 09:44:24.705512-03 |  DISCARD ALL

      4612 | idle   |                               | 2015-07-13
     10:28:10.681199-03 | 2015-07-13 10:28:10.681419-03 | ABORT

      4613 | idle   |                               | 2015-07-13
     10:31:20.242776-03 | 2015-07-13 10:31:20.243073-03 |  DISCARD ALL

      4614 | idle   |                               | 2015-07-13
     10:17:02.001256-03 | 2015-07-13 10:17:02.001493-03 |  DISCARD ALL

      4618 | idle   |                               | 2015-07-13
     10:21:36.722948-03 | 2015-07-13 10:21:36.723194-03 |  DISCARD ALL

      4619 | idle   |                               | 2015-07-13
     10:17:29.934837-03 | 2015-07-13 10:17:29.93506-03  |  DISCARD ALL

      4624 | idle   |                               | 2015-07-13
     10:17:39.546724-03 | 2015-07-13 10:17:39.546923-03 |  DISCARD ALL

     (16 filas)

     



Ignoring client_idle_limit, and keep the connection, i was reading in previous emails ,that it was fixed,
i have only 16  idle connection, but in the future will be more :(

How can this issue be solved?

Greetings



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150713/1013261e/attachment.htm>