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

[manphis chen]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130307/d2c6a050/attachment-0001.html>