Request a Demo
Home   >   mailing lists

Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate - Mailing list pgsql-bugs

From Anthonin Bonnefoy
Subject Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate
Date
Msg-id CAO6_Xqq3Unkz_J0qRNOZ15tCNnhhpsiceUj0ozTpHqpayicAOg@mail.gmail.com
Whole thread
In response to Re: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate  (Erik Dobák <erik.dobak@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Vladimir Valikaev
Date:
Subject: BugReport: PostgreSQL 17.8. Processing UTF8 encoded strings
Next
From: Robert Haas
Date:
Subject: Re: Major Version Upgrade failure due to orphan roles entries in catalog