<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p></p>
<p class="MsoNormal">Does anyone have the same issue with mine?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">OS: Ubuntu16.04<o:p></o:p></p>
<p class="MsoNormal">Pgpool2: 3.6.4-1.pgdg16.04+1<o:p></o:p></p>
<p class="MsoNormal">PostgreSQL: 9.6.3-1.pgdg16.04+1<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Pgpool2 service is controlled by systemd.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Issues:<o:p></o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormalCxSpMiddle" style="margin-left:0in;mso-add-space:auto;
line-height:105%;mso-list:l0 level1 lfo1">
“Systemctl stop pgpool2” will take a long time and finally will be failed<o:p></o:p>
</li><li class="MsoNormalCxSpLast" style="margin-left:0in;mso-add-space:auto;
line-height:105%;mso-list:l0 level1 lfo1">
“systemctl start pgpool2” will have below errors in logs:<o:p></o:p> </li></ol>
<p class="MsoListParagraphCxSpFirst">Jul 4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: FATAL: failed to bind a socket: "/var/run/postgresql/.s.PGSQL.9999"<o:p></o:p></p>
<p class="MsoListParagraphCxSpMiddle">Jul 4 16:50:30 pgpoolserver pgpool[2179]: 2017-07-04 16:50:30: pid 2179: DETAIL: bind socket failed with error: "Address already in use"<o:p></o:p></p>
<p class="MsoListParagraphCxSpMiddle">Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Main process exited, code=exited, status=3/NOTIMPLEMENTED<o:p></o:p></p>
<p class="MsoListParagraphCxSpMiddle">Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Unit entered failed state.<o:p></o:p></p>
<p class="MsoListParagraphCxSpLast">Jul 4 16:50:30 pgpoolserver systemd[1]: pgpool2.service: Failed with result 'exit-code'.<o:p></o:p></p>
<br>
<p></p>
</div>
</body>
</html>