<html><body><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000"><div data-marker="__QUOTED_TEXT__"><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000;" data-mce-style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000;"><div>Hi,<br></div><br><div>I have a strange behavior with pgpool 3.7.2 and I can't figure out where it is coming from. This is the situation:<br></div><br><div>I have three nodes with watchdog configuration:<br></div><br><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">192.168.22.34: pgpool + postgres</span><br></div><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">192.168.22.35: pgpool + postgres</span></div><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">192.168.22.36: pgpool</span></div><br><br><div>The current status:<br></div><br><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">postgres@pgpool2:/home/postgres/ [PG1] alias pgpshownodes </span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">alias pgpshownodes='psql -h ${PGPOOLNODEVIP} -p ${PGPOOLNODEPORT} -f ${DMK_HOME}/sql/show_pgp_nodes.sql postgres'</span><br></div><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">postgres@pgpool2:/home/postgres/ [PG1] pgpshownodes <br> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replicatio<br>---------+---------------+------+--------+-----------+---------+------------+-------------------+-----------<br> 0 | 192.168.22.34 | 5433 | up | 0.500000 | standby | 0 | false | 0<br> 1 | 192.168.22.35 | 5433 | up | 0.500000 | primary | 0 | true | 0<br>(2 rows)<br></span><br></div><div>Why does pcp_node_info show both instances as standby?<br></div><br><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">postgres@pgpool2:/home/postgres/ [PG1] alias pgpnodeinfo</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">alias pgpnodeinfo='${PGPOOLHOME}/bin/pcp_node_info -h ${DMK_HOME}/tmp/ -w'</span><br></div><div><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">postgres@pgpool2:/home/postgres/ [PG1] pgpnodeinfo -n 1 --verbose</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Hostname : 192.168.22.35</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Port : 5433</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Status : 1</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Weight : 0.500000</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Status Name: waiting</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Role : standby</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">postgres@pgpool2:/home/postgres/ [PG1] pgpnodeinfo -n 0 --verbose</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Hostname : 192.168.22.34</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Port : 5433</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Status : 1</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Weight : 0.500000</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Status Name: waiting</span><br><span style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;" data-mce-style="font-family: 'courier new', courier, monaco, monospace, sans-serif; font-size: 10pt;">Role : standby</span><br></div><br><div>Any hints appreciated.<br></div><div>Regards<br></div><div>Daniel<br></div><br></div></div></div></body></html>