[Pgpool-general] Health check

[Yoshiyuki Asaba]

Hi,

From: "Luis_Alberto_Pérez_Paz" <midriasis at gmail.com>
Subject: Re: [Pgpool-general] Health check
Date: Wed, 12 Mar 2008 10:52:44 -0600

> My tests were with pgpool-3.4.1 and pgpool-II-1.3
> The same results in both.

I've fixed into pgpool and pgpool-II 2.x.

* pgpool-II 2.x
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/main.c.diff?r1=1.35&r2=1.36&f=u

* pgpool
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool/main.c.diff?r1=1.24&r2=1.25&f=u


> I didn't test with pgpool-II-2.0.1 because replicate_select does not work
> and I need it.

This was fixed in CVS HEAD. We are going to release pgpool-II 2.1 beta
version on 17th Mar.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp

> 
> 
> My Postgresql is 8.3.0
> 
> Best Regards,
> 
> 
> 
> On Tue, Mar 11, 2008 at 6:29 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
> > What is your pgpool version?
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> >
> > > Hi everybody,
> > >
> > > I'm doing a lot of tests with pgpool because we want to implement it in
> > our
> > > production environment.
> > >
> > > My laboratory is:
> > > Computer 1: running pgpool
> > > Computer 2: running postgres
> > > Computer 3: running postgres
> > >
> > > I'm simulating a fall in one the psql servers (Computer 1 & 2).
> > >
> > > When I stop the postgres service, pgpool works great. My health_check
> > > parameters are:
> > >
> > > health_check_timeout = 5
> > > health_check_period = 5
> > >
> > > However when I unplugged the network cable (or even if I unplugged the
> > power
> > > cable) the health_check_timeout does not work, pgpool delays between 1
> > and 2
> > > minutes to detect the error.
> > >
> > > 2008-03-11 13:18:26 LOG:   pid 23451: starting health checking
> > > 2008-03-11 13:19:14 ERROR: pid 23451: connect_inet_domain_socket:
> > connect()
> > > failed: No route to host
> > >
> > >
> > > Is it normal??? Can I detect these errors in another way?
> > >
> > >
> > > Thanks in advance for your help.
> > >
> > >
> > > Best Regards,
> > >
> > >
> > > Luis Alberto Perez Paz
> > >
> > > --
> > > paz, amor y comprensión
> > > (1967-1994)
> >
> 
> 
> 
> -- 
> paz, amor y comprensión
> (1967-1994)