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 1vvYj8-007pQS-12 for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 10:36:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvYj6-00Bm27-2x for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 10:36:12 +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 1vvYj6-00Bm1w-1p for pgsql-hackers@lists.postgresql.org; Thu, 26 Feb 2026 10:36:12 +0000 Received: from mail-yw1-x1134.google.com ([2607:f8b0:4864:20::1134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvYj3-00000001HMK-0pR7 for pgsql-hackers@postgresql.org; Thu, 26 Feb 2026 10:36:11 +0000 Received: by mail-yw1-x1134.google.com with SMTP id 00721157ae682-79801df3e21so6172267b3.2 for ; Thu, 26 Feb 2026 02:36:10 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772102169; cv=none; d=google.com; s=arc-20240605; b=LE/EPvROMRNeLNO9KvdZj51nKiko0dlYplaIkJTd+/jgM+oV3YCndUoUp5g0toswqE s5kDjrIrsGLiCRB8S5qMLTXktj8VU236rViGXRQKBZ9RzB+0UJTL0+vcMEkuVb8bWkdg 3f114PVvruiTZvMGMT5O//rRQVUeMVY7/m5HY7sMlR1pvbVIa1qKj7ZWUAqoJJeEp4wV maEczQHeS2bScR/olKN14UUnfl0isBptWpTL13JHfT2F+xc9QxYuAanqqMCHmxW0KZQV e86s1CmY1IDCnS4qqJLN3N5KE/NbnmjgiE5RxRmVheA6hNW7bC8cYrQzwdepMC8G2SBL bENA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=aqkdDkUsGaKEu8/bBBijTRN/PyFQt+OcfhtbLZ1YVJM=; fh=waPnKahtqrjL6e5lDHONXgAYWW+1/EnTYqDmUsP0vmM=; b=L5qvz/8/otLkl/rss4C42nwJgbDxv/b+Pnyg/gmD7XYzOaFbPD9XHC9cdxUyhoOGMN MhWadf8Ci55hj7BZQKpRBteNrV6ixm5iI6LcCurXYpGsfW+gDOj/nljHy26VtkVfYD2M 3IfpMagOZi2sIsYPAio/YW+Kla/HIsEJKeJRfn3TJ4jj8nEst9rkBSRWfLd90YJSsI0n e78hSC7SPzXRK3b9Cc1PPA84W3Ppflbl2TWVK9BTNPRDt2gW+TMPcJXBe0TCzLEtMMTQ LAd5J2ObttxgHGVssc5TuDcv1Cl4VpqJ+l3LiJL4Ma3oh4VY7y1tUtWZxndFcIizo2iO sTvA==; darn=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=1772102169; x=1772706969; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=aqkdDkUsGaKEu8/bBBijTRN/PyFQt+OcfhtbLZ1YVJM=; b=K/Mtgmz9k6/g9TD0dtLYYkDtOmhX/C62vyFBvAbF5r1cDnEaT6PMiDQYPsO3zBPb8p zSkWuJmSe3i0Xl2Kboic+2NuhaqzV7MlucEcKQjv1yEppD12FcIFTOcR/yNWtICoE9aq HUGCPQA4cCyokdN4Cc+f0ITXR7aMVkbz/kXes= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772102169; x=1772706969; h=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=aqkdDkUsGaKEu8/bBBijTRN/PyFQt+OcfhtbLZ1YVJM=; b=vKnaa/jpEPWc9S5trEU9xIZnvVuEjIVrDHxabwSSjvKZJcHRnkiJNyCRR+6k74iTv9 e5O4zodE5t2cRhxVnePbBZM7iBDROi1IS+6a7CMZ1n6nPHVrzVK5v5uryiBTdcNDFjaj dIiyFw5iSEdzvlIBDAq7SIZVxS5ArWPZiwyFVZrXQ2GgkyvcloXV7AflJ7zD9Z8VpEox NUytsAJbFJMCQ0y/qfUhLrEk3EgZAmwQPhm6i7srZet4GJzfCkhiIC682gozbdL2c/CG bKkKjOLk4S/V7kCwRv65z5VKtD9tVKhBjUKzZk/hOtPy4csbUsflU91tjxrmhBVqdawo Kmqw== X-Gm-Message-State: AOJu0YyGMigmwf9lu/Ibd8W0MEggloH3ejmxZjxRj5g+AfF4S6xeMHD1 s97OfN2Yb+TQ0SVTRROSOrVaBrozJcNzUYGFSQLCwtQerNjZkiczQYWp2LhN/rqIUJznWQMV1mL taB+a7eyadhYHCTVHq+e1CEZ4i1t0/YeNVQkoZE38F+bBU2q3lRJ393f02A== X-Gm-Gg: ATEYQzzrmhkacoS7h/NmBjyWSntoF4zf5ARLZ9WzW/kQ3CnRsh7J4TzWFpTY1xBPJV9 bswaWlyKf+NB1s86ff+KuAIZDu9ENuGOrt1HnP+K1wjZA43NjvlHt7u5rwedVWZ8dKnEu5ktnj/ QYRYxA8BB7ITDkpQs619wUxyDNqRmSEg9lqjrAP0ZWcQWeDG44y4qsgPLjwELH+2LyOPlFJ3HQR ZGTmgITbRrL/e/FeaDFd8Ci1N9Clebo4HEOk7Z3NU9KVD4t/IkLBz6LCoQWLfjewRJvu2H5FVcS A5Tdog== X-Received: by 2002:a05:690c:a91:b0:797:ef49:a4a0 with SMTP id 00721157ae682-7986fe34c03mr33998577b3.46.1772102168739; Thu, 26 Feb 2026 02:36:08 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Anthonin Bonnefoy Date: Thu, 26 Feb 2026 11:35:57 +0100 X-Gm-Features: AaiRm53EsXJxMontaYT4-0RIVNfZ7F4Ivy8SbO1_aiNJ7OOcHh2kkaAt5hKeOew Message-ID: Subject: Re: Shutdown indefinitely stuck due to unflushed FPI_FOR_HINT record To: PostgreSQL Hackers Content-Type: multipart/mixed; boundary="00000000000046fbdc064bb7b037" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000046fbdc064bb7b037 Content-Type: text/plain; charset="UTF-8" And here's a script reproducing the issue. It creates the clusters, sets up the logical replication and runs the necessary query to leave FPI_FOR_HINT as the last written record. If successful, the script should have pg_stop stuck with 'waiting for server to shut down.......', with the walsender stuck at 100% CPU. --00000000000046fbdc064bb7b037 Content-Type: text/x-sh; charset="US-ASCII"; name="reproduce_stuck_shutdown.sh" Content-Disposition: attachment; filename="reproduce_stuck_shutdown.sh" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mm3biorq0 IyEvYmluL2Jhc2gKc2V0IC1ldQoKZXhwb3J0IFBHREFUQUJBU0U9cG9zdGdyZXMKCiMgU2V0dXAg cHJpbWFyeQppbml0ZGIgLWsgLUQgcHJpbWFyeQplY2hvICJwb3J0ID0gNTQzMgp3YWxfbGV2ZWwg PSBsb2dpY2FsCiMgSnVzdCBtYWtlIGl0IGVhc2llciB0byBnZGIgaW50byB0aGUgd2Fsc2VuZGVy IHdpdGhvdXQgZ2V0dGluZyBpdCBraWxsZWQKd2FsX3JlY2VpdmVyX3N0YXR1c19pbnRlcnZhbCA9 IDAKd2FsX3NlbmRlcl90aW1lb3V0ID0gMCIgPiBwcmltYXJ5L3Bvc3RncmVzcWwuY29uZgoKIyBT dGFydCBpdApwZ19jdGwgLUQgcHJpbWFyeSAtbCBwcmltYXJ5LmxvZyAtVSBwb3N0Z3JlcyBzdGFy dAoKIyBTZXR1cCByZXBsaWNhCmluaXRkYiAtayAtRCByZXBsaWNhCmVjaG8gInBvcnQgPSA1NDMz CndhbF9yZWNlaXZlcl90aW1lb3V0ID0gMCIgPiByZXBsaWNhL3Bvc3RncmVzcWwuY29uZgoKIyBT dGFydCBpdApwZ19jdGwgLUQgcmVwbGljYSAtbCByZXBsaWNhLmxvZyAtVSBwb3N0Z3JlcyBzdGFy dAoKIyBDcmVhdGUgZW1wdHkgcGdiZW5jaCB0YWJsZXMKcGdiZW5jaCAtaSAtSWR0cApwZ2JlbmNo IC1pIC1JZHRwIC1wIDU0MzMKCiMgU3RhcnQgbG9naWNhbCByZXBsaWNhdGlvbgpwc3FsIC1jICdD UkVBVEUgUFVCTElDQVRJT04gcGdiZW5jaF9hY2NvdW50c19yZXBsaWNhdGlvbiBmb3IgdGFibGUg cGdiZW5jaF9hY2NvdW50czsnCnBzcWwgLXAgNTQzMyAtYyAiQ1JFQVRFIFNVQlNDUklQVElPTiBt eV9zdWJzY3JpcHRpb24gQ09OTkVDVElPTiAnaG9zdD0xMjcuMC4wLjEgcG9ydD01NDMyJyBQVUJM SUNBVElPTiBwZ2JlbmNoX2FjY291bnRzX3JlcGxpY2F0aW9uOyIKCiMgRmlsbCB0aGUgZmlyc3Qg aGVhcCBwYWdlCnBzcWwgLWMgIklOU0VSVCBJTlRPIHBnYmVuY2hfYWNjb3VudHMgU0VMRUNUICos ICosICosICcnIEZST00gZ2VuZXJhdGVfc2VyaWVzKDAsIDYyKTsiCgojIFNldCBwYWdlIGZ1bGwg aGludCBiaXQKcHNxbCAtYyAiQkVHSU47IFVQREFURSBwZ2JlbmNoX2FjY291bnRzIFNFVCBiaWQ9 NCB3aGVyZSBhaWQ9MTsgUk9MTEJBQ0s7IgoKIyBGb3JjZSBuZXh0IGNoYW5nZSB0byBiZSBhIEZQ SQpwc3FsIC1jICJDSEVDS1BPSU5UOyIKCiMgVHJpZ2dlciB0aGUgRlBJX0ZPUl9ISU5UIGFzIHRo ZSBsYXN0IHdyaXR0ZW4gcmVjb3JkIGluIHRoZSBXQUwKcHNxbCAtYyAiQkVHSU47IFNFTEVDVCBj dGlkLCAqIEZST00gcGdiZW5jaF9hY2NvdW50cyBXSEVSRSBhaWQ9MjsgUk9MTEJBQ0s7IgoKIyBT dG9wIHRoZSBwcmltYXJ5LCBpdCBzaG91bGQgYmUgYmxvY2tlZCB3aXRoIHRoZSB3YWxzZW5kZXIg c3R1Y2sgYXQgMTAwJSBDUFUKcGdfY3RsIHN0b3AgLUQgcHJpbWFyeQo= --00000000000046fbdc064bb7b037--