[pgpool-general: 9396] Re: Pgpool - Failing over from Primary to Secondary for unknown reason.

[Bo Peng]

Hi,

Thank you for sharing the logs.

The information related to failover was not output in these logs.
Could you share more logs related to the process with PID 2600121?

On Wed, 12 Mar 2025 03:57:56 +0000
Sushil Shirodkar <sushilps at hotmail.com> wrote:

> The following appeared before the failover, nothing abnormal.  Similar lines in previous 1 hour of log file.
> 
> 2025-03-12 01:35:01.745: child pid 2599666: LOG:  new connection received
> 2025-03-12 01:35:01.745: child pid 2599666: DETAIL:  connecting host=[local]
> 2025-03-12 01:35:01.807: child pid 2600001: LOG:  new connection received
> 2025-03-12 01:35:01.808: child pid 2600001: DETAIL:  connecting host=[local]
> 2025-03-12 01:35:03.000: main pid 2598786: LOG:  reaper handler
> 2025-03-12 01:35:03.001: main pid 2598786: LOG:  reaper handler: exiting normally
> ________________________________
> From: Bo Peng <pengbo at sraoss.co.jp>
> Sent: Tuesday, March 11, 2025 11:42 PM
> To: Sushil Shirodkar <sushilps at hotmail.com>
> Cc: pgpool-general at pgpool.net <pgpool-general at pgpool.net>
> Subject: Re: [pgpool-general: 9393] Pgpool - Failing over from Primary to Secondary for unknown reason.
> 
> Hi,
> 
> To figure out the cause of the failover, please check the
> Pgpool-II logs right before the failover occurred.
> Did any error occur?
> 
> On Wed, 12 Mar 2025 03:22:45 +0000
> Sushil Shirodkar <sushilps at hotmail.com> wrote:
> 
> >
> > Hello all,
> >
> > We have 3 servers env. Pgpool + Master/Slave on AWS,  for some reason Pgpool  thinks Master is down and promotes Slave as Read/Write.   Log file on Pgpool shows the below mentioned message during the failover.  We had failure thrice in a single day so far today on this production env.  with diff.  pids, nothing changed in last couple of months.
> >
> > TS_SERVER pid 2600121 LOG-received degenerate backend request for node_id- 0 from pid 2600121
> >
> > Env:
> > Pgpool-II => 4.5.2
> > Postgres => 16.4
> > Ubuntu   => 22.04.4
> >
> > Would be helpful if you folks share your thoughts on the above.
> >
> >
> > Thanks,
> > Sushil....
> 
> 
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS K.K.
> TEL: 03-5979-2701 FAX: 03-5979-2702
> URL: https://www.sraoss.co.jp/


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/