Date: Wed, 19 Jun 2024 13:42:40 +0900
From: Bo Peng <pengbo@sraoss.co.jp>
To: Mukesh Tanuku <mukesh.postgres@gmail.com>
Cc: pgpool-general@pgpool.net, pgsql-general@lists.postgresql.org,
 "vijay.postgres@gmail.com" <vijay.postgres@gmail.com>,
 bharat.hegde.k@maersk.com
Subject: Re: [pgpool-general: 9132] Pgpool delegate IP is not reachable from
 the remote host
Message-Id: <20240619134240.7fd75ea857aafccaca4d70ea@sraoss.co.jp>
In-Reply-To: <CAJzgB-F0ej-1cD0whoGZohzd8Fdf=+OWuyEkDM1U+N5gst4Afg@mail.gmail.com>
References: <CAJzgB-F0ej-1cD0whoGZohzd8Fdf=+OWuyEkDM1U+N5gst4Afg@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?us-ascii?Q?8QpNppBa+8GxPeIr4a97MAIj/1AWM6EQIl7aNHNm7kmn5p/TfhtoF72GJWpg?=
 =?us-ascii?Q?texOyAFOE0B0wXm+mvTGG3Gv/tl8vjtr9BynIoPBXoTGAkvIPIpeXXTmYBA/?=
 =?us-ascii?Q?rpG80UTLc/obnmDBifV7NDSxBmO7y5N8u+Qf1Q7PXaHEP3/JyJ+bkbG1bU5r?=
 =?us-ascii?Q?MXHOu9MakIrOUZYmmsfkZMdDyOgEkc/TZ2KFAsEWV/jUM8VWlQefAwuDXZA8?=
 =?us-ascii?Q?0fEVRzEdcJYf+M27MA1PgJhdpuHGwKGHQcKxGZd+aqXvtsXjIYOVFlHfHW3l?=
 =?us-ascii?Q?kBSMDu7//8RtC4dvxP2LNUHqCU76BJh86v2tPFLGxi2Vl3cu9i4Gj/7fwVnK?=
 =?us-ascii?Q?/r3+rhtn03BY3gO0/DpzSRvxWEWratZIrt5ThGaVUuHzc+BRVohTNIocR3nZ?=
 =?us-ascii?Q?wMc4asca3qU/LvaPckoMI36bsnKcThyicy+PFa1JS1PDLeCP+DliyoQOyKRJ?=
 =?us-ascii?Q?xJ49HVhTHXM19Po8HPMQTlImkAXJDI7ui14AsuLJgJorlcx8Uo9Q4A7AQu/I?=
 =?us-ascii?Q?+693SojBZoAhqfFv/Fp93gn0Zn/9jEBcgxkqWWl3R3xb6MfXZ/IfLWTbKZ3I?=
 =?us-ascii?Q?Px6fN0RDmO8ps3EetCiNyNWa8zIVYTnmdip8F84v2TARS7G2vT5OdCKOfZdo?=
 =?us-ascii?Q?5bb3ILcpfCKQMk8HiHez/E3JFLGObxfN4e9PsfHEkLTrJW7July+F/vwVSFb?=
 =?us-ascii?Q?/7t9gr7XGwh0WrGqMIY3mOLOF0LqyFkwuJ2Fc/zSCJyQeww6Om607HNQUWKj?=
 =?us-ascii?Q?zk167jjbrTssGbVyoL/8x5DRFqra8g++r3kwG/5laU9njdLUxB6mI5btvFFv?=
 =?us-ascii?Q?pD4jlOropWhNWa2yCEib9SKB3VFo4rA0Mn/MndSXUSPyiF7h0oaWoT+9F2D/?=
 =?us-ascii?Q?+IEf4doL4EMQ4GHIAs46PlNxzHtilLti9JZrpuCcr09Xk4iqoTWONuAyJxtR?=
 =?us-ascii?Q?mzCif3Fx3U8VzK1l6Cuh7KRsiY4iiF4Eiq3y+Yen1dgCNMbP/swtfnqxtpFQ?=
 =?us-ascii?Q?Ljjnrhxp5e9WHAGqc/TAq39w3kRLxhXi26EkxiZlDEJDw/KrHTX8t70lwvWo?=
 =?us-ascii?Q?z4k7N3PVIopdymkVeCp3RiisOG1tLbuR8nVYaPkl0eQj8bbzgrKKHtY7Ale5?=
 =?us-ascii?Q?dEY7Na9ibrPRBZC1vM3WSIbBnzZs4CRodP8GLnKdBsncY1PgsOJ0gwP9T3rH?=
 =?us-ascii?Q?fEDEztAl9PCNQ2biyyRGYJdP/GRrXD8PUTm+U+D/MBhLjVZIEQvXqocSdNqm?=
 =?us-ascii?Q?DPyscvJ3OZnmcRQ2gUQLrK2THNYGRx1wRRhHAXn6YTX6bfYfdEQQmQTtpzVw?=
 =?us-ascii?Q?hF8u9Jvhk/L+2H4RiuPN6aFscY4gTI5WfM6ERT0OCJzg+7HcQD70MAn3gssR?=
 =?us-ascii?Q?u0uYJGZ56kxtGcv0jwHo1qsc5LlSOQaAGwkH5zNSbsOc4UnGEx1sMzmVGNet?=
 =?us-ascii?Q?0b2v+PI8ToC846Fdcj54id1syMmGRPxf5APiqvhOsHFgSjhEPe+ImeVQ7hHj?=
 =?us-ascii?Q?yviJVzoSkE33VjXQHvd0GkdfS4m9LspTSFD3gx0p2n2ZRC3tRoVRJY3AtQTo?=
 =?us-ascii?Q?LBeQkLluKCr6i04AKo4tPQs1gWITzSbzIQLEtwCc?=
X-OriginatorOrg: sraoss.co.jp
X-MS-Exchange-CrossTenant-Network-Message-Id: 80188469-dbbe-4fb8-8f69-08dc901a412e
X-MS-Exchange-CrossTenant-AuthSource: TYWP286MB2633.JPNP286.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 19 Jun 2024 04:42:41.8742
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 75db6c32-352e-4063-ae79-cafb8623f6db
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: GWQ/ZSW/VIuzSZ22TtpSZih0VVqbPTip/jSZNUIeXooTUm2evVAdJgVohi4GPwo9sMZRh5omP/jdljuZnY7kLg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3P286MB2279
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/20240619134240.7fd75ea857aafccaca4d70ea%40sraoss.co.jp>
Precedence: bulk

Hi,

The default value of "if_up_cmd" is:

  /usr/bin/sudo /sbin/ip addr add $_IP_$/24 dev eth0 label eth0:0

If the network interface "eth0" exists on Pgpool-II servers,
the command may run successfully.

I think the default value of "if_up_cmd" was executed to bring up the VIP.

> Hello everyone.
> 
> We have a pgpool & postgres setup made as per the given example
> <https://www.pgpool.net/docs/latest/en/html/example-cluster.html>
> 
> We haven't configured the *if_up_cmd, if_down_cmd & **arping_cmd* in
> pgpool.conf
> (we commented it out on purpose). We enabled the *delegate_ip* and assigned
> a unused IP.
> 
> While we bringing up the pgpool the log shows VIP is successfully UP via
> if_up_cmd, how is this happening? any default way is considering the
> if_up_cmd to bring the VIP?
> 
> 
> 
> *2024-06-18 08:27:02.735: watchdog_utility pid 102493: LOG:  successfully
> acquired the delegate IP:"10.127.1.20"2024-06-18 08:27:02.735:
> watchdog_utility pid 102493: DETAIL:  'if_up_cmd' returned with
> success2024-06-18 08:27:02.735: watchdog pid 102378: LOG:  watchdog
> escalation process with pid: 102493 exit with SUCCESS.*
> 
> NOTE: We run into some situation so that we disabled the if_* commands in
> the configuration and started pgpool, but VIP is getting acquired by the
> leader pgpool node even the if_* commands are not used in pgpool.conf file.
> 
> Can anyone explain how the VIP works in pgpool watchdog
> 
> Thank you
> Regards
> Mukesh Tanuku


-- 
Bo Peng <pengbo@sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/