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 1vvAsx-0073OM-2m for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Feb 2026 09:08:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvAsw-005FJ5-2W for pgsql-bugs@arkaria.postgresql.org; Wed, 25 Feb 2026 09:08:46 +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 1vvAsw-005FIx-1Z for pgsql-bugs@lists.postgresql.org; Wed, 25 Feb 2026 09:08:46 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvAst-000000015v5-0mkA for pgsql-bugs@lists.postgresql.org; Wed, 25 Feb 2026 09:08:45 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-7984d31b895so28120407b3.1 for ; Wed, 25 Feb 2026 01:08:44 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772010523; cv=none; d=google.com; s=arc-20240605; b=SOtcrzddHQ6oUkCl+QPQb3L/AuB01Rq4mDX3PakZu72jM/UPNty6PJoTCFg+MwYL8i PeW/agY+hgqF+U0XPZFh8mMDmcsXnUxFslWTdf4DZ2Jt6RPBXKytpdAOt90wxdZ18gPV WAuzUtXlWREn70hsHOk9hXL3RajY1prFoAhp4kTZMwNAclpBJYnea/o9RN8TA/cCqoN9 jYXHp6H46ofXvJeXRhpqZjCcON0DcPLCHyQ645cOsmYTupmmXy11fmDCdtuM4PMNQFeH MF9TlG5n+iP+bHwvFqWOfKp/UMnaMH7XpUgV75iHuL2bUA0GotE57B2/TrxVBUL7rUDI clyw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=4fBZl5lV1tP4tnKUTDp8RhOGS5eD3gDIEBXmWIsW+uc=; fh=OXx+OcfTtweX7FNPbzI1bfDx1y6O/Hmk0T+W57k7Fd4=; b=DAlrcYefrpFBQjOnR7QIJrRE3lb1O2Qa0XUkcYhIoHF61sV5PhVhn5/csK7UBDDpks 5pgbEuzOUmsfZAUmLsvEtNU70i/7Sm24BAbmAFtc4hVpap0kKeTR2QkMZqBNyzEA4d4D QBMn80TF1wRP2aygyZH30uYfFr79CvBIrZ5G+rWBcF49dY22Ba15FWW7GAMbhsxY+eqR SJTWF8NmgcD6NeKqKC/uNSc8iPUEQ+CBixSw7vWpaMxoyUHPKq4JpjXJ9xjYdTQ4F8Zq LdRZ/6X0v56NWHZsl0dVE9yhrwom2IST0FibZXTb1JonLYvc6CbTwKFFeYNFbssXq3NJ AqJw==; 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=datadoghq.com; s=google; t=1772010523; x=1772615323; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4fBZl5lV1tP4tnKUTDp8RhOGS5eD3gDIEBXmWIsW+uc=; b=NhQVTIX74UhInrL+MZ9D1cZma56wOd3mhH2q6nc00+wlDlZgYGCm1aTS6RiQ71zsR/ DpRm1MgWcTiPuuSCe6kGRha+E0JK4ai7okl5L2HrDKLhGPbYAgVSKIdgHCQsPOP2GOh9 m5iT+F6dA132xCYilRSIn1GQKjirWcvTnEvYo= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772010523; x=1772615323; h=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=4fBZl5lV1tP4tnKUTDp8RhOGS5eD3gDIEBXmWIsW+uc=; b=drOlmyRxf0y5tKktNFeRhhA8rcbLPNYmpSpIXKNFjzQ0mVjxQBhau28+ENYdeT9An9 frhARnmXAhOPTvpLDTMOvFj4Sw8e3RZvCvec/EveA8DnKEcHV5arJlrjhCkrEdRjNtIS lNP53zBc0iWVnJUdbx16d5rAQCudZd/NaoLozHrI4ZMK5XSLsmxvv18eIRgHALodj6xk 2TlTri51F6CyAwF0mDEOR+0cUkaJq7OE6Wt8XbSOSaklxqw1Z4F14AtAe+XRAlkLFi/c FOzQxJSZ3k+k/moS+PWpvrpS770ZUcaQzJoi9m6JSrtGN4ly8y6U7OfpnOEmTdWE/moM pV4A== X-Forwarded-Encrypted: i=1; AJvYcCXOdh57hRHGaNZvR063zhoilOuALcSbOyvLqh47ea1r7VeYF85+VvRcMoP0snpwb7u0eQKPuL9gsGaJ@lists.postgresql.org X-Gm-Message-State: AOJu0YwFbdbQxt0gLTHCe3xEkLxWQ+W9RXOI8yOf7kEDjOiaW4UxtMLH 25lKaKKFfrSYYMXgJ0tb4sWrcC7K0iW0iklRiHtomRZCaJu4sv0tpOFQhNA5i56v3HFKW2VmJD3 WA/2jOO77eXYA/tdhf0iH8bRWrBeovVE3jwaXrU/8Uw== X-Gm-Gg: ATEYQzxBITXOWmrkD+AMEt/01oUlEMWyfJLQDzwrWG8q1+LpLUp5DnNktZlseYXk2yu JImXQeF1TjQifzBQNGqmZi/bf46G3qylRaSCkIWBbyWcm1kE5NDLHw7rH62sj5XSvBe9HhaRcMq adWHF0L/103tESUvphq2p0SPOHKQpM3YgXnZnHPZOfpUNNM1rtirxv0Eq60aX2h4VtQk/nZBJ0e R/2YD/9VYIss5C7wB40NY00KjMl/5ifdmGB8kez46O6Zifp6il1D5kFEddTnmgbH5jrygSvNdJB 6VdsyA== X-Received: by 2002:a05:690c:a:b0:797:ce9d:5c8b with SMTP id 00721157ae682-798681c6045mr16801097b3.31.1772010523158; Wed, 25 Feb 2026 01:08:43 -0800 (PST) MIME-Version: 1.0 References: <18985-64431d78bcabae95@postgresql.org> <923969.1752595701@sss.pgh.pa.us> <938838.1752604022@sss.pgh.pa.us> In-Reply-To: From: Anthonin Bonnefoy Date: Wed, 25 Feb 2026 10:08:32 +0100 X-Gm-Features: AaiRm53cJ9TzfZbDdsezbrWu8T1hKR9Egw9xz2m9GClUV8bHWmgZRV-8MpRTwp4 Message-ID: Subject: Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate To: =?UTF-8?Q?Erik_Dob=C3=A1k?= Cc: Tom Lane , "David G. Johnston" , pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, This is likely related to the issue I've reported[1]: A logical walsender may be stuck at 100% CPU during shutdown, trying to read an incomplete FPI_FOR_HINT record and blocking the shutdown sequence. By stopping the logical replication's target, the impacted walsender exited, unblocking the shutdown. There are similar reports of failover being stuck on projects like patroni[2]. I've provided a way to reproduce the issue in the linked thread, along with a tentative patch. Regards, Anthonin Bonnefoy [1]: https://www.postgresql.org/message-id/flat/CAO6_Xqo3co3BuUVEVzkaBVw9LidBgeeQ_2hfxeLMQcXwovB3GQ%40mail.gmail.com [2]: https://github.com/patroni/patroni/issues/3522