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

[Tatsuo Ishii]

I was requesting a system call trace, not pgpool log.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Dear Sir,
> 
> My log file is attached.
> 
> It looks like that although pgpool cannot connect to database, it still
> determine the database as active (status=1).
> 
> thank you for your help.
> 
> regards
> 
> 
> 
> 
> 
> 
> 2013/3/7 Tatsuo Ishii <ishii at postgresql.org>
> 
>> 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
>>
> 
> 
> 
> -- 
> 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