<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The following appeared before the failover, nothing abnormal. Similar lines in previous 1 hour of log file. </div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:01.745: child pid 2599666: LOG: new connection received</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:01.745: child pid 2599666: DETAIL: connecting host=[local]</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:01.807: child pid 2600001: LOG: new connection received</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:01.808: child pid 2600001: DETAIL: connecting host=[local]</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:03.000: main pid 2598786: LOG: reaper handler</div>
<div class="elementToProof" style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2025-03-12 01:35:03.001: main pid 2598786: LOG: reaper handler: exiting normally</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Bo Peng <pengbo@sraoss.co.jp><br>
<b>Sent:</b> Tuesday, March 11, 2025 11:42 PM<br>
<b>To:</b> Sushil Shirodkar <sushilps@hotmail.com><br>
<b>Cc:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> Re: [pgpool-general: 9393] Pgpool - Failing over from Primary to Secondary for unknown reason.</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hi,<br>
<br>
To figure out the cause of the failover, please check the<br>
Pgpool-II logs right before the failover occurred.<br>
Did any error occur?<br>
<br>
On Wed, 12 Mar 2025 03:22:45 +0000<br>
Sushil Shirodkar <sushilps@hotmail.com> wrote:<br>
<br>
> <br>
> Hello all,<br>
> <br>
> 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.<br>
> <br>
> TS_SERVER pid 2600121 LOG-received degenerate backend request for node_id- 0 from pid 2600121<br>
> <br>
> Env:<br>
> Pgpool-II => 4.5.2<br>
> Postgres => 16.4<br>
> Ubuntu => 22.04.4<br>
> <br>
> Would be helpful if you folks share your thoughts on the above.<br>
> <br>
> <br>
> Thanks,<br>
> Sushil....<br>
<br>
<br>
-- <br>
Bo Peng <pengbo@sraoss.co.jp><br>
SRA OSS K.K.<br>
TEL: 03-5979-2701 FAX: 03-5979-2702<br>
URL: <a href="https://www.sraoss.co.jp/">https://www.sraoss.co.jp/</a><br>
</div>
</span></font></div>
</body>
</html>