<div>Hello</div><div><br></div><div>I have two pgpool servers: will-pgpool1 & will-pgpool2 with watchdog enabled</div><div><br></div><div>I can start will-pgpool2 first which takes the virtual IP, and then start will-pgpool1 and all works fine. </div>
<div><br></div><div>But if I start will-pgpool1 first which takes the virtual IP, and then start will-pgpool2 the pgpool2 server doesn't start.</div><div><br></div><div>Both pgpool.conf files are the same except wd_hostname and other_pgpool_hostname0</div>
<div><br></div><div>Both instances are started as root with -d -n</div><div><br></div><div>Below is the log debug output. </div><div><br></div><div>Thanks, </div><div><br></div><div>Will</div><div><br></div><div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: listen_addresses</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '*' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: port</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 9999 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: socket_dir</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '/tmp' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: pcp_port</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 9898 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: pcp_socket_dir</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '/tmp' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname0</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db1' kind: 4</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port0</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 0 </div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight0</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 0 weight: 1.000000</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory0</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag0</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token: ALLOW_TO_FAILOVER</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 0 flag: 0000</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db2' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port1</div><div>
2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 1 </div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 1 weight: 1.000000</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token: ALLOW_TO_FAILOVER</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 1 flag: 0000</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db3' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 2 </div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 2 weight: 1.000000</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token: ALLOW_TO_FAILOVER</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 2 flag: 0000</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: enable_pool_hba</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1</div><div>
2012-11-05 14:58:40 DEBUG: pid 2145: key: authentication_timeout</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 60 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: ssl</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: num_init_children</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 32 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: max_pool</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 4 kind: 2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: child_life_time</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 300 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: child_max_connections</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: connection_life_time</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: client_idle_limit</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_destination</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'stderr' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: print_timestamp</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_connections</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_hostname</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_statement</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_per_node_statement</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: w</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: </div><div> kind: 7</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: log_standby_delay</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'always' kind: 4</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: syslog_facility</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'LOCAL0' kind: 4</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: key: syslog_ident</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 'pgpool' kind: 4</div>
<div>2012-11-05 14:58:40 DEBUG: pid 2145: key: debug_level</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2</div><div>2012-11-05 14:58:40 DEBUG: pid 2145: loading "/usr/local/etc/pool_hba.conf" for client authentication configuration file</div>
<div>2012-11-05 14:58:40 LOG: pid 2145: wd_chk_sticky: ifup[/sbin/ifconfig] doesn't have sticky bit</div><div>2012-11-05 14:58:40 LOG: pid 2145: wd_create_send_socket: connect() reports failure (Connection refused). You can safely ignore this while starting up.</div>
<div>2012-11-05 14:58:42 ERROR: pid 2145: wd_init: delegate_IP already exists</div><div>2012-11-05 14:58:42 ERROR: pid 2145: watchdog: wd_init failed</div><div>2012-11-05 14:58:42 ERROR: pid 2145: wd_main error</div><div>
2012-11-05 14:58:42 ERROR: pid 2145: unlink(/tmp/.s.PGSQL.9898) failed: No such file or directory</div><div>2012-11-05 14:58:42 DEBUG: pid 2145: shmem_exit(1)</div></div><div><br></div>