[pgpool-general: 6071] Re: primary suddenly is down only in pgpool

[Tatsuo Ishii]

> Hi,
> I have 3 postgres servers (one primary + 2 standbys) that have replciation
> configured with repmgr:
> pg1 - standby
> pg2 - primary
> pg3 - standby
> 
> I have also 2 pgpool servers(v 3.7.2 and on each one there is one pool
> instance. There isnt any watchdog, instead I have a vip address that
> directs the requests to the available pgpool instance. I configured my own
> metrics that check the status of the database nodes via the pcp interface.
> 
> Today at 11:25 suddenly I got an alert that both my pgpools saw that the
> primary node is down (via pcp). I connected and checked and indeed the
> primary was down :
> [postgres at pool2 log]$ pcp_node_info -h localhost -U postgres -p 9898 1 -w
> pg2 5432 2 0.333333 down standby
> 
> I checked it in both pools and the same result. I immediatly attached them
> and it worked. I wanted to understand why it happened but I dont see any
> error in the logs. I attach the logs of both my pools. Can you help me
> identify the problem ?

No idea. I have never seen PostgreSQL is detached without any trace in
pgpool log. Have you seen the node status using "show pool_nodes"? If
not, I suspect there's a bug with pcp_node_info. If you tried "show
pool_nodes" and saw the same status as pcp_node_info, then I
completely lose idea.

There may be a interaction with repmgr, but I am not familiar with
repmgr and this is just a wild guess.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp