Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w8HuV-000NxR-1F for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2026 13:16:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w8HuT-005xjJ-0S for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2026 13:16:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w8HuS-005xj9-2k for pgsql-hackers@lists.postgresql.org; Thu, 02 Apr 2026 13:16:33 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w8HuR-00000000BdF-2BUl for pgsql-hackers@lists.postgresql.org; Thu, 02 Apr 2026 13:16:32 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-7d751ef36ccso526892a34.0 for ; Thu, 02 Apr 2026 06:16:31 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775135791; cv=none; d=google.com; s=arc-20240605; b=DDCWMGBgcLc3IBZFdJ0pKmtOVmqgEwoFIdy8hxRxGEXsvj+es8ufBod0L2MI401FYe JDTP6Z1zgUeVY+Zr9aM624SUCny+426TjVBUjignMMjS3daXUg8RCMrP38tfAK1bqKhq QkS1R4uKm6vkz0ujht46rDN116uCT49MB2b8AH4vYoKBibFTtqxjninlhq9Zs2RhlxJp iOo173tUvJSql32ZEA8udTrr2ZBBEYeumrn/phP2i8WVKk6YbyTLq31bPHCxjALhhg+7 KUW0pmX7yBTDyWZBOiUbnYB+9SbZ95RZZ5lth+0kwx/yZF9H2Pag9+4URvsxblphzL93 XPEA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=dXWBnjsIvlt0jl0MFoqddTIpgJ+2SvXRcgQPOxtsOUg=; fh=VFAq/99o8VPj8eWT4RBLGiF9GDWaEKb3cQk5HFLhLJQ=; b=VUWkVaw5nS9rndfn3cbBNkx4zzO+rtDiBPtaFX/htQ4fzKxBRBTs+iRFrJD7uHYzUV OPUhC5HB7tLUvKkSci6fHzvzpbWteIALNciHA5PyJw78jipPlAKz64rwpuexB3xOnjGm kaB6h2Vwofmr4iP8CRzNFy20hApkV6SelAC8gLD12bTjOtPnO3iAAyyEUD+vlPf/EpJ4 9VDz9xLyInBKQ3gdKeUSZA+IL3id776DisUmtT27dgWEuHdXOLQKEo8ItR4Bf0d9M+Xq kS8pCRzh8L9ZJtm9gRvhhVRwRaVYhDi8dDijihMCRu5aY7eKLgPEy6d6xvCOTOs1GAmw GUuQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775135791; x=1775740591; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=dXWBnjsIvlt0jl0MFoqddTIpgJ+2SvXRcgQPOxtsOUg=; b=SpJY3UX3wDfDS8RMtcxxmVjgcdhl3OcfjPebv1dV610z2cVcFTNmCH3Ys80THEWfQc jSAdWSeSYf9+IItOZbi12C3Bt0JRxXNIjXIqHLnLIGJS5h6fUao5ztKUEk+T9OYPytd7 inQewloRuaagMcRX9disbt5c2KTQU4MrWeCpr5drVZBzsxCKprcgbtTL+Bt+dDXkEI+f 405dtfcvsLk7Xgx8eSWH+H8Lh3kFYBVhuavQQoIGPjHVNh4M3w9Jv68XLRC8Abqc/u3h F7CYYPB+7FfA19EWQv7ulqmtv27TURX/6U0TBEbZHx48JfQnh2uBZGBe5c/GbR/qOZtJ 8NXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775135791; x=1775740591; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=dXWBnjsIvlt0jl0MFoqddTIpgJ+2SvXRcgQPOxtsOUg=; b=kAASW3XBOW+jQ7yPx2FJ8j13Unhv2mmkcTF+1H4PRGPkifqsx9OnO9SXcCPXgnJZFN IqZNNVAq3no2WJXMGCGyD1YPaRBhKx9Wcb4Kly4tDgoy4NiGrVjlJ7L2qbURTHCVBBVf tr5yqrCVCwkGDrG6G9iyJ0SYiGlmxOcDxos/w8c3dER/UHkzoc1bWxpszpv2KiGcEoJP E1ztaoLMGckAq4fBDPYIHDmv/dCOaGKT26y4ningNd/biUVsXCJWJtaT6gi3pLqk4EtA I2MJo3/NSxuFxS1chJf905RDKBa2i60x8KgW190CjgeNyKqF/j+YzeM6UKgO5P0jYBPG 8fMw== X-Forwarded-Encrypted: i=1; AJvYcCWqLBy6ReE4aoDPJpWShbsFudOLV+FrGdCsh+uu1f2oGgouEo9UthivIyxBx51zBE5aGCA8hwCITpf16dmg@lists.postgresql.org X-Gm-Message-State: AOJu0Yx8nmfyqj/n8EL1l53Ckc9qsoHiDn/POVj6nlolF8kHgS6yKOZj nG7dzeD9T2+uyWFcz97gLsHggFtuNt+YseyGcf5lIgirvItfl6XhEa08l7lXIMhTsCbDwZPtzT3 JHCwAin5dw+eL0w5Nq+xcbNgEk8ah3mM= X-Gm-Gg: ATEYQzzmqwyPLxq1oHfuTlILGvdI9PWQaPEQMJNdF5J78459XpYWl9smlx9zal86QMo XdOu/dvfGrGUkvBdm40Uam72L38qjDkrr/hkQV0hzkTv2YzuvvPG1QQj0bk5+dGrewiuop7OD5b G9vDjho5CxnfcD6RBhTf2TZ4Spb0dMNGxH7w598SVhfcuK9PlLiILWb1RCfn2XcPe2fI1zw6sZP PqCgImVdNTTgwUhjKUoP+bbkrP32S8dIMr0pqfvmn8Yg5lnUK593njQMicwMI564L2yuMDtQS5m oiFP8LA15YNsmBq4HGO38UXyIW//hSYVfkD9L8I+NJez37jh7E/Q X-Received: by 2002:a05:6820:828:b0:67b:bd89:90fa with SMTP id 006d021491bc7-67fabcd4c39mr3701472eaf.45.1775135790722; Thu, 02 Apr 2026 06:16:30 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Thu, 2 Apr 2026 22:16:16 +0900 X-Gm-Features: AQROBzBDn7bdyqzCtWOUxem-3UjaCKTW2xF-pJI6xVMqHezUIKpS5mluWBmMM6M Message-ID: Subject: Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion? To: Amit Kapila Cc: Nisha Moond , "Zhijie Hou (Fujitsu)" , shveta malik , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Apr 2, 2026 at 3:34=E2=80=AFPM Amit Kapila wrote: > It is because we added retry slot-sync logic for API in master in > commit 0d2d4a0ec3eca64e7f5ce7f7630b56a561b2663c. So, there is no > chance of API waiting except for the race condition being discussed > here. Thanks for the info! > > but it seems we need to backpatch it first before backpatching this pat= ch. > > Thought? > > > > I feel the use of API before this version was mainly for test-cases as > it was not production ready. So, it is less helpful to backpatch > 1362bc33e02, if we want, we can backpatch only the worker part of the > fix. OTOH, as the issue is not frequent and we have some workaround > (at least for more common platforms) as well, we can consider not > backpatching it. I see your point. OTOH, on second thought, if backpatching commit 1362bc33e= 02 along with this patch to v17 and v18 *is harmless*, I'd prefer to do so. Ke= eping the slotsync shutdown code more consistent across versions would make futur= e backpatching easier, and selectively backpatching only parts of the shutdow= n logic would be more complicated and error-prone. Thought? Regards, --=20 Fujii Masao