<div dir="ltr">Hello,<br><div class="gmail_quote"><div dir="ltr"><div><br></div><div>I'm having problem with failover triggering every night because for me unknown reason. I have latest pgpool-3.3.0 version with postgresql 9.0 nodes.</div>
<div><br></div><div>I have streaming replication and load balance, without watchdog.</div>
<div>I have enabled healt check with this paremeters:</div><div><br></div><div><div><font face="courier new, monospace">health_check_period = 5</font></div><div><font face="courier new, monospace">health_check_timeout = 20</font></div>
</div><div><div><font face="courier new, monospace">health_check_user = 'postgres'</font></div><div><font face="courier new, monospace">health_check_max_retries = 1</font></div><div><font face="courier new, monospace">health_check_retry_delay = 1</font></div>
</div><div><br></div><div><br></div><div>Here is my pgpool.log with debug option enabled:</div><div><br></div><div><div><div><font face="courier new, monospace">2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: auth kind: 0</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: backend key data received</font></div><div><font face="courier new, monospace">2013-08-28 05:15:23 DEBUG: pid 10079: s_do_auth: transaction state: I</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:23 DEBUG: pid 10079: health check: clearing alarm</font></div><div><font face="courier new, monospace">2013-08-28 05:15:23 DEBUG: pid 10079: health check: clearing alarm</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: starting health checking</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: health_check: 0 th DB node status: 2</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: pool_ssl: SSL requested but SSL support is not available</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: auth kind: 0</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: backend key data received</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: transaction state: I</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: health_check: 1 th DB node status: 2</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: pool_ssl: SSL requested but SSL support is not available</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: auth kind: 0</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: backend key data received</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: s_do_auth: transaction state: I</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm</font></div><div><font face="courier new, monospace">2013-08-28 05:15:28 DEBUG: pid 10079: health check: clearing alarm</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:29 ERROR: pid 15210: pool_read: read failed (Connection timed out)</font></div><div><font face="courier new, monospace">2013-08-28 05:15:29 LOG: pid 15210: degenerate_backend_set: 0 fail over request from pid 15210</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:29 ERROR: pid 15210: pool_flush_it: write failed to backend (0). reason: Broken pipe offset: 0 wlen: 5</font></div><div><font face="courier new, monospace">2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler called</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: starting to select new master node</font></div><div><font face="courier new, monospace">2013-08-28 05:15:29 LOG: pid 10079: starting degeneration. shutdown host intrix-c1(5432)</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:29 LOG: pid 10079: Restart all children</font></div><div><font face="courier new, monospace">2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 18940</font></div>
<div><font face="courier new, monospace">2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 10507</font></div><div><font face="courier new, monospace">2013-08-28 05:15:29 DEBUG: pid 10079: failover_handler: kill 2139</font></div>
<span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888"><div><br></div>-- <br>Armin
</font></span></div></div>
</div><br></div>