[pgpool-general: 2730] Re: pgpool 3.3.3 watchdog problem

[Granthana Biswas]

Alexandru,

I had faced the same problem. During initial setup, when you first start
the pgpool master keep use_watchdog=off. Start the master. On pgpool slave,
keep use_watchdog=on. Start pgpool slave.

Now stop pgpool master. Make use_watchdog=on on master pgpool and start
again. Restart the slave pgpool to make the other pgpool the master.

Let me know if that helps.


Regards,
Granthana


On Tue, Apr 8, 2014 at 1:45 AM, Alexandru Cardaniuc <cardaniuc at gmail.com>wrote:

> Hi,
>
>
> Is pgpool 3.3.3 having a watchdog problem?
>
> I have a 2 node cluster.
> pgpool on 10.0.90.11
> pgpool on 10.0.90.12
> delegate_IP = 10.0.90.1 and was set on primary pgpool (10.0.90.11)
> now both pgpool have the delegate_IP up:
>
> # ifconfig
> eth0      Link encap:Ethernet  HWaddr 00:1D:55:14:B1:BD
>           inet addr:10.0.90.11  Bcast:10.0.255.255  Mask:255.255.0.0
>           inet6 addr: fe80::21d:55ff:fe14:b1bd/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:26828863 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:32509057 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:2808044025 (2.6 GiB)  TX bytes:4026576497 (3.7 GiB)
>
> eth0:0    Link encap:Ethernet  HWaddr 00:1D:55:14:B1:BD
>           inet addr:10.0.90.1  Bcast:10.0.255.255  Mask:255.255.0.0
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>
> # ifconfig
> eth0      Link encap:Ethernet  HWaddr 00:1D:55:34:D0:86
>           inet addr:10.0.90.12  Bcast:10.0.255.255  Mask:255.255.0.0
>           inet6 addr: fe80::21d:55ff:fe34:d086/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:16619236 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:15740439 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:1676092603 (1.5 GiB)  TX bytes:2112486773 (1.9 GiB)
>
> eth0:0    Link encap:Ethernet  HWaddr 00:1D:55:34:D0:86
>           inet addr:10.0.90.1  Bcast:10.0.255.255  Mask:255.255.0.0
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>
> 10.0.90.1 should be up only on the 10.0.90.11 at this point.
>
> Looks like earlier today watchdog became confused:
> on 10.0.90.11 from pgpool.log:
> 2014-04-07 11:42:31 DEBUG: pid 11380: wd_hb_receiver: received heartbeat
> signal from 10.0.90.12:9999
> 2014-04-07 11:42:32 DEBUG: pid 11382: check_pgpool_status_by_hb: checking
> pgpool 0 (10.0.90.11:9999)
> 2014-04-07 11:42:32 DEBUG: pid 11382: check_pgpool_status_by_hb: OK;
> status 3
> 2014-04-07 11:42:32 DEBUG: pid 11382: check_pgpool_status_by_hb: checking
> pgpool 1 (10.0.90.12:9999)
> 2014-04-07 11:42:32 LOG:   pid 11382: check_pgpool_status_by_hb: pgpool 1 (
> 10.0.90.12:9999) is in down status
> 2014-04-07 11:42:32 DEBUG: pid 11381: wd_hb_send: send 224 byte packet
> 2014-04-07 11:42:32 DEBUG: pid 11381: wd_hb_sender: send heartbeat signal
> to 10.0.90.12:9694
> 2014-04-07 11:42:33 DEBUG: pid 11380: wd_hb_recv: received 224 byte packet
>
> also same from 10.0.90.12
> 2014-04-07 11:15:44 DEBUG: pid 12975: check_pgpool_status_by_hb: checking
> pgpool 1 (10.0.90.11:9999)
> 2014-04-07 11:15:44 LOG:   pid 12975: check_pgpool_status_by_hb: pgpool 1 (
> 10.0.90.11:9999) is in down status
>
> Using pgpool 3.3.3 and replication configured using postgres 8.4.4
>
>
> --
> Sincerely yours,
> Alexandru Cardaniuc
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140408/7f2cdd8c/attachment.html>