I'm using pgpool-II 3.1 and configured it in Streaming Replication mode. What I notice is that as soon as the
Master goes down, the pgpool server process and all the client processes die. I see only "pgpool: PCP: wait for connection request" and "pgpool: worker process" processes. Though the failover actually happens and I see that Standby is promoted to Master now. When I try to recover the old Master, I see the following message: [edb@localhost regress]$ $PGPOOL_INST/bin/pcp_recovery_node -d 20 localhost $PCP_PORT edb edb 0 DEBUG: send: tos="R", len=41 DEBUG: recv: tos="r", len=21, data=AuthenticationOK DEBUG: send: tos="D", len=6 DEBUG: recv: tos="e", len=23, data=FailoverInProgress DEBUG: command failed. reason=FailoverInProgress BackendError DEBUG: send: tos="X", len=4 My question is "why the pgpool server process and child processes got terminated?" The same configuration works fine against pgpool-II 3.0.3. The only difference between the two configuration is that we added 2 new directives in pgpool.conf, backend_flag and follow_master_command (set same as failover_command). I see the following lines in the pgpool.log: 2011-11-11 15:41:44 ERROR: pid 27642: health check failed. 0 th host localhost at port 5445 is down 2011-11-11 15:41:44 LOG: pid 27642: set 0 th backend down status 2011-11-11 15:41:44 DEBUG: pid 27642: failover_handler called 2011-11-11 15:41:44 DEBUG: pid 27642: failover_handler: starting to select new master node 2011-11-11 15:41:44 LOG: pid 27642: starting degeneration. shutdown host localhost(5445) 2011-11-11 15:41:44 LOG: pid 27642: Restart all children 2011-11-11 15:41:44 DEBUG: pid 27643: child received shutdown request signal 3 2011-11-11 15:41:44 DEBUG: pid 27642: failover_handler: kill 27643 ... ... 2011-11-11 15:41:44 DEBUG: pid 27642: failover_handler: kill 27674 2011-11-11 15:41:44 LOG: pid 27642: execute command: touch /home/edb/AS91/edb-postgres/edb-postgres/src/test/regress/tmp_pgpool/failover.log 2011-11-11 15:41:45 DEBUG: pid 27661: child received shutdown request signal 3 2011-11-11 15:41:45 LOG: pid 27642: find_primary_node_repeatedly: waiting for finding a primary node 2011-11-11 15:41:45 ERROR: pid 27642: make_persistent_db_connection: s_do_auth failed 2011-11-11 15:41:45 ERROR: pid 27642: find_primary_node: make_persistent_connection failed Have I missed to set any more new directives? Kindly help! Thanks.
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
