[pgpool-general: 4552] show pool_nodes status - on unusual test scenario

[Shay Cohavi]

Hi,
During my tests on my pgpool setup (2 nodes is master/slave and streaming
replication), I have notice a troubled response via the pgpool server.

1. DB nodes in master/slave state (streaming replication):
# psql -U postgres -h 192.168.15.59 -p 9999 -c "show pool_nodes;"
Password for user postgres:
 node_id | hostname | port | status | lb_weight |  role
---------+----------+------+--------+-----------+---------
 0       | 1.1.1.55 | 5432 | 2      | 0.500000  | primary
 1       | 1.1.1.56 | 5432 | 2      | 0.500000  | standby
(2 rows)

2. *test scenario* --- for some reason, if the 'standby' node (1.1.1.56) is
being promoted* manually by user *(touch trigger file); the pgpool doesn't
change its state and not put it outside of the pool.....(split brain)

on 1.1.1.56:
# touch /home/postgres/databases/my_db/trigger

#  psql -U postgres -h 192.168.15.59 -p 9999 -c "show pool_nodes;"
 node_id | hostname | port | status | lb_weight |  role
---------+----------+------+--------+-----------+---------
 0 | 1.1.1.55 | 5432 | 2      | 0.500000  | primary
 1 | 1.1.1.56 | 5432 | 2      | 0.500000  | standby

Does the pgpool monitor the *standby* node after pgpool startup??



can you please advice?

Thanks,
cohavisi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160315/2f3bde64/attachment.html>