| From: | Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)datadoghq(dot)com> |
|---|---|
| To: | Erik Dobák <erik(dot)dobak(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate |
| Date: | 2026-02-25 09:08:32 |
| Message-ID: | CAO6_Xqq3Unkz_J0qRNOZ15tCNnhhpsiceUj0ozTpHqpayicAOg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2026-02-25 13:59:04 | Re: Major Version Upgrade failure due to orphan roles entries in catalog |
| Previous Message | Vladimir Valikaev | 2026-02-25 06:50:44 | BugReport: PostgreSQL 17.8. Processing UTF8 encoded strings |