<div dir="ltr"><div><div><div><div><div>Dear Sir,<br><br></div>Thanks for your kindly response.<br><br></div>After patching your pool_connection_pool.patch file, pgpool still cannot detect the unplugged network cable of database within the timeout set in health_check.<br>
<br></div>The settings of my pgpool.conf are listed below:<br><br></div>health_check_period=2<br></div>health_check_timeout=1<br><div><div><div><div>health_check_max_retries=3<br></div><div>health_check_retry_delay=0<br><br>
</div><div>Theoretically, pgpool can detect an unplugged network cable no more than 6 seconds by health check.<br></div><div>But it takes about more than 30 seconds in pgpool-II-3.2.3.<br><br></div><div>But in pgpool-II-3.2.1, pgpool can detect this situation in 6 seconds.<br>
<br></div><div>Thanks for helping deal with my problem.<br><br></div><div>best regards,<br><br></div><div><br><br>manphis chen<br></div><div><br><br></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/3/6 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5">> Dear all,<br>
><br>
> I am now using pgpool-II-3.2.3 for my experiment.<br>
><br>
> I found that the parameter health_check_timeout does not work.<br>
><br>
> In my experiment, I unplug network cable.<br>
><br>
> pgpool found that the status of the unplugged database becomes 3 for a long<br>
> time, not within the health_check_timeout.<br>
><br>
> I also found that this situation does not happen in pgpool-II-3.2.1.<br>
><br>
> May I ask is there any changes in the pgpool-II-3.2.3, such that the<br>
> parameter health_check_timeout does not work well?<br>
<br>
</div></div>I found possible cause of the problem. Can you please try out attached patch?<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>
</blockquote></div><br><br clear="all"><br>-- <br>Wireless Communication and Mobile Computing Research Group Laboratory<br>TEL:(886)-2-23625336-448<br>Dept. of Computer Science and Information Engineering<br>National Taiwan University, Taipei, Taiwan
</div>