[pgpool-general: 1158] Re: Watchdog error - wd_init: delegate_IP already exists

Lonni J Friedman netllama at gmail.com
Tue Nov 6 00:07:25 JST 2012


I've seen this happen often a well.  I'm guessing that there's a race
condition somewhere.

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


More information about the pgpool-general mailing list