[pgpool-hackers: 4119] Re: Failover on starting up

[anirudh.goel at cern.ch]

I have attached both, logs and conf file.
On 6 Feb 2022, 2:46 AM +0100, Tatsuo Ishii <ishii at sraoss.co.jp>, wrote:
> Have you enabled health check?
> Can you share pgpool.conf?
>
> > But that’s the issue - pgpool didn’t perform a failover.
> >
> > It just said this and then gave up:
> > 2022-02-04 16:48:53: pid 9: LOG: ignoring the failover request, since we are still starting up
> > On 6 Feb 2022, 2:32 AM +0100, Tatsuo Ishii <ishii at sraoss.co.jp>, wrote:
> > > But after starting up pgpool will detect that the primary went down by
> > > health check and perform failover anyway, no?
> > >
> > > > Thank you Tatsuo for your reply but can’t pgpool setup the other resources regardless of the primary being up and then perform the failover?
> > > >
> > > > I need this behaviour because I cannot pgpool in cluster mode due to infrastructure limitations.
> > > >
> > > > Cheers
> > > >
> > > > Anirudh
> > > > On 6 Feb 2022, 1:51 AM +0100, Tatsuo Ishii <ishii at sraoss.co.jp>, wrote:
> > > > > > Hello
> > > > > >
> > > > > > I have a setup with 1 pgpool and 2 postgresql primary-replica nodes.
> > > > > >
> > > > > > I am testing a certain scenario - what if the pgpool goes down, then the primary goes down and then the pgpool comes back up.
> > > > > >
> > > > > > I was expecting that pgpool would perform a failover after it comes back up but instead it says this:
> > > > > > 2022-02-04 16:48:53: pid 9: LOG: Pgpool-II parent process has received failover request
> > > > > > 2022-02-04 16:48:53: pid 9: LOG: ignoring the failover request, since we are still starting up
> > > > > >
> > > > > > So my question is, is there a parameter or some way that we can tell pgpool to perform a failover if the primary is down while pgpool is starting up?
> > > > > >
> > > > > > I tried looking at the code but according to https://github.com/pgpool/pgpool2/blob/master/src/main/pgpool_main.c#L1329, I don¢t see a parameter other than processState.
> > > > > >
> > > > > > Is there a logical reason why pgpool cannot/won't perform a failover during startup?
> > > > >
> > > > > Because pgpool needs to setup various resouses including shared memory
> > > > > and others for managing failover.
> > > > >
> > > > > Best reagards,
> > > > > --
> > > > > 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.pgpool.net/pipermail/pgpool-hackers/attachments/20220206/33363fb8/attachment-0001.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: log.txt
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20220206/33363fb8/attachment-0001.txt>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 44532 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20220206/33363fb8/attachment-0001.obj>