[Pgpool-general] FailoverInProgress message on executing pcp_recovery_node in pgpool-II 3.1
Sandeep Thakkar
sandeeptt at yahoo.com
Fri Nov 11 10:58:26 UTC 2011
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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111111/5c1002a3/attachment-0001.html>
More information about the Pgpool-general
mailing list