[pgpool-general: 1521] Re: pcp_detach_node isn't detaching the node

[David Kerr]

On Thu, Mar 21, 2013 at 02:08:51PM -0700, Lonni J Friedman wrote:
- On Thu, Mar 21, 2013 at 2:07 PM, David Kerr <web at mr-paradox.net> wrote:
- > This is 3.2.2 on linux.
- >
- > i'm trying to detach a slave node.
- >
- > pcp_detach_node -d 10 localhost 9898 user password 1
- >
- > DEBUG: send: tos="R", len=46
- > DEBUG: recv: tos="r", len=21, data=AuthenticationOK
- > DEBUG: send: tos="D", len=6
- > DEBUG: recv: tos="d", len=20, data=CommandComplete
- > DEBUG: send: tos="X", len=4
- >
- > But when i connect it's still sending queries to the node.
- 
- How are you connecting?  How are you determining that pgpool is still
- sending queries to the node?  What does the pgpool log say?
- 

Ah, yeah right in the logs, brain turns off sometimes. thanks.

Mar 21 20:59:02 pgp04 pgpool[2100]: degenerate_backend_set: 1 failover request from pid 2100 is canceld
because failover is disallowed