[Pgpool-general] pgpool-II-2.2.1 dropping secondary back-end

[Sridhar Reddapani]

On Fri, Jul 10, 2009 at 4:43 PM, Jaume Sabater <jsabater at gmail.com> wrote:

> On Fri, Jul 10, 2009 at 6:26 AM, Sridhar
> Reddapani<sridhar.reddapani at arcs.org.au> wrote:
>
> > We are using pgpool for replication with Online Recovery, Its working
> fine
> > for 1-2 Hours and then its dropping secondary back-end host[Even postgres
> on
> > it running] from pool, some times I can recover it using recovery
> scripts,
> > but some times I need to restart[ kill -9] pgpool to recover it. I
> couldnt
> > find any useful information in both pgpool and postgres logs.
>
> What do logs say at the time it degenerates the second node?
>

This is what I am having in pgpool log with debug option

2009-07-13 11:54:03 DEBUG: pid 785: health_check: 0 th DB node status: 2
2009-07-13 11:54:03 DEBUG: pid 785: health_check: 1 th DB node status: 2
2009-07-13 11:54:55 ERROR: pid 5587: pool_read: read failed (Connection
reset by peer)
2009-07-13 11:54:55 LOG:   pid 5587: notice_backend_error: 1 fail over
request from pid 5587
2009-07-13 11:54:55 ERROR: pid 5587: pool_flush_it: write failed (Broken
pipe) offset: 0 wlen: 5
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler called
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: starting to select new
master node
2009-07-13 11:54:55 LOG:   pid 785: starting degeneration. shutdown host
x.x.x.x(5433)
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 787
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 788
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 789
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 790
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 791
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 792
2009-07-13 11:54:55 DEBUG: pid 785: failover_handler: kill 793
2009-07-13 11:54:55 DEBUG: pid 788: child receives shutdown request signal 3



>
> --


> Jaume Sabater
> http://linuxsilo.net/
>
> "Ubi sapientas ibi libertas"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090713/acdbc7a9/attachment.html>