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.94.2) (envelope-from ) id 1ubf5X-003fVN-RF for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 12:48:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ubf5V-001rBE-Ny for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 12:48:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubcpU-00127w-4B for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 10:24:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ubcpR-007rHh-2T for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 10:24:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=aSLchiroV+6Ykp39DhD/6Sq9FvkG0W4S5IXWIqIsCSA=; b=YsBWz5fcpzg3zbQor1zktmewSF hwSn+jQK6gc0b6Bd2qS2RvA3VN0irJp8k7iw51V1TsuHNajDK+KrYm9axyuvhwM44DeIpZSssz5XN H4UfqLirU2BByONShEc3h7ygQXuTY80UqP0AbIKXiWgrGY2v/qO0gi1l+gUCVaiN0X138aHJRafsB 7UJPnaD/MmWYR08qFDBUBnsArYBy12PmAd5DckyxrJkjtZOXqsH8xajk5avBnBBSHuk94Be0NzMrs RNAmX/LNggktqdeP/DHJzGF8TAK4rAjPRQX/EJzu6pRJDsbl5fM8B7E5xvhV9948FWQZIHGKPvVjC PkDNO/ag==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ubcpQ-0034W7-2Q for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 10:24:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ubcpO-0073DR-1H for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 10:24:02 +0000 Content-Type: multipart/mixed; boundary="===============3705966965792867564==" MIME-Version: 1.0 Subject: BUG #18985: fast shutdown does not close connections from qlik data gateway data movement aka. replicate To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: erik.dobak@gmail.com Reply-To: erik.dobak@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 15 Jul 2025 10:23:51 +0000 Message-ID: <18985-64431d78bcabae95@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3705966965792867564== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk4NQpMb2dnZWQgYnk6ICAgICAgICAgIEVyaWsgRG9iYWsKRW1haWwg YWRkcmVzczogICAgICBlcmlrLmRvYmFrQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE0 LjgKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIHNlcnZlciAyMDIyCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpXZSB1c2UgcG9zdGdyZXNxbCAxNC4xOCBhdCBhIHdpbmRvd3Mgc2VydmVyIDIwMjIg YXMgYSByZXBvc2l0b3J5IGRiIGZvciB0aGUKUWxpayBTZW5zZSBwcm9kdWN0LiBBZGRpdGlvbmFs bHkgd2UgY29ubmVjdCB0byB0aGUgcG9zdGdyZXNxbCBkYiBmcm9tIGEKcmVtb3RlIHNlcnZlciBy dW5uaW5nIFFsaWsgRGF0YSBHYXRld2F5IERhdGEgTW92ZW1lbnQgc2VydmVyIHdoaWNoCnJlcGxp Y2F0ZXMgZGF0YSBhbmQgY2hhbmdlcyB0byB2YXJpb3VzIGNsb3VkIERCcyBieSB1c2luZyByZXBs aWNhdGlvbiBzbG90cy4KCldoZW4gd2UgdHJ5IHRvIHNodXRkb3duIHRoZSBwb3N0Z3Jlc3FsIGRi IHNlcnZpY2UgKHBlciB3aW5kb3dzIHNlcnZpY2VzIG9yCnBnX2N0bCAtbSBmYXN0KSBhbG1vc3Qg YWxsIGNvbm5lY3Rpb25zIHRvIHRoZSBwb3NncmVzcWwgc2VydmVyIGFyZSBjbG9zZWQKYnV0IHRo ZSBRbGlrIERhdGEgR2F0ZXdheSBEYXRhIE1vdmVtZW50IGNvbm5lY3Rpb25zIGNhbiBiZSBzZWVu IGFzCkVTVEFCTElTSEVEIHdoZW4gdXNpbmcgdGhlIG5ldHN0YXQgLWFubyBjb21tYW5kLgoKRnJv bSB0aGUgcG9zZ3Jlc3FsIGxvZ3MgLT4gdGhpcyBoYXBwZW5zIHdoZW4gaSB0cnkgdG8gc2h1dGRv d24gcG9zdGdyZXNxbDoKCjIwMjUtMDctMTUgMDg6MjA6MzYuNjc2IFVUQyBbMTQ3NDBdIExPRzog IGNvdWxkIG5vdCByZWNlaXZlIGRhdGEgZnJvbQpjbGllbnQ6IEFuIGV4aXN0aW5nIGNvbm5lY3Rp b24gd2FzIGZvcmNpYmx5IGNsb3NlZCBieSB0aGUgcmVtb3RlIGhvc3QuCjIwMjUtMDctMTUgMDg6 MjA6NDMuOTgwIFVUQyBbMTQ1MTZdIExPRzogIHJlY2VpdmVkIGZhc3Qgc2h1dGRvd24gcmVxdWVz dAoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4NiBVVEMgWzE0NTE2XSBMT0c6ICBhYm9ydGluZyBhbnkg YWN0aXZlIHRyYW5zYWN0aW9ucwoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4NiBVVEMgWzE0NjA0XSBG QVRBTDogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gZHVlIHRvCmFkbWluaXN0cmF0b3IgY29tbWFu ZAoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4NyBVVEMgWzgwMjBdIEZBVEFMOiAgdGVybWluYXRpbmcg Y29ubmVjdGlvbiBkdWUgdG8KYWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDctMTUgMDg6MjA6 NDMuOTg3IFVUQyBbMTM4MDBdIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8K YWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDctMTUgMDg6MjA6NDMuOTg3IFVUQyBbMTUyMzJd IEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8KYWRtaW5pc3RyYXRvciBjb21t YW5kCjIwMjUtMDctMTUgMDg6MjA6NDMuOTg3IFVUQyBbMTM2MDBdIEZBVEFMOiAgdGVybWluYXRp bmcgY29ubmVjdGlvbiBkdWUgdG8KYWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDctMTUgMDg6 MjA6NDMuOTg3IFVUQyBbMTAxNzZdIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUg dG8KYWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDctMTUgMDg6MjA6NDMuOTg3IFVUQyBbNzY0 OF0gRkFUQUw6ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9uIGR1ZSB0bwphZG1pbmlzdHJhdG9yIGNv bW1hbmQKMjAyNS0wNy0xNSAwODoyMDo0My45ODggVVRDIFsyMjcyXSBGQVRBTDogIHRlcm1pbmF0 aW5nIGNvbm5lY3Rpb24gZHVlIHRvCmFkbWluaXN0cmF0b3IgY29tbWFuZAoyMDI1LTA3LTE1IDA4 OjIwOjQzLjk4OCBVVEMgWzExMDcyXSBGQVRBTDogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gZHVl IHRvCmFkbWluaXN0cmF0b3IgY29tbWFuZAoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4OCBVVEMgWzEz MzA0XSBGQVRBTDogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24gZHVlIHRvCmFkbWluaXN0cmF0b3Ig Y29tbWFuZAoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4NyBVVEMgWzEyNjU2XSBGQVRBTDogIHRlcm1p bmF0aW5nIGNvbm5lY3Rpb24gZHVlIHRvCmFkbWluaXN0cmF0b3IgY29tbWFuZAoyMDI1LTA3LTE1 IDA4OjIwOjQzLjk4OCBVVEMgWzE1NDk2XSBGQVRBTDogIHRlcm1pbmF0aW5nIGNvbm5lY3Rpb24g ZHVlIHRvCmFkbWluaXN0cmF0b3IgY29tbWFuZAoyMDI1LTA3LTE1IDA4OjIwOjQzLjk4OCBVVEMg WzIyNzZdIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8KYWRtaW5pc3RyYXRv ciBjb21tYW5kCjIwMjUtMDctMTUgMDg6MjA6NDMuOTg4IFVUQyBbMTMyNTZdIEZBVEFMOiAgdGVy bWluYXRpbmcgY29ubmVjdGlvbiBkdWUgdG8KYWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDct MTUgMDg6MjA6NDMuOTg4IFVUQyBbMTA4MjhdIEZBVEFMOiAgdGVybWluYXRpbmcgY29ubmVjdGlv biBkdWUgdG8KYWRtaW5pc3RyYXRvciBjb21tYW5kCjIwMjUtMDctMTUgMDg6MjA6NDMuOTg4IFVU QyBbNjAxNl0gRkFUQUw6ICB0ZXJtaW5hdGluZyBjb25uZWN0aW9uIGR1ZSB0bwphZG1pbmlzdHJh dG9yIGNvbW1hbmQKMjAyNS0wNy0xNSAwODoyMDo0My45ODggVVRDIFsxMzIzMl0gRkFUQUw6ICB0 ZXJtaW5hdGluZyBjb25uZWN0aW9uIGR1ZSB0bwphZG1pbmlzdHJhdG9yIGNvbW1hbmQKMjAyNS0w Ny0xNSAwODoyMDo0NC4wNDcgVVRDIFsxNDUxNl0gTE9HOiAgYmFja2dyb3VuZCB3b3JrZXIgImxv Z2ljYWwKcmVwbGljYXRpb24gbGF1bmNoZXIiIChQSUQgNjQwMCkgZXhpdGVkIHdpdGggZXhpdCBj b2RlIDEKMjAyNS0wNy0xNSAwODoyMDo0NC4wNTMgVVRDIFs1NDQ4XSBMT0c6ICBzaHV0dGluZyBk b3duCjIwMjUtMDctMTUgMDg6MjA6NTYuNTEyIFVUQyBbNDM2NF0gTE9HOiAgY29ubmVjdGlvbiBy ZWNlaXZlZDogaG9zdD06OjEKcG9ydD01MjUxNAoyMDI1LTA3LTE1IDA4OjIwOjU2LjUxMiBVVEMg WzQzNjRdIEZBVEFMOiAgdGhlIGRhdGFiYXNlIHN5c3RlbSBpcyBzaHV0dGluZwpkb3duCjIwMjUt MDctMTUgMDg6MjA6NTYuNTQ3IFVUQyBbMTM5NjhdIExPRzogIGNvbm5lY3Rpb24gcmVjZWl2ZWQ6 Cmhvc3Q9MTI3LjAuMC4xIHBvcnQ9NTI1MTUKMjAyNS0wNy0xNSAwODoyMDo1Ni41NDcgVVRDIFsx Mzk2OF0gRkFUQUw6ICB0aGUgZGF0YWJhc2Ugc3lzdGVtIGlzIHNodXR0aW5nCmRvd24KMjAyNS0w Ny0xNSAwODoyMTo1Ni40ODYgVVRDIFsxMDQ1Nl0gTE9HOiAgY29ubmVjdGlvbiByZWNlaXZlZDog aG9zdD06OjEKcG9ydD01MjU0MwoyMDI1LTA3LTE1IDA4OjIxOjU2LjQ4NyBVVEMgWzEwNDU2XSBG QVRBTDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc2h1dHRpbmcKZG93bgoyMDI1LTA3LTE1IDA4 OjIxOjU2LjUyMiBVVEMgWzQ4MTJdIExPRzogIGNvbm5lY3Rpb24gcmVjZWl2ZWQ6IGhvc3Q9MTI3 LjAuMC4xCnBvcnQ9NTI1NDQKMjAyNS0wNy0xNSAwODoyMTo1Ni41MjIgVVRDIFs0ODEyXSBGQVRB TDogIHRoZSBkYXRhYmFzZSBzeXN0ZW0gaXMgc2h1dHRpbmcKZG93bgoyMDI1LTA3LTE1IDA4OjIx OjU2LjU2MSBVVEMgWzE1NDQ0XSBMT0c6ICBjb25uZWN0aW9uIHJlY2VpdmVkOiBob3N0PTo6MQpw b3J0PTUyNTQ1CjIwMjUtMDctMTUgMDg6MjE6NTYuNTYyIFVUQyBbMTU0NDRdIEZBVEFMOiAgdGhl IGRhdGFiYXNlIHN5c3RlbSBpcyBzaHV0dGluZwpkb3duCjIwMjUtMDctMTUgMDg6MjE6NTYuNTk1 IFVUQyBbMTI4NDRdIExPRzogIGNvbm5lY3Rpb24gcmVjZWl2ZWQ6Cmhvc3Q9MTI3LjAuMC4xIHBv cnQ9NTI1NDYKMjAyNS0wNy0xNSAwODoyMTo1Ni41OTUgVVRDIFsxMjg0NF0gRkFUQUw6ICB0aGUg ZGF0YWJhc2Ugc3lzdGVtIGlzIHNodXR0aW5nCmRvd24KMjAyNS0wNy0xNSAwODoyMjo1Ni41MDUg VVRDIFsxNTAwNF0gTE9HOiAgY29ubmVjdGlvbiByZWNlaXZlZDogaG9zdD06OjEKcG9ydD01MjU3 NAouLi4KCgp0aGlzIGRpZCBnbyBvbiBmb3IgMzBtaW51dGVzIG9yIG1vcmUuIHRoZW4gaSBjaGVj a2VkIHdpdGggbmV0c3RhdCAod2UgYXJlCnVzaW5nIHBvcnQgNDQzMiBpbnN0ZWFkIG9mIDU0MzIg Zm9yIHBvc3RncmVzZGIpOgoKUFMgQzpcVXNlcnNccmVkYWN0ZWQ+IG5ldHN0YXQgLWFub3xmaW5k c3RyIDQ0MzIKICBUQ1AgICAgMC4wLjAuMDo0NDMyICAgICAgICAgICAwLjAuMC4wOjAgICAgICAg ICAgICAgIExJU1RFTklORyAgICAgICAxNDUxNgogIFRDUCAgICByZWRhY3RlZF9wb3N0Z3Jlc19p cDo0NDMyICAgICAgICAgcmVhZGFjdGVkX2RnZG1faXA6MzU4MTgKRVNUQUJMSVNIRUQgICAgIDE0 NTE2CiAgVENQICAgIHJlZGFjdGVkX3Bvc3RncmVzX2lwOjQ0MzIgICAgICAgICByZWRhY3RlZF9k Z2RtX2lwOjM1ODg2CkVTVEFCTElTSEVEICAgICAxNDUxNgogIFRDUCAgICBbOjpdOjQ0MzIgICAg ICAgICAgICAgIFs6Ol06MCAgICAgICAgICAgICAgICAgTElTVEVOSU5HICAgICAgIDE0NTE2Cgpo ZXJlIHlvdSBjYW4gc2VlIDIgYWN0aXZlIG5ldHdvcmsgY29ubmVjdGlvbiBldmVuIHRob3VnaCB3 ZSBoYXZlIGluaXRpYXRlZCBhCmZhc3Qgc2h1dGRvd24gMzBtaW5zIG9yIG1vcmUgYmVmb3JlLgoK aSBkZWNpZGVkIHRvIHNodXRkb3duIG91ciBRbGlrIERhdGEgR2F0ZXdheSBEYXRhIE1vdmVtZW50 IHNlcnZpY2Ugb24gdGhlCm90aGVyIHNlcnZlciBhbmQgaW1tZWRpYXRlbHkgdGhlIHBvc3RncmVz REIgZGlkIHN0b3AgY29ycmVjdGx5OgoKLi4uCjIwMjUtMDctMTUgMDg6NTA6NTEuNzk5IFVUQyBb NTQ0OF0gTE9HOiAgY2hlY2twb2ludCBzdGFydGluZzogc2h1dGRvd24KaW1tZWRpYXRlCjIwMjUt MDctMTUgMDg6NTA6NTEuODU5IFVUQyBbNTQ0OF0gTE9HOiAgY2hlY2twb2ludCBjb21wbGV0ZTog d3JvdGUgOQpidWZmZXJzICgwLjElKTsgMCBXQUwgZmlsZShzKSBhZGRlZCwgMCByZW1vdmVkLCAw IHJlY3ljbGVkOyB3cml0ZT0wLjAwNCBzLApzeW5jPTAuMDE5IHMsIHRvdGFsPTAuMDY3IHM7IHN5 bmMgZmlsZXM9NywgbG9uZ2VzdD0wLjAwNCBzLCBhdmVyYWdlPTAuMDAzIHM7CmRpc3RhbmNlPTM4 IGtCLCBlc3RpbWF0ZT0yMjUwNSBrQgoyMDI1LTA3LTE1IDA4OjUwOjUxLjkxMCBVVEMgWzE0NTE2 XSBMT0c6ICBkYXRhYmFzZSBzeXN0ZW0gaXMgc2h1dCBkb3duLgoKLS0tLS0tLQoKQWNjb3JkaW5n IHRvIGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTQvYXBwLXBnLWN0bC5odG1sIDoK Li4uCuKAnEZhc3TigJ0gbW9kZSAodGhlIGRlZmF1bHQpIGRvZXMgbm90IHdhaXQgZm9yIGNsaWVu dHMgdG8gZGlzY29ubmVjdCBhbmQgd2lsbAp0ZXJtaW5hdGUgYW4gb25saW5lIGJhY2t1cCBpbiBw cm9ncmVzcy4gQWxsIGFjdGl2ZSB0cmFuc2FjdGlvbnMgYXJlIHJvbGxlZApiYWNrIGFuZCBjbGll bnRzIGFyZSBmb3JjaWJseSBkaXNjb25uZWN0ZWQsIHRoZW4gdGhlIHNlcnZlciBpcyBzaHV0IGRv d24uCi4uLgoKSW4gb3VyIGNhc2UgdGhlcmUgYXJlIGF0IGxlYXN0IDIgY2xpZW50IGNvbm5lY3Rp b24gbm90IGZvcmNpYmx5IGRpc2Nvbm5lY3RlZAphbmQgdGhpcyBpcyB3aHkgaSBvcGVuIHRoaXMg YnVnLgoK --===============3705966965792867564==--