[pgpool-general: 1465] Re: health check timeout in pgpool-II-3.2.3

[Tatsuo Ishii]

Thank you for testing.
Can you please send me system call trace log of pgpool main (parent)
process?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Dear Sir,
> 
> Thanks for your kindly response.
> 
> 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.
> 
> The settings of my pgpool.conf are listed below:
> 
> health_check_period=2
> health_check_timeout=1
> health_check_max_retries=3
> health_check_retry_delay=0
> 
> Theoretically, pgpool can detect an unplugged network cable no more than 6
> seconds by health check.
> But it takes about more than 30 seconds in pgpool-II-3.2.3.
> 
> But in pgpool-II-3.2.1, pgpool can detect this situation in 6 seconds.
> 
> Thanks for helping deal with my problem.
> 
> best regards,
> 
> 
> 
> manphis chen
> 
> 
> 
> 
> 2013/3/6 Tatsuo Ishii <ishii at postgresql.org>
> 
>> > Dear all,
>> >
>> > I am now using pgpool-II-3.2.3 for my experiment.
>> >
>> > I found that the parameter health_check_timeout does not work.
>> >
>> > In my experiment, I unplug network cable.
>> >
>> > pgpool found that the status of the unplugged database becomes 3 for a
>> long
>> > time, not within the health_check_timeout.
>> >
>> > I also found that this situation does not happen in pgpool-II-3.2.1.
>> >
>> > May I ask is there any changes in the pgpool-II-3.2.3, such that the
>> > parameter health_check_timeout does not work well?
>>
>> I found possible cause of the problem. Can you please try out attached
>> patch?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
> 
> 
> 
> -- 
> Wireless Communication and Mobile Computing Research Group Laboratory
> TEL:(886)-2-23625336-448
> Dept. of Computer Science and Information Engineering
> National Taiwan University, Taipei, Taiwan