No the IP doesn't come up. <br><br><div class="gmail_quote">On 6 November 2012 11:06, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Dose the virtual ip is bringing up on the scond pgpool server?<br>
<div><div class="h5"><br>
On Tue, 6 Nov 2012 10:59:16 +0000<br>
Will Ferguson <<a href="mailto:will.ferguson@vyre.com">will.ferguson@vyre.com</a>> wrote:<br>
<br>
> Thanks but leaving the first pgpool instance running for hours before<br>
> starting the second still doesn't help. Strange that it is fine the other<br>
> way around. I'll keep my eye out for the fix.<br>
><br>
> Thanks,<br>
><br>
> Will<br>
><br>
> On 6 November 2012 00:20, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> wrote:<br>
><br>
> > Wait a few seconds after the first pgpool has started.<br>
> > Then, you would be able to start the second successfully.<br>
> ><br>
> > I recognize this problem and am trying to resolve it.<br>
> ><br>
> > On Mon, 5 Nov 2012 07:07:25 -0800<br>
> > Lonni J Friedman <<a href="mailto:netllama@gmail.com">netllama@gmail.com</a>> wrote:<br>
> ><br>
> > > I've seen this happen often a well. I'm guessing that there's a race<br>
> > > condition somewhere.<br>
> > ><br>
> > > On Mon, Nov 5, 2012 at 7:00 AM, Will Ferguson <<a href="mailto:will.ferguson@vyre.com">will.ferguson@vyre.com</a>><br>
> > wrote:<br>
> > > > Hello<br>
> > > ><br>
> > > > I have two pgpool servers: will-pgpool1 & will-pgpool2 with watchdog<br>
> > enabled<br>
> > > ><br>
> > > > I can start will-pgpool2 first which takes the virtual IP, and then<br>
> > start<br>
> > > > will-pgpool1 and all works fine.<br>
> > > ><br>
> > > > But if I start will-pgpool1 first which takes the virtual IP, and then<br>
> > start<br>
> > > > will-pgpool2 the pgpool2 server doesn't start.<br>
> > > ><br>
> > > > Both pgpool.conf files are the same except wd_hostname and<br>
> > > > other_pgpool_hostname0<br>
> > > ><br>
> > > > Both instances are started as root with -d -n<br>
> > > ><br>
> > > > Below is the log debug output.<br>
> > > ><br>
> > > > Thanks,<br>
> > > ><br>
> > > > Will<br>
> > > ><br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: listen_addresses<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '*' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: port<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 9999 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: socket_dir<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '/tmp' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: pcp_port<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 9898 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: pcp_socket_dir<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '/tmp' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db1' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 0<br>
> > > > weight: 1.000000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag0<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token:<br>
> > > > ALLOW_TO_FAILOVER<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 0 flag:<br>
> > 0000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db2' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 1<br>
> > > > weight: 1.000000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token:<br>
> > > > ALLOW_TO_FAILOVER<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 1 flag:<br>
> > 0000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_hostname2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'will-db3' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_port2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 5432 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: port slot number 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_weight2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 1 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: weight slot number 2<br>
> > > > weight: 1.000000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_data_directory2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: '/data/postgres' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: backend_flag2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'ALLOW_TO_FAILOVER' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: extract_string_tokens: token:<br>
> > > > ALLOW_TO_FAILOVER<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: allow_to_failover on<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 2 flag:<br>
> > 0000<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: enable_pool_hba<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: authentication_timeout<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 60 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: ssl<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: num_init_children<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 32 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: max_pool<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 4 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: child_life_time<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 300 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: child_max_connections<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: connection_life_time<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: client_idle_limit<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_destination<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'stderr' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: print_timestamp<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_connections<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_hostname<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: on kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_statement<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_per_node_statement<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: off kind: 1<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: w<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value:<br>
> > > > kind: 7<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: log_standby_delay<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'always' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: syslog_facility<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'LOCAL0' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: syslog_ident<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 'pgpool' kind: 4<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: key: debug_level<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: value: 0 kind: 2<br>
> > > > 2012-11-05 14:58:40 DEBUG: pid 2145: loading<br>
> > "/usr/local/etc/pool_hba.conf"<br>
> > > > for client authentication configuration file<br>
> > > > 2012-11-05 14:58:40 LOG: pid 2145: wd_chk_sticky:<br>
> > ifup[/sbin/ifconfig]<br>
> > > > doesn't have sticky bit<br>
> > > > 2012-11-05 14:58:40 LOG: pid 2145: wd_create_send_socket: connect()<br>
> > > > reports failure (Connection refused). You can safely ignore this while<br>
> > > > starting up.<br>
> > > > 2012-11-05 14:58:42 ERROR: pid 2145: wd_init: delegate_IP already<br>
> > exists<br>
> > > > 2012-11-05 14:58:42 ERROR: pid 2145: watchdog: wd_init failed<br>
> > > > 2012-11-05 14:58:42 ERROR: pid 2145: wd_main error<br>
> > > > 2012-11-05 14:58:42 ERROR: pid 2145: unlink(/tmp/.s.PGSQL.9898)<br>
> > failed: No<br>
> > > > such file or directory<br>
> > > > 2012-11-05 14:58:42 DEBUG: pid 2145: shmem_exit(1)<br>
> > > _______________________________________________<br>
> > > pgpool-general mailing list<br>
> > > <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
> > > <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
> ><br>
> ><br>
> > --<br>
> > Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
> ><br>
><br></div></div><span class="HOEnZb"><font color="#888888">--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
</font></span></blockquote></div><br>