<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="">Hello,<div class=""><br class=""></div><div class="">I have, quite frequently, a problem connecting to pgpool. The application seems to not be able to allow other connections but doesn’t reject them, it makes them hang forever.</div><div class="">It does not affect existing connection, but sometimes when I want to restart my front office I have to restart the pgpool service to make it work and allow connections.</div><div class=""><br class=""></div><div class="">Here are the logs at the moment (with my restart) :</div><div class=""><br class=""></div><div class=""><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;">2016-09-21 17:49:20: pid 1939: LOG: child process with pid: 10496 exits with status 512</div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:49:20: pid 1939: LOG: fork a new child process with pid: 10922</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:49:30: pid 1939: LOG: child process with pid: 10841 exits with status 512</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:49:30: pid 1939: LOG: fork a new child process with pid: 10923</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:51:21: pid 1939: LOG: child process with pid: 10877 exits with status 512</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:51:21: pid 1939: LOG: fork a new child process with pid: 10931</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:52:01: pid 1939: LOG: child process with pid: 10897 exits with status 512</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:52:01: pid 1939: LOG: fork a new child process with pid: 10934</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10977: LOG: stop request sent to pgpool. waiting for termination...</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 1939: LOG: received fast shutdown request</span></div></div><div class=""><span class="" style="font-family: Menlo; font-size: 11px;">2016-09-21 17:52:01: pid 1939: LOG: </span><span class="" style="font-family: Menlo; font-size: 11px;">fork a new child process with pid: 10934</span></div><div class=""><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10977: LOG: stop request sent to pgpool. waiting for termination...</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 1939: LOG: received fast shutdown request</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">.2016-09-21 17:54:58: pid 1939: LOG: shutdown request. closing listen socket</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10819: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10922: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10598: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10934: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10846: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10904: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10605: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10900: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 6935: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10852: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10714: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10868: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10888: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10913: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10687: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10903: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10883: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10918: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10919: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10538: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10742: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10912: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10908: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10923: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10905: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10909: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10685: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10871: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10544: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10931: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10896: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:58: pid 10853: LOG: child process received shutdown request signal 2</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">done.</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:59: pid 11016: LOG: reading status file: 0 th backend is set to down status</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:59: pid 11016: LOG: Setting up socket for 0.0.0.0:9999</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:59: pid 11016: LOG: Setting up socket for :::9999</span></div><div class="" style="margin: 0px; font-size: 11px; line-height: normal; font-family: Menlo;"><span class="" style="font-variant-ligatures: no-common-ligatures;">2016-09-21 17:54:59: pid 11016: LOG: pgpool-II successfully started. version 3.4.5 (tataraboshi)</span></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">I’m not using health check because my infrastructure handles it 'by itself ». I’m joining you my conf : </div></body></html>