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

[Mariel Cherkassky]

No, I didnt check the status via "show pool_nodes". To be honest it isnt
the first time it happens. Does there a difference between show_pool_nodes
and pcp_node info on the deeper level ? I mean I know that show_pool_nodes
queries a view or a table, what about pcp_node_info ? I dont think that it
is related to repmgr..

2018-05-06 16:49 GMT+03:00 Tatsuo Ishii <ishii at sraoss.co.jp>:

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180506/2fc034f9/attachment.html>