Re: Fwd: Add to watchdog cluster request is rejected by node

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jean Claude <jeancld38(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Fwd: Add to watchdog cluster request is rejected by node
Date: 2018-06-11 16:56:19
Message-ID: 7d4d4a7e-963c-5451-8c04-d330608056e8@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/11/2018 06:15 AM, Jean Claude wrote:
> Hi all,
>
> How I can resolved this error after restart my pgpool-II standby ?
>
>
> Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-1] 2018-06-11 08:57:04:
> pid 3240: WARNING:  checking setuid bit of if_up_cmd
> Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [1-2] 2018-06-11 08:57:04:
> pid 3240: DETAIL:  ifup[/sbin/ip] doesn't have setuid bit
> Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [2-1] 2018-06-11 08:57:04:
> pid 3240: WARNING:  checking setuid bit of if_down_cmd
> Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [2-2] 2018-06-11 08:57:04:
> pid 3240: DETAIL:  ifdown[/sbin/ip] doesn't have setuid bit
> Jun 11 08:57:04 asa-pgpool02 pgpool[3240]: [3-1] 2018-06-11 08:57:04:
> pid 3240: LOG:  waiting for watchdog to initialize
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [3-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  setting the local watchdog node name to
> "asa-pgpool02.adm.cacc.ch:5432 <http://asa-pgpool02.adm.cacc.ch:5432>
> Linux asa-pgpool02"
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [4-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  watchdog cluster is configured with 1 remote nodes
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [5-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  watchdog remote node:0 on asa-pgpool01.adm.cacc.ch:9000
> <http://asa-pgpool01.adm.cacc.ch:9000>
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [6-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  interface monitoring is disabled in watchdog
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [7-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  watchdog node state changed from [DEAD] to [LOADING]
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [8-1] 2018-06-11 08:57:04:
> pid 3241: LOG:  new outbound connection to asa-pgpool01.adm.cacc.ch:9000
> <http://asa-pgpool01.adm.cacc.ch:9000>
> Jun 11 08:57:04 asa-pgpool02 pgpool[3241]: [9-1] 2018-06-11 08:57:04:
> pid 3241: *FATAL:  Add to watchdog cluster request is rejected by node
> "asa-pgpool01.adm.cacc.ch:9000 <http://asa-pgpool01.adm.cacc.ch:9000>"*

I don't use pgpool, but looks to me like asa-pgpool01.adm.cacc.ch is not
set up for watchdog mode.

Have you looked at this:

http://www.pgpool.net/docs/latest/en/html/example-watchdog.html

If that does not help then I would suggest asking here:

https://www.pgpool.net/mailman/listinfo/pgpool-general

> *
> *
> pgpool-II version :*
> *pgpool-II version 3.7.3 (amefuriboshi)*
>
> *
> Thanks.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-06-11 17:00:05 Re: Sort is generating rows
Previous Message Alvaro Herrera 2018-06-11 15:47:59 Re: ALTER TABLE SET (toast.asdf) is not rejected