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

Sushil Shirodkar sushilps at hotmail.com
Wed Mar 12 12:22:45 JST 2025


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


More information about the pgpool-general mailing list