<div dir="ltr">Hi Tatsuo, <div>Thanks for pointing this out. I have committed the fix in <span id="aa535d81-13e5-43da-acb4-4c1f1608cdbc" class="GINGER_SOFTWARE_mark">master branch</span>.</div><div><br></div><div><div>The reason was a typo in process_backend_health_check_failure<span id="593717c1-70a1-46e2-879b-2cdd66689b8a" class="GINGER_SOFTWARE_mark">(</span>) function where the function tries to figure out the max health check retry count for current pgpool-II configuration. Instead of using pool_config->health_check_max_retries configuration for max retry count the function was mistakenly considering pool_config->health_check_retry_delay for the purpose.</div></div><div><br></div><div>Kind regards,</div><div>Muhammad Usama</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Oct 28, 2014 at 5:31 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Usama,<br>
<br>
It seems master branch pgpool-II ignores health check retry<br>
setting. At least 3.3 stable pgpool-II behaves as expected. I am<br>
afraid this will be the show stopper for 3.5.0.<br>
<br>
Step to reproduce;<br>
<br>
1) pgpool.conf<br>
fail_over_on_backend_error = off<br>
health_check_period = 5<br>
health_check_timeout = 2<br>
health_check_max_retries = 20<br>
health_check_retry_delay = 1<br>
sr_check_period = 0<br>
<br>
2) start pgpool-II.<br>
<br>
3) kill one of postmaster using kill -9. (I know this is bad but<br>
normal shutdown command using pg_ctl does not trigger health check<br>
retry since pgpool-II immediately detaches the node)<br>
<br>
4) check pgpool log. You will see it reried only once or twice.<br>
<br>
2014-10-28 09:19:19: pid 9519: LOG: health checking retry count 1<br>
2014-10-28 09:19:19: pid 9519: LOG: failed to connect to PostgreSQL server by unix domain socket<br>
2014-10-28 09:19:19: pid 9519: DETAIL: connect to "/tmp/.s.PGSQL.11001" failed with error "Connection refused"<br>
2014-10-28 09:19:19: pid 9519: ERROR: failed to make persistent db connection<br>
2014-10-28 09:19:19: pid 9519: DETAIL: connection to host:"/tmp:11001" failed<br>
2014-10-28 09:19:19: pid 9519: LOG: setting backend node 1 status to NODE DOWN<br>
2014-10-28 09:19:19: pid 9519: LOG: starting degeneration. shutdown host /tmp(11001)<br>
2014-10-28 09:19:19: pid 9519: LOG: Restart all children<br>
:<br>
:<br>
:<br>
<br>
I attached full debug log for your convenience.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>2014-10-28 09:29:39: pid 9955: LOG: Backend status file /home/t-ishii/work/pgpool-II/current/aaa/log/pgpool_status discarded<br>
2014-10-28 09:29:39: pid 9955: LOG: Setting up socket for <a href="http://127.0.0.1:11002" target="_blank">127.0.0.1:11002</a><br>
2014-10-28 09:29:39: pid 9956: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9957: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9958: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9961: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9962: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9960: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9965: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9966: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9959: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9969: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9971: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9973: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9963: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9976: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9977: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9980: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9981: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9984: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9985: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: LOG: pgpool-II successfully started. version 3.4beta2 (tataraboshi)<br>
2014-10-28 09:29:39: pid 9955: LOG: find_primary_node: checking bac2014-10-28 09:29:39: pid 9988: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9988: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:39: pid 9989: DEBUG: I am 9989<br>
2014-10-28 09:29:39: pid 9989: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9989: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:39: pid 9987: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9967: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9986: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9968: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9970: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9964: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9972: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: extended:0 query:"SELECT pg_is_in_recovery()"<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:39: pid 9989: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:39: pid 9974: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9975: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: kind: 'T'<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: received ROW DESCRIPTION ('T')<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: row description: num_fileds: 1<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: kind: 'D'<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: received DATA ROW ('D')<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: kind: 'C'<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: received COMMAND COMPLETE ('C')<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: kind: 'Z'<br>
2014-10-28 09:29:39: pid 9955: DEBUG: do_query: received READY FOR QUERY ('Z')<br>
2014-10-28 09:29:39: pid 9978: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: LOG: find_primary_node: primary node id is 0<br>
2014-10-28 09:29:39: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:29:39: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:39: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:29:39: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:29:39: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:39: pid 9979: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9982: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9983: DEBUG: initializing backend status<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:39: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:29:39: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:39: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:39: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:39: pid 9989: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: extended:0 query:"SELECT pg_current_xlog_location()"<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'T'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received ROW DESCRIPTION ('T')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: row description: num_fileds: 1<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'D'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received DATA ROW ('D')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'C'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received COMMAND COMPLETE ('C')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'Z'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received READY FOR QUERY ('Z')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: extended:0 query:"SELECT pg_last_xlog_replay_location()"<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:39: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:39: pid 9955: DEBUG: persistent DB connection to backend node 1 having status 1 is successful<br>
2014-10-28 09:29:39: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:39: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'T'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received ROW DESCRIPTION ('T')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: row description: num_fileds: 1<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'D'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received DATA ROW ('D')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'C'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received COMMAND COMPLETE ('C')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: kind: 'Z'<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:39: pid 9989: DEBUG: do_query: received READY FOR QUERY ('Z')<br>
2014-10-28 09:29:39: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:44: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:29:44: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:44: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:29:44: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:29:44: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:44: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:29:44: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:44: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:44: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:44: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:44: pid 9955: DEBUG: persistent DB connection to backend node 1 having status 1 is successful<br>
2014-10-28 09:29:44: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:44: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:49: pid 9989: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:49: pid 9989: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:49: pid 9989: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: extended:0 query:"SELECT pg_current_xlog_location()"<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'T'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received ROW DESCRIPTION ('T')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: row description: num_fileds: 1<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'D'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received DATA ROW ('D')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'C'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received COMMAND COMPLETE ('C')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'Z'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received READY FOR QUERY ('Z')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: extended:0 query:"SELECT pg_last_xlog_replay_location()"<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'T'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received ROW DESCRIPTION ('T')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: row description: num_fileds: 1<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'D'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received DATA ROW ('D')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'C'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received COMMAND COMPLETE ('C')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: kind: 'Z'<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9989: DEBUG: do_query: received READY FOR QUERY ('Z')<br>
2014-10-28 09:29:49: pid 9989: CONTEXT: while checking replication time lag<br>
2014-10-28 09:29:49: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:29:49: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:49: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:29:49: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:29:49: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:49: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:29:49: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:49: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:49: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:49: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:49: pid 9955: DEBUG: persistent DB connection to backend node 1 having status 1 is successful<br>
2014-10-28 09:29:49: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:49: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:29:54: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:29:54: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:54: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:54: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:54: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:54: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:54: pid 9955: LOG: failed to connect to PostgreSQL server by unix domain socket<br>
2014-10-28 09:29:54: pid 9955: DETAIL: connect to "/tmp/.s.PGSQL.11001" failed with error "Connection refused"<br>
2014-10-28 09:29:54: pid 9955: ERROR: failed to make persistent db connection<br>
2014-10-28 09:29:54: pid 9955: DETAIL: connection to host:"/tmp:11001" failed<br>
2014-10-28 09:29:54: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:54: pid 9955: LOG: failed to connect to PostgreSQL server by unix domain socket<br>
2014-10-28 09:29:54: pid 9955: DETAIL: connect to "/tmp/.s.PGSQL.11001" failed with error "Connection refused"<br>
2014-10-28 09:29:54: pid 9955: ERROR: failed to make persistent db connection<br>
2014-10-28 09:29:54: pid 9955: DETAIL: connection to host:"/tmp:11001" failed<br>
2014-10-28 09:29:54: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:54: pid 9955: DEBUG: Sleeping for 1 seconds from process backend health check failure<br>
2014-10-28 09:29:54: pid 9955: DETAIL: health check failed retry no is 1 while max retries are 1<br>
2014-10-28 09:29:55: pid 9955: LOG: health checking retry count 1<br>
2014-10-28 09:29:55: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:55: pid 9955: DEBUG: Backend DB node 1 status is 1<br>
2014-10-28 09:29:55: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 1 having status 1<br>
2014-10-28 09:29:55: pid 9955: LOG: failed to connect to PostgreSQL server by unix domain socket<br>
2014-10-28 09:29:55: pid 9955: DETAIL: connect to "/tmp/.s.PGSQL.11001" failed with error "Connection refused"<br>
2014-10-28 09:29:55: pid 9955: ERROR: failed to make persistent db connection<br>
2014-10-28 09:29:55: pid 9955: DETAIL: connection to host:"/tmp:11001" failed<br>
2014-10-28 09:29:55: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:55: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:55: pid 9955: LOG: setting backend node 1 status to NODE DOWN<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler called<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: starting to select new master node<br>
2014-10-28 09:29:55: pid 9955: LOG: starting degeneration. shutdown host /tmp(11001)<br>
2014-10-28 09:29:55: pid 9955: LOG: Restart all children<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9956<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9957<br>
2014-10-28 09:29:55: pid 9957: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9959<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9960<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9961<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9962<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9963<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9964<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9965<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9966<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9967<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9968<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9969<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9970<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9971<br>
2014-10-28 09:29:55: pid 9960: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9972<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9973<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9974<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9975<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9976<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9977<br>
2014-10-28 09:29:55: pid 9961: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9979<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9980<br>
2014-10-28 09:29:55: pid 9965: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9963: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9964: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9966: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9969: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9968: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9971: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9973: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9981<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9982<br>
2014-10-28 09:29:55: pid 9982: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9976: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9985<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9986<br>
2014-10-28 09:29:55: pid 9955: DEBUG: failover handler<br>
2014-10-28 09:29:55: pid 9955: DETAIL: kill process with PID:9987<br>
2014-10-28 09:29:55: pid 9955: LOG: execute command: /home/t-ishii/work/pgpool-II/current/aaa/etc/failover.sh 1 /tmp 11001 /home/t-ishii/work/pgpool-II/current/aaa/data1 0 0 /tmp 0 11000 /home/t-ishii/work/pgpool-II/current/aaa/data0<br>
2014-10-28 09:29:55: pid 9977: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9980: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9986: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9983: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9981: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9979: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9987: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9985: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9978: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9984: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9967: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9970: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9972: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9975: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9974: LOG: child process received shutdown request signal 3<br>
2014-10-28 09:29:55: pid 9955: LOG: failover: set new primary node: 0<br>
2014-10-28 09:29:55: pid 9955: LOG: failover: set new master node: 0<br>
2014-10-28 09:29:55: pid 10008: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10009: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10012: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10011: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10013: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10010: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10015: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10014: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10016: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10019: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10017: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10029: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10018: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10023: DEBUG: initializing backend status<br>
failover done. shutdown host /tmp(11001)2014-10-28 09:29:55: pid 9989: LOG: worker process received restart request<br>
2014-10-28 09:29:55: pid 10021: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 9955: LOG: failover done. shutdown host /tmp(11001)<br>
2014-10-28 09:29:55: pid 10024: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 9988: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10022: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10020: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10026: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10027: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10034: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10035: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10028: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10036: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10030: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10037: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10031: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10038: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10032: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10039: DEBUG: initializing backend status<br>
2014-10-28 09:29:55: pid 10033: DEBUG: initializing backend status<br>
2014-10-28 09:29:56: pid 9988: LOG: restart request received in pcp child process<br>
2014-10-28 09:29:56: pid 9955: LOG: PCP child 9988 exits with status 256 in failover()<br>
2014-10-28 09:29:56: pid 9955: LOG: fork a new PCP child pid 10040 in failover()<br>
2014-10-28 09:29:56: pid 9955: LOG: health checking retry count 2<br>
2014-10-28 09:29:56: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:56: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:29:56: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:29:56: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:56: pid 10040: DEBUG: I am PCP child with pid:10040<br>
2014-10-28 09:29:56: pid 10040: DEBUG: initializing backend status<br>
2014-10-28 09:29:56: pid 10040: DEBUG: initializing backend status<br>
2014-10-28 09:29:56: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:56: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:29:56: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:29:56: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:29:56: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:56: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9956 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9957 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9958 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9959 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9960 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9961 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9962 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9963 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9964 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9965 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9966 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9967 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9968 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9969 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9970 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9971 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9972 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9973 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9974 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9975 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9976 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9977 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9978 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9979 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9980 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9981 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9982 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9983 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9984 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9985 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9986 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: child with PID:9987 exits with status 0<br>
2014-10-28 09:29:56: pid 9955: LOG: worker child 9989 exits with status 256<br>
2014-10-28 09:29:56: pid 9955: LOG: fork a new worker child pid 10042<br>
2014-10-28 09:29:56: pid 9955: DEBUG: reaper handler: exiting normally<br>
2014-10-28 09:29:56: pid 10042: DEBUG: I am 10042<br>
2014-10-28 09:29:56: pid 10042: DEBUG: initializing backend status<br>
2014-10-28 09:29:56: pid 10042: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:29:56: pid 10042: DEBUG: authenticate kind = 0<br>
2014-10-28 09:29:56: pid 10042: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:29:56: pid 10042: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:01: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:01: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:01: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:01: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:01: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:01: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:01: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:01: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:01: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:01: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:01: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:01: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:06: pid 10042: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:06: pid 10042: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:06: pid 10042: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:06: pid 10042: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:06: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:06: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:06: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:06: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:06: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:06: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:06: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:06: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:06: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:06: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:06: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:06: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:11: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:11: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:11: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:11: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:11: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:11: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:11: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:11: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:11: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:11: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:11: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:11: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:16: pid 10042: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:16: pid 10042: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:16: pid 10042: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:16: pid 10042: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:16: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:16: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:16: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:16: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:16: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:16: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:16: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:16: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:16: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:16: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:16: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:16: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:21: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:21: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:21: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:21: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:21: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:21: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:21: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:21: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:21: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:21: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:21: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:21: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:26: pid 10042: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:26: pid 10042: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:26: pid 10042: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:26: pid 10042: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:26: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:26: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:26: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:26: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:26: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:26: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:26: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:26: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:26: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:26: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:26: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:26: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:31: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:31: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:31: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:31: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:31: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:31: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:31: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:31: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:31: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:31: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:31: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:31: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:36: pid 10042: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:36: pid 10042: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:36: pid 10042: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:36: pid 10042: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:36: pid 9955: DEBUG: starting health check<br>
2014-10-28 09:30:36: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:36: pid 9955: DEBUG: Backend DB node 0 status is 1<br>
2014-10-28 09:30:36: pid 9955: DEBUG: Trying to make persistent DB connection to backend node 0 having status 1<br>
2014-10-28 09:30:36: pid 9955: DEBUG: SSL is requested but SSL support is not available<br>
2014-10-28 09:30:36: pid 9955: DEBUG: authenticate kind = 0<br>
2014-10-28 09:30:36: pid 9955: DEBUG: authenticate backend: key data received<br>
2014-10-28 09:30:36: pid 9955: DEBUG: authenticate backend: transaction state: I<br>
2014-10-28 09:30:36: pid 9955: DEBUG: persistent DB connection to backend node 0 having status 1 is successful<br>
2014-10-28 09:30:36: pid 9955: DEBUG: Backend DB node 1 status is 3<br>
2014-10-28 09:30:36: pid 9955: DEBUG: health check: clearing alarm<br>
2014-10-28 09:30:36: pid 9955: DEBUG: health check: clearing alarm<br>
<br>_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
<br></blockquote></div><br></div>