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

Tue Nov 6 19:59:16 JST 2012

Thanks but leaving the first pgpool instance running for hours before
starting the second still doesn't help. Strange that it is fine the other
way around. I'll keep my eye out for the fix.

Thanks,

Will

On 6 November 2012 00:20, Yugo Nagata <nagata at sraoss.co.jp> wrote:

> Wait a few seconds after the first pgpool has started.
> Then, you would be able to start the second successfully.
>
> I recognize this problem and am trying to resolve it.
>
> On Mon, 5 Nov 2012 07:07:25 -0800
> Lonni J Friedman <netllama at gmail.com> wrote:
>
> > 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)
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Yugo Nagata <nagata at sraoss.co.jp>
>

-- 
Technical Operations Manager

VYRE LTD****

Zetland House****

Ground Floor****

5-25 Scrutton Street****

London****

EC2A 4HJ

0207 749 1800

07825 536 416
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20121106/856da24d/attachment.html>