[pgpool-general: 4012] Children: DISCARD status

Mephysto mephystoonhell at gmail.com
Fri Aug 28 22:42:38 JST 2015 

Hi there,
I am using pgpool-II 3.4.3, PosgreSQL 9.4.4 and Glassfish 4.1 on linux
Debian 7.8 and I have a serious problem with connection: it happens that
all child processes goes in DISCARD status and pgpool is frozen: it does
not accept new connections and not respond to shutdown command. The only
way to restart pgpool is restarting the entire server.

This is output of ps command:


postgres  9180  8304  0 12:19 pts/0    00:00:00 pgpool -n -d
postgres  9181  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50224)
DISCARD
postgres  9182  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50755)
DISCARD
postgres  9183  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49924)
DISCARD
postgres  9184  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50229)
DISCARD
postgres  9185  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(52830)
DISCARD
postgres  9186  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50231)
DISCARD
postgres  9187  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50191)
DISCARD
postgres  9188  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50189)
DISCARD
postgres  9189  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50453)
DISCARD
postgres  9190  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50227)
DISCARD
postgres  9191  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49925)
DISCARD
postgres  9192  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50186)
DISCARD
postgres  9193  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50188)
DISCARD
postgres  9194  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50448)
DISCARD
postgres  9195  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50196)
DISCARD
postgres  9196  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50190)
DISCARD
postgres  9197  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50451)
DISCARD
postgres  9198  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50192)
DISCARD
postgres  9199  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49928)
DISCARD
postgres  9200  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49927)
DISCARD
postgres  9201  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50445)
DISCARD
postgres  9202  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49929)
DISCARD
postgres  9203  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50447)
DISCARD
postgres  9204  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50753)
DISCARD
postgres  9205  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50184)
DISCARD
postgres  9206  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50228)
DISCARD
postgres  9207  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50450)
DISCARD
postgres  9208  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(52831)
DISCARD
postgres  9209  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(49931)
DISCARD
postgres  9210  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50230)
DISCARD
postgres  9211  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50225)
DISCARD
postgres  9212  9180  0 12:19 pts/0    00:00:00 pgpool: aptredevo
redevolution host64-122-dynamic.52-79-r.retail.telecomitalia.it(50223)
DISCARD
postgres  9213  9180  0 12:19 pts/0    00:00:00 pgpool: PCP: wait for
connection request
postgres  9214  9180  0 12:19 pts/0    00:00:01 pgpool: worker process



I tried to manage client_idle_limit and connection_life_time parameters in
pgpool.conf, but I was not lucky.


Can you help me to avoid this critical situation, please?

Thanks in advance.


Mephysto
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150828/1a659aea/attachment.html>

More information about the pgpool-general mailing list