[pgpool-general: 4337] pgpool drops connetion when detaching...Please Help!

[Shay Cohavi]

Hi,

*using postgresql 9.3.1 and pgpool 3.4.2*

I have an manager application (C++ based) which is checking the pgpool
server (show pool_nodes; ) every 20ms.

one of its operations is to perform a switchover between the postgres nodes
in case of a user demand!

while performing pcp_detach_node (via pgpool sql admin):
1. all the  pgool connections (356 connections from my application to the
pgpool ) gets dropped.
2. the 'show pool_nodes' connection gets dropped and the only way to
connect to the pgpool is to *reestablish a new connection*!

I'm detaching via:
*select pcp_detach_node(0,False,'192.168.15.59',500,9898,'user','pass');*


this is an cli example which demonstrate this issue:

postgres=# show pool_nodes;
 node_id | hostname | port | status | lb_weight |  role
---------+----------+------+--------+-----------+---------
 0       | 1.1.1.55 | 5432 | 2      | 0.500000  | standby
 1       | 1.1.1.56 | 5432 | 2      | 0.500000  | primary
(2 rows)


[root at mgrdb-56 ~]# pcp_detach_node -d 10 192.168.15.59 9898 username upass 0
DEBUG: send: tos="R", len=44
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

postgres=# show pool_nodes;
The connection to the server was lost. Attempting reset: Succeeded.


postgres=# show pool_nodes;
 node_id | hostname | port | status | lb_weight |  role
---------+----------+------+--------+-----------+---------
 0       | 1.1.1.55 | 5432 | 3      | 0.500000  | standby
 1       | 1.1.1.56 | 5432 | 2      | 0.500000  | primary

Can you please advice....

Thanks,
Shay C
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160118/9065f9db/attachment.html>