[pgpool-general: 3828] PGPool-II 3.4.2-1 not saving db state on node detach

[James Elsdon]

Hi there,

I'm not sure if it's the intended behavior, but I'm seeing on PGPool-II
3.4.2-1 that if I use pcp_detach_node - it works successfully but is not
persistent across pgpool restarts.

When the node dies naturally (pgpool detaches it), the status file works
correctly - this is only on a manual pcp_detach_node

[me at host ~]$ /usr/pgsql-9.2/bin/psql -U psgsuser -h psghost -p pgport -c
'show pool_nodes'
 node_id |    hostname    | port | status | lb_weight |  role
---------+----------------+------+--------+-----------+--------
 0       | host1          | 5432 | 2      | 0.500000  | master
 1       | host2          | 5432 | 2      | 0.500000  | slave
(2 rows)

[me at host ~]$ /usr/pgpool-9.2/bin/pcp_detach_node 10 localhost 9898 pcpuser
pcppass 1

[me at host ~]$ /usr/pgsql-9.2/bin/psql -U psgsuser -h psghost -p pgport -c
'show pool_nodes'
 node_id |    hostname    | port | status | lb_weight |  role
---------+----------------+------+--------+-----------+--------
 0       | host1          | 5432 | 2      | 0.500000  | master
 1       | host2          | 5432 | 3      | 0.500000  | slave
(2 rows)

[me at host ~]$ sudo cat /var/log/pgpool/pgpool_status
up
up

[me at host ~]$ sudo /etc/init.d/pgpool-II-92 stop
Stopping pgpool-II-92 service:                             [  OK  ]

[me at host ~]$ sudo cat /var/log/pgpool/pgpool_status
up
up

[me at host ~]$ sudo /etc/init.d/pgpool-II-92 start
Starting pgpool-II-92 service:                             [  OK  ]

[me at host ~]$ /usr/pgsql-9.2/bin/psql -U psgsuser -h psghost -p pgport -c
'show pool_nodes'
 node_id |    hostname    | port | status | lb_weight |  role
---------+----------------+------+--------+-----------+--------
 0       | host1          | 5432 | 2      | 0.500000  | master
 1       | host2          | 5432 | 2      | 0.500000  | slave
(2 rows)

[me at host ~]$ sudo cat /var/log/pgpool/pgpool_status
up
up


Is this the intended behavior of pcp_detach_node ?

Thanks and regards,
James Elsdon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150622/397c3351/attachment.htm>