[pgpool-general: 3326] Re: Watchdog - ifconfig up failed

[Ryan DeShone]

You should check your system logs. I had a similar problem at first because pgpool did not have a tty once it was running in the background. By default, sudo will not allow execution without a tty. I had to set the following in sudoers to get IP management via sudo to work

Defaults:postgres !requiretty

This assumes, of course, that pgpool is running as the postgres user.
On 12/01/2014 04:11 AM, Christian Affolter wrote:
> Hi
>
> On 27.11.2014 17:38, Jérôme Schell wrote:
> > Hello all,
> >
> > I am facing a strange problem with PGPool 3.3.4 in a 2 nodes cluster
> > setup using the watchdog feature.
> > It seems that when switching to master status the "ifconfig up" command
> > always fails (exit status 127). When initially starting, the same
> > command succeeds.
> >
> > I have tried several configurations:
> > * Using "sudo" in the command with pgpool running as postgres user
> > (running the command from the command line is ok)
> > * Using direct command with pgpool running as root
> >
> > Everythime I stop the master Pgpool I get this log on the slave that
> > takes over the delegate IP:
> > Nov 27 16:13:34 db02 pgpool[27600]: wd_escalation: escalating to master
> > pgpool
> > Nov 27 16:13:34 db02 pgpool[27600]: exec_ifconfig: 'sudo /bin/ip addr
> > add xxx.xxx.xxx.xxx/24 dev bond0' failed. exit status: 127
> > Nov 27 16:13:34 db02 pgpool[27600]: wd_IP_up: ifconfig up failed
> > Nov 27 16:13:34 db02 pgpool[27600]: wd_declare: send the packet to
> > declare the new master
> > Nov 27 16:13:34 db02 pgpool[27600]: wd_escalation: escalated to master
> > pgpool with some errors
> > Nov 27 16:13:34 db02 pgpool[27603]: exec_ping: succeed to ping
> > xxxx.xxx.xxx.xxx
> >
> > The strange thing is that the IP is well assigned to the interface but
> > the arping command is not run leaving the arp table of other hosts in
> > bad state.
>
> I'm facing the exact same issue with pgpool-II 3.4.0. Also using "sudo
> /bin/ip ..." as the if_up_cmd/if_down_cmd command.
>
>
> Regards
> Christian
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>

-- 
Ryan DeShone