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

[Sushil Shirodkar]

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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20250312/ccd875e9/attachment.htm>