<b>pgpool 1</b><div><br></div><div><div>root@will-pgpool1:~# ps aux | grep pgpool</div><div>avahi 848 0.0 0.1 33000 2612 ? S Oct12 9:11 avahi-daemon: running [will-pgpool1.local]</div><div>root 2279 0.0 0.3 98940 6032 ? S Nov05 0:12 pgpool -n</div>
<div>root 2286 0.0 0.1 98940 1740 ? S Nov05 0:06 pgpool: lifecheck</div><div>root 2288 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2289 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2291 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2296 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2298 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2299 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2300 0.0 0.3 104296 5888 ? S Nov05 0:35 pgpool: onbrand onbrand_unify del1.local(55305) idle</div><div>root 2304 0.0 0.3 104288 5944 ? S Nov05 0:42 pgpool: onbrand onbrand_unify del1.local(55304) idle</div>
<div>root 2306 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2308 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2311 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2312 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2313 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2315 0.0 0.3 104288 5888 ? S Nov05 0:00 pgpool: onbrand onbrand_unify del1.local(55308) idle</div>
<div>root 2316 0.0 0.3 104288 5888 ? S Nov05 0:38 pgpool: onbrand onbrand_unify del1.local(55307) idle</div><div>root 2317 0.1 0.3 104288 5888 ? S Nov05 1:46 pgpool: onbrand onbrand_unify del1.local(55306) idle</div>
<div>root 2318 0.0 0.3 104288 5888 ? S Nov05 0:00 pgpool: onbrand onbrand_unify del1.local(55303) idle</div><div>root 2319 0.0 0.0 98940 1132 ? S Nov05 0:00 pgpool: PCP: wait for connection request</div>
<div>root 2320 0.0 0.1 98940 1828 ? S Nov05 0:06 pgpool: worker process</div><div>root 2391 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2486 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2522 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2546 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2551 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2595 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div>
<div>root 2672 0.0 0.0 98940 1156 ? S Nov05 0:00 pgpool: wait for connection request</div><div>root 2785 0.0 0.0 98940 1156 ? S 01:06 0:00 pgpool: wait for connection request</div>
<div>root 2827 0.0 0.0 98940 1156 ? S 01:55 0:00 pgpool: wait for connection request</div><div>root 2888 0.0 0.0 98940 1156 ? S 03:13 0:00 pgpool: wait for connection request</div>
<div>root 3000 0.0 0.0 98940 1156 ? S 05:52 0:00 pgpool: wait for connection request</div><div>root 3006 0.0 0.0 98940 1156 ? S 06:07 0:00 pgpool: wait for connection request</div>
<div>root 3724 0.0 0.0 98940 1156 ? S 10:39 0:00 pgpool: wait for connection request</div><div>root 3730 0.0 0.1 98944 2284 ? S 10:55 0:00 pgpool: wait for connection request</div>
<div>root 3731 0.0 0.0 98940 1156 ? S 11:00 0:00 pgpool: wait for connection request</div><div>root 3775 0.0 0.0 9392 924 pts/0 S+ 11:55 0:00 grep --color=auto pgpool</div><div><br></div>
<div><b>pgpool2</b></div><div><b><br></b></div><div><div>root@will-pgpool2:~# ps aux | grep pgool</div><div>root 3394 0.0 0.0 9388 916 pts/0 S+ 11:57 0:00 grep --color=auto pgool</div></div><div><br></div>
<div><br></div><div>Thanks for all your help. </div><div><br></div><div>Will</div><div><br></div><div class="gmail_quote">On 6 November 2012 11:52, 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">Could you show me lists of pgpool processes?<br>
<br>
Execute followings on the each server.<br>
<br>
$ ps aux | grep pgpool<br>
<br>
On Tue, 6 Nov 2012 11:43:57 +0000<br>
<div class="HOEnZb"><div class="h5">Will Ferguson <<a href="mailto:will.ferguson@vyre.com">will.ferguson@vyre.com</a>> wrote:<br>
<br>
> No the IP doesn't come up.<br>
><br>
> On 6 November 2012 11:06, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> wrote:<br>
><br>
> > Dose the virtual ip is bringing up on the scond pgpool server?<br>
> ><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 <<br>
> > <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<br>
> > 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<br>
> > 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<br>
> > 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<br>
> > 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:<br>
> > 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'<br>
> > 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:<br>
> > allow_to_failover on<br>
> > > > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 0<br>
> > 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<br>
> > 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<br>
> > 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:<br>
> > 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'<br>
> > 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:<br>
> > allow_to_failover on<br>
> > > > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 1<br>
> > 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<br>
> > 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<br>
> > 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:<br>
> > 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'<br>
> > 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:<br>
> > allow_to_failover on<br>
> > > > > > 2012-11-05 14:58:40 DEBUG: pid 2145: pool_config: slot number 2<br>
> > 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:<br>
> > connect()<br>
> > > > > > reports failure (Connection refused). You can safely ignore this<br>
> > 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>
> > --<br>
> > Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
> ><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><br>
</div>