[pgpool-general: 1338] pgpool - attach node - double number of connection

Witold Duranek witold.duranek at esky.pl
Wed Jan 23 21:48:14 JST 2013


Hello,

 

I'm using pgpool:

pgpool-II version 3.1.1 (hatsuiboshi)

 

in mode:

 

master_slave_mode = on

master_slave_sub_mode = 'stream'

 

when i detach slave node from pgpool and attach it again the numer of
connection to postgresql on master doubles. Half of them is set earlier and
not use any more. 

 

tcp        0      0 127.0.0.1:44293         127.0.0.1:5433
ESTABLISHED 26720/pgpool: wait

tcp        0      0 127.0.0.1:44662         127.0.0.1:5433
ESTABLISHED 26720/pgpool: wait

 

in log I have got

 

Do not restart children because we are failbacking node id 0

 

num_init_children = 25

max_pool = 1

child_life_time = 300

child_max_connections = 0

connection_life_time = 0

client_idle_limit = 0

 

when i change child_max_connections to 200, after 200 connection the new
child occupy only one connection.

 

Is it normal situation ? 

 

Best regards 

witalis 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130123/8b5243fd/attachment.html>


More information about the pgpool-general mailing list