[pgpool-general: 7211] Re: Watchdog does not perform if_down_cmd

[Anssi Kanninen]

Hi Brian,

Your ip_up_cmd has no label-parameter. I don't know if it's mandatory.
My config is:

if_up_cmd = '/usr/bin/sudo /usr/sbin/ip addr add $_IP_$/24 dev enp0s8 label enp0s8:0'
if_down_cmd = '/usr/bin/sudo /usr/sbin/ip addr del $_IP_$/24 dev enp0s8'

Best regards,
   - Anssi Kanninen

On Thu, 20 Aug 2020, Branislav Viest wrote:

> Hello,
> 
> I've been using pgpool watchdog within two nodes about 2 years. A couple of months, after probably some
> upgrade - I don't know what version exactly, problem describe bellow we experienced suddenly when pg-pool
> nodes switchover was triggered - we are experiencing problem with if_down_cmd command which is not executed
> when pg-pool is going down (service stop or restart). In the if_down_cmd directive I have on both servers:
> 
> /usr/bin/sudo /sbin/ip addr del $_IP_$/24 dev eth0
> 
> sudo is configured (if_up_cmd works properly, the configuration variable is: /usr/bin/sudo /sbin/ip addr add
> $_IP_$/24 dev eth0). iface is named eth0, so iface name is correct.
> 
> The expected behaviour is remove/unbind failover ip from eth0 inet interface. Actually, nothing has happened.
> The pgpool is stopped correctly but IP is still assigned on the iface. The problem is, the second node which
> is becoming a master is also bind this FO IP.
> 
> My pgpool version is 4.1.2-2.pgdg100+1 - latest from Debian Buster repo. Updated yesterday to this version,
> issue tested and still remains. In the logs is nothing during the shutdown period. During startup, if ip
> remained binded, there is just error message  that if_up_cmd command was not successful, because, apparently,
> ip is binded already. But during shutdown, there is no error message about if_down_cmd.
> 
> Do you guys have any ideas on how to solve this or what should be the problem?
> 
> Thanks in advance.
> 
> ------------
> Brian
> 
> ------------
> Legal Disclaimer: This e-mail and any attached files are confidential and may be legally privileged. If you
> are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of
> this communication is strictly prohibited. If you have received this transmission in error please notify the
> sender immediately and then delete this e-mail. The sender does not accept liability for the correct and
> complete transmission of the information, nor for any delay or interruption of the transmission, nor for
> damages arising from the use of or reliance on the information. All e-mail messages addressed to, received or
> sent by sender are deemed to be professional in nature. Accordingly, the sender or recipient of these messages
> agrees that they may be read by other sender employees than the official recipient or sender in order to
> ensure the continuity of work-related activities and allow supervision thereof.
> 
>

-- 
anssi at iki.fi