[pgpool-general: 8082] delegate_IP and three nodes in cluster

[Rozmus Andrzej]

Hello Tatsuo,
I set up three-node cluster and I encountered problem with setting up vip address (delegate_IP) during service startup - although I can set it up manually later using the same command like in "if_up_cmd" parameter. Below i attach details of my configuration (watchdog section):
#------------------------------------------------------------------------------
# WATCHDOG
#------------------------------------------------------------------------------

# - Enabling -

use_watchdog = on

# -Connection to up stream servers -
trusted_servers = ''
#ping_path = '/bin'

# - Watchdog communication Settings -

hostname0 = 'pgs13-1'
wd_port0 = 9000
pgpool_port0 = 5433

hostname1 = 'pgs13-2'
wd_port1 = 9000
pgpool_port1 = 5433

hostname2 = 'pgs13-3'
wd_port2 = 9000
pgpool_port2 = 5433

#wd_priority = 1
#wd_authkey = ''
#wd_ipc_socket_dir = '/tmp'

# - Virtual IP control Setting -

delegate_IP = '10.7.181.94'
if_cmd_path = '/sbin'
if_up_cmd = '/usr/bin/sudo /sbin/ip addr add 10.7.181.94/24 dev eth0 label eth0:0'
if_down_cmd = '/usr/bin/sudo /sbin/ip addr del 10.7.181.94/24 dev eth0'
arping_path = '/usr/sbin'
arping_cmd = '/usr/bin/sudo /usr/sbin/arping -U 10.7.181.94 -w 1 -I eth0'

# - Behaivor on escalation Setting -
clear_memqcache_on_escalation = on
#wd_escalation_command = ''
#wd_de_escalation_command = ''

# - Watchdog consensus settings for failover -

failover_when_quorum_exists = on
failover_require_consensus = on
allow_multiple_failover_requests_from_node = off
enable_consensus_with_half_votes = off

# - Watchdog cluster membership settings for quorum computation -

wd_remove_shutdown_nodes = off
#wd_lost_node_removal_timeout = 0s
#wd_no_show_node_removal_timeout = 0s

# - Lifecheck Setting -

# -- common --

wd_monitoring_interfaces_list = 'any'
wd_lifecheck_method = 'heartbeat'
#wd_interval = 10

# -- heartbeat mode --

heartbeat_hostname0 = 'pgs13-1'
heartbeat_port0 = 9694
heartbeat_device0 = ''
heartbeat_hostname1 = 'pgs13-2'
heartbeat_port1 = 9694
heartbeat_device1 = ''
heartbeat_hostname2 = 'pgs13-3'
heartbeat_port2 = 9694
heartbeat_device2 = ''

#wd_heartbeat_keepalive = 2
#wd_heartbeat_deadtime = 30


# -- query mode --

#wd_life_point = 3
#wd_lifecheck_query = 'SELECT 1'
#wd_lifecheck_dbname = ''
#wd_lifecheck_user = ''
#wd_lifecheck_password = ''

################################################################
When i comment last node in "Watchdog Communication Settings" section to

#hostname2 = 'pgs13-3'
#wd_port2 = 9000
#pgpool_port2 = 5433

and change
enable_consensus_with_half_votes = off
to
enable_consensus_with_half_votes = on

everything works fine - pgpool service starts and i see delegate IP. Do you have any idea what might be a cause of such problem? Version of my pgpool is 4.3.1 (tamahomeboshi) installed from official postgresql repository for SLES 15. I checked logs but i don't see any errors...?
Thanks in advance for help.
Best Regards

Andrzej Rozmus
Starszy Technolog
Departament Systemów Administracji Rządowej
Dział Ministerstwo Finansów
Zespół Projektowy AIS/AES
Asseco Poland S.A.
ul. Branickiego 13
02-972 Warszawa
tel. kom. +48 502 270 059
andrzej.rozmus at asseco.pl

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220413/35758a1e/attachment.htm>