Add to watchdog cluster request is rejected by node

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 <http://asa-pgpool01.adm.cacc.ch:9000&gt;&quot;*

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

Thanks.

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&gt;
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&gt;
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&gt;
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&gt;&quot;*

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

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&gt;&quot;*

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

Thanks.

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