[pgpool-general: 8570] Re: Issues taking a node out of a cluster

[Emond Papegaaij]

On Thu, Jan 26, 2023 at 11:09 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> >> Other developer suggested that health check process for backend 1 may
> >> not run in this case. (in order to make auto_failback working, health
> >> check process for the backend needs to run). Can you confirm?
> >>
> >
> >  My logs don't seem to contain anything related to health checks (other
> > than some memory allocations). How do I identify the health check
> processes?
> >
> > Best regards,
> > Emond
>
> You can use ps command.
>
> $ ps x|grep health
>  927155 pts/0    S      0:00 pgpool: health check process(0)
>  927156 pts/0    S      0:00 pgpool: health check process(1)
>
> The numbers in parentheses indicate backend id.
>

Unfortunately, we see these failures in automated tests and those instances
are no longer running. I've added some additional statements to dump a full
process tree in these tests, but it can take a few days to reproduce the
issue.

Best regards,
Emond
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230126/aa317ecd/attachment.htm>