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

[Bo Peng]

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/