[pgpool-hackers: 1631] Re: [pgpool-committers: 3254] pgpool: Fix a posible hang during health checking

[Yugo Nagata]

This is backported to 3.3 or below.

http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=c37e3f83b2fea74bb879f0d4ed96e85c632ee499

I used health_check_timer_expired to check it is during health checking,
rather than processState, since this flag is true only if SIGALRM occurs
during health checking.

On Tue, 14 Jun 2016 13:25:52 +0900
Yugo Nagata <nagata at sraoss.co.jp> wrote:

> On Sat, 11 Jun 2016 23:40:39 +0900 (JST)
> Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
> > Why wasn't this backported to 3.3 or below?
> 
> In 3.3 or below, processState isn't implimented and the
> patch can't be backported directly. I'll try apply this
> to the older branches with some revison.
> 
> > 
> > Best regards,
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese:http://www.sraoss.co.jp
> > 
> > > Fix a posible hang during health checking
> > > 
> > > Helath checking was hang when any data wasn't sent
> > > from backend after connect(2) succeeded. To fix this,
> > > pool_check_fd() returns 1 when select(2) exits with
> > > EINTR due to SIGALRM while health checkking is performed.
> > > 
> > > Reported and patch provided by harukat and some modification
> > > by Yugo. Per bug #204.
> > > 
> > > Branch
> > > ------
> > > master
> > > 
> > > Details
> > > -------
> > > http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=294cf4aa4d5a3b9489d33b29d04a5ea9b8cf6d89
> > > 
> > > Modified Files
> > > --------------
> > > src/protocol/pool_process_query.c | 10 ++++++++++
> > > 1 file changed, 10 insertions(+)
> > > 
> > > _______________________________________________
> > > pgpool-committers mailing list
> > > pgpool-committers at pgpool.net
> > > http://www.pgpool.net/mailman/listinfo/pgpool-committers
> 
> 
> -- 
> Yugo Nagata <nagata at sraoss.co.jp>
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers


-- 
Yugo Nagata <nagata at sraoss.co.jp>