<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
With PgPool 3.5.4 and Postgres 9.5.4. I’m seeing ERROR(s) like the following, without SSL turned on:
<div class=""><br class="">
</div>
<div class="">
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-26 16:01:27: pid 5896: ERROR: unable to read data from frontend</span></div>
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-26 16:01:27: pid 5896: DETAIL: EOF encountered with frontend</span></div>
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-26 16:01:27: pid 5896: LOCATION: pool_stream.c:261</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">With SSL turned on I see the following:</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-25 10:30:26: pid 19075: WARNING: ssl read: EOF detected</span></div>
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-25 10:30:26: pid 19075: ERROR: unable to read data from frontend</span></div>
<div style="margin: 0px; font-size: 15px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures" class="">2016-10-25 10:30:26: pid 19075: DETAIL: socket read failed with an error "Success"</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">Eventually PgPool stops responding and I have to restart Pgpool. This is a two node Master/Slave on Redhat EL 6.</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class=""><br class="">
</span></div>
<div class=""><span style="font-variant-ligatures: no-common-ligatures" class="">I don’t see any errors in the Postgres Database log for these times, PgPool is running on both of the Database Servers.</span></div>
</span></div>
<div class=""><br class="">
</div>
<div class=""></div>
<br class="">
</div>
</body>
</html>