[pgpool-general: 2981] Re: health check failed

[Yugo Nagata]

On Thu, 26 Jun 2014 14:15:17 +0000
Wolf Schwurack <wolf at uen.org> wrote:

> Yes the backend is working? The application is able to connect.
> 
> I set in /etc/hosts postgres servers IP and hostname on the pgpool servers
> and on postgres servers I set pgpool IP and hostname in /etc/hosts. its
> all on the same network so there should be any network issues.
> 
> It doesn¹t go through a firewall
> 
> Here shows the connection from pgpool to postgres
> pgprod-con1 ~  pgpool $ psql -p 9999
> psql (9.2.6)
> Type "help" for help.
> 
> postgres=#
> 
> Show nodes
> postgres=# show pool_nodes;
>  node_id |  hostname  | port | status | lb_weight |  role
> ---------+------------+------+--------+-----------+---------
>  0       | pgprod-db  | 5432 | 2      | 0.500000  | primary
>  1       | pgprod-rep | 5432 | 2      | 0.500000  | standby
> (2 rows)
> 
> I¹m not getting the error in my dev environment and in my RC environment I
> only see the error on my standby pgpool server.

If there is no network problem betwenn standby pgoool and backends,
this might be authentication problem like pg_hba.conf configuration.

Can you see any error in pgpool.log like
 ERROR: make_persistent_db_connection: s_do_auth failed
or other errors in backend postgres's log?

> 
> Our setup for all of our environments
> 2 pgpool servers (primary/standby)
> 2 postgres server (primary with streaming standby)
> 
> 
> 
> 
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> Wolf at uen.org
> 
> 
> 
> 
> 
> On 6/25/14, 9:04 PM, "Yugo Nagata" <nagata at sraoss.co.jp> wrote:
> 
> >Hi,
> >
> >Please confirm the below;
> >
> >- The backend is actually working? Hostname and port number are right?
> >- The network between pgpool and postgres is healty?
> >  Can you connect postgres from pgpool server by psql command?
> >- Firewall configuration is right? SELinx etc. might cause.
> >
> >If all is ok, pgpool configuration might be wrong. Could you please
> >send all pgpool log and pgpool.conf?
> >
> >On Wed, 25 Jun 2014 13:39:30 +0000
> >Wolf Schwurack <wolf at uen.org> wrote:
> >
> >> I keep getting this error in my pgpool.log file
> >> ERROR: pid 1250: health check failed. 0 th host pgprod-db at port 5432
> >>is down
> >> 
> >> Servers: Ubuntu 10.04.4 LTS
> >> Postgres: psql (9.2.6)
> >> Pgpool: pgpool-II version 3.3.3 (tokakiboshi)
> >> 
> >> Wolfgang Schwurack
> >> Database/System Administrator
> >> Utah Education Network
> >> 801-587-9444
> >> Wolf at uen.org
> >> 
> >
> >
> >-- 
> >Yugo Nagata <nagata at sraoss.co.jp>
> 


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