On Fri, Jul 10, 2009 at 4:43 PM, Jaume Sabater <[email protected]> wrote:
> On Fri, Jul 10, 2009 at 6:26 AM, Sridhar > Reddapani<[email protected]> 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" >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
