Postgres Pro
Downloads
Home   >   mailing lists

Thread: Add to watchdog cluster request is rejected by node

Add to watchdog cluster request is rejected by node

From
Jean Claude
Date:
Hi,

The following error is a bug ?

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 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
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
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"

pgpool-II version :
pgpool-II version 3.7.3 (amefuriboshi)

Thanks.

Fwd: Add to watchdog cluster request is rejected by node

From
Jean Claude
Date:
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 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
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
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"

pgpool-II version :
pgpool-II version 3.7.3 (amefuriboshi)

Thanks.

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

From
Adrian Klaver
Date:
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.klaver@aklaver.com

Re: Add to watchdog cluster request is rejected by node

From
Bo Peng
Date:
Hi,

I think it would be better to make questions in the Pgpool-II dedicated 
mailing list pgpool-general@pgpool.net.

> 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

It seems like that the parameters "if_up_cmd" and "if_down_cmd" 
are not set correctly
Please make sure you set correct network interface name.

For example, if your network interface name is "ens192",
you need set that like:

---
if_up_cmd   = 'ip addr add $_IP_$/24 dev ens192 label ens192:0'
if_down_cmd = 'ip addr del $_IP_$/24 dev ens192'                              
arping_cmd  = 'arping -U $_IP_$ -w 1 -I ens192'
---

On Mon, 11 Jun 2018 15:06:35 +0200
Jean Claude <jeancld38@gmail.com> wrote:

> Hi,
> 
> The following error is a bug ?
> 
> 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 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
> 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
> 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>"*
> 
> pgpool-II version :
> pgpool-II version 3.7.3 (amefuriboshi)
> 
> Thanks.


-- 
Bo Peng <pengbo@sraoss.co.jp>
SRA OSS, Inc. Japan