[pgpool-general: 1137] Aborts when reach num_init_children

[Emanuel Calvo]

I have a script that loop in a sequence from 1 to x number of
connections for pgbench. When reachs 33 (num_init_children=32 on the
pgpool) it starts to fail:

[root at ip-10-55-83-238 ~]# time ./tests.sh
Client 14 aborted in state 2. Probably the backend died while processing.
Client 7 aborted in state 2. Probably the backend died while processing.
Client 16 aborted in state 2. Probably the backend died while processing.
Client 4 aborted in state 2. Probably the backend died while processing.
Client 21 aborted in state 2. Probably the backend died while processing.
Client 10 aborted in state 2: ERROR:  portal "" does not exist
Client 17 aborted in state 2. Probably the backend died while processing.
Client 16 aborted in state 2. Probably the backend died while processing.
Client 1 aborted in state 2: ERROR:  unnamed prepared statement does not exist
Client 7 aborted in state 2: ERROR:  unnamed prepared statement does not exist
Client 12 aborted in state 2: ERROR:  unnamed prepared statement does not exist


Then, all the processes keep the connection but idle:

pgpool server:
root     18880 18728  0 18:31 ?        00:00:01 pgpool: postgres
postgres 10.55.83.238(58270) idle
root     18881 18728  0 18:31 ?        00:00:01 pgpool: postgres
postgres 10.55.83.238(58271) idle
root     18882 18728  0 18:31 ?        00:00:01 pgpool: postgres
postgres 10.55.83.238(58275) idle
root     18883 18728  0 18:31 ?        00:00:01 pgpool: postgres
postgres 10.55.83.238(58280) idle
root     18884 18728  0 18:31 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58268) idle
root     18885 18728  0 18:32 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58278) idle
root     18886 18728  0 18:32 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58291) idle
root     18887 18728  0 18:32 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58292) idle
root     18888 18728  0 18:32 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58264) idle
root     18889 18728  0 18:32 ?        00:00:00 pgpool: postgres
postgres 10.55.83.238(58289) idle


master:
19386 ?        Ss     0:00  \_ postgres: postgres postgres
46.51.180.111(34558) idle
19387 ?        Ss     0:00  \_ postgres: postgres postgres
46.51.180.111(34561) idle
19388 ?        Ss     0:00  \_ postgres: postgres postgres
46.51.180.111(34564) idle
19389 ?        Ss     0:00  \_ postgres: postgres postgres
46.51.180.111(34567) idle


If I try to connect to pgpool, obviously the server directly doesn't respond.

I can provide later some debug output, but I need to know if I'm not
the only one.


-- 
--
Emanuel Calvo