<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 style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Any updates on this? I have turned of SSL for replication, but I'm still getting errors on the health check. It's happening at least once a week right now.</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<div>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><b><font color="#000000"><font size="2" style="font-size:10pt">Jon Schewe</font></font></b></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font size="2" style="font-size:9pt">Principal Software Systems Technologist</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font color="#c00000"><font size="2" style="font-size:9pt"><b><br>
</b></font></font></font><font color="#000000"><font size="2" style="font-size:9pt">C: +1 612.263.2718<br>
</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#000000"><font size="2" style="font-size:9pt">O: +1 952.545.5720</font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font color="#0563c1"><font size="2"><u>jon.schewe@raytheon.com</u></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-top:0.08in; margin-bottom:0.11in; line-height:100%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font color="#c00000"><font size="2" style="font-size:9pt"><span lang="fr-BE"><b><br>
</b></span></font></font></font><font color="#000000"><font color="#ce1126"><font size="2" style="font-size:10pt"><span lang="fr-BE"><b>Raytheon BBN</b></span></font></font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">Raytheon Intelligence & Space</font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">5775 Wayzata Blvd. Suite 630</font></font></font></font></p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#000000"><font size="2" style="font-size:9pt">St. Louis Park, MN 55416</font></font></font></font>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:110%">
<br>
</p>
<p style="margin-top:0px; margin-bottom:0px; margin-bottom:0in; line-height:120%">
<font face="Arial, serif"><font size="3" style="font-size:12pt"><font color="#0563c1"><u><a href="https://www.rtx.com/" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">RTX.com</font></font></a></u></font><font color="#000000"><font color="#000000"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://www.linkedin.com/company/raytheontechnologies" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">LinkedIn</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://twitter.com/raytheontech" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">Twitter</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font><font color="#ce1126"><font size="2" style="font-size:9pt">|</font></font><font color="#ce1126"><font size="1" style="font-size:8pt">
</font></font><font color="#0563c1"><u><a href="https://www.instagram.com/raytheontechnologies" style="color:rgb(5,99,193)"><font color="#000000"><font size="1" style="font-size:8pt">Instagram</font></font></a></u></font><font color="#000000"><font color="#ce1126"><font size="1" style="font-size:8pt"><span style="text-decoration:none">
</span></font></font></font></font></font></p>
<br>
</div>
</div>
</div>
</div>
</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> pgpool-general <pgpool-general-bounces@pgpool.net> on behalf of Jon SCHEWE <jon.schewe@raytheon.com><br>
<b>Sent:</b> Wednesday, September 14, 2022 15:23<br>
<b>To:</b> Tatsuo Ishii <ishii@sraoss.co.jp><br>
<b>Cc:</b> pgpool-general@pgpool.net <pgpool-general@pgpool.net><br>
<b>Subject:</b> [External] [pgpool-general: 8401] Re: pgpool failing over on bad queries</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">I switched streaming replication to not use SSL and this time it appears that the health check got the same SSL error.<br>
<br>
<br>
2022-09-14 16:09:34.518: watchdog pid 938113: LOG: remote node "psql-03:9898 Linux psql-03" is asking to inform about quarantined backend nodes<br>
2022-09-14 16:09:34.519: watchdog pid 938113: LOG: signal_user1_to_parent_with_reason(4)<br>
2022-09-14 16:09:34.519: main pid 938106: LOG: Pgpool-II parent process received SIGUSR1<br>
2022-09-14 16:09:34.519: main pid 938106: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog<br>
2022-09-14 16:09:34.981: health_check0 pid 938472: LOG: pool_ssl: "SSL_read": "no SSL error reported"<br>
2022-09-14 16:09:34.981: health_check0 pid 938472: LOG: received degenerate backend request for node_id: 0 from pid [938472]<br>
2022-09-14 16:09:34.981: watchdog pid 938113: LOG: new IPC connection received<br>
2022-09-14 16:09:34.981: watchdog pid 938113: LOG: failover request from local pgpool-II node received on IPC interface is forwarded to leader watchdog node "psql-03:9898 Linux psql-03"<br>
2022-09-14 16:09:34.981: watchdog pid 938113: DETAIL: waiting for the reply...<br>
2022-09-14 16:09:34.983: health_check0 pid 938472: LOG: degenerate backend request for 1 node(s) from pid [938472], will be handled by watchdog<br>
2022-09-14 16:09:34.984: health_check0 pid 938472: LOG: health check retrying on DB node: 0 (round:1)<br>
2022-09-14 16:09:35.788: watchdog pid 938113: LOG: signal_user1_to_parent_with_reason(2)<br>
2022-09-14 16:09:35.788: main pid 938106: LOG: Pgpool-II parent process received SIGUSR1<br>
2022-09-14 16:09:35.788: main pid 938106: LOG: Pgpool-II parent process received sync backend signal from watchdog<br>
2022-09-14 16:09:35.788: watchdog pid 938113: LOG: new IPC connection received<br>
2022-09-14 16:09:35.788: main pid 938106: LOG: leader watchdog has performed failover<br>
2022-09-14 16:09:35.788: main pid 938106: DETAIL: syncing the backend states from the LEADER watchdog node<br>
2022-09-14 16:09:35.788: watchdog pid 938113: LOG: new IPC connection received<br>
2022-09-14 16:09:35.788: watchdog pid 938113: LOG: received the get data request from local pgpool-II on IPC interface<br>
2022-09-14 16:09:35.789: watchdog pid 938113: LOG: get data request from local pgpool-II node received on IPC interface is forwarded to leader watchdog node "psql-03:9898 Linux psql-03"<br>
2022-09-14 16:09:35.789: watchdog pid 938113: DETAIL: waiting for the reply...<br>
2022-09-14 16:09:35.789: main pid 938106: LOG: leader watchdog node "psql-03:9898 Linux psql-03" returned status for 3 backend nodes<br>
2022-09-14 16:09:35.789: main pid 938106: LOG: backend:0 is set to down status<br>
2022-09-14 16:09:35.789: main pid 938106: DETAIL: backend:0 is DOWN on cluster leader "psql-03:9898 Linux psql-03"<br>
2022-09-14 16:09:35.789: main pid 938106: LOG: 1 backend node(s) were detached because of backend status sync from "psql-03:9898 Linux psql-03"<br>
2022-09-14 16:09:35.789: main pid 938106: DETAIL: restarting the children processes<br>
2022-09-14 16:09:35.789: main pid 938106: LOG: Node 1 is not down (status: 1)<br>
2022-09-14 16:09:35.790: sr_check_worker pid 940145: LOG: worker process received restart request<br>
2022-09-14 16:09:35.799: main pid 938106: LOG: worker child process with pid: 940145 exits with status 256<br>
2022-09-14 16:09:35.800: main pid 938106: LOG: fork a new worker child process with pid: 1148791<br>
2022-09-14 16:09:35.800: sr_check_worker pid 1148791: LOG: process started<br>
_______________________________________________<br>
pgpool-general mailing list<br>
pgpool-general@pgpool.net<br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div>
</span></font></div>
</body>
</html>