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 1uhkrj-003fma-Vv for pgsql-committers@arkaria.postgresql.org; Fri, 01 Aug 2025 08:11:48 +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 1uhkrj-006Rka-03 for pgsql-committers@arkaria.postgresql.org; Fri, 01 Aug 2025 08:11:47 +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.94.2) (envelope-from ) id 1uhkri-006RkS-OS for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:46 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uhkrf-0009gG-1R for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=6ozuUPCGQ44hgXiu6yfEwY0CRtKfegJxnoHWMIdsrTo=; b=QDFmEEtYMtAxUSiFWBFubIC8Ij Q9VXwejB8LKEksxnuhadqpApsicesMPtEHQwmmmqmFQ4wpdQ7jlPMOf+sHFECM19lFCnMpdfZN6Y7 zy7s/WOQOkJ5xDNNjPmmKsuPWQXN3k0TIZT6henOm+gyvzKGj2If+kJh6BiIZzKbNSq0ov2O4wybP gKVQ9BKjGGjJckK5d4gfFw2ACZKicqgVeRvi8MQ9dTNA697BuXFhJ4xJK4QK2f5QvqeEo3TGB9zh5 z7//yEqkB9JYRez+tIIa1+5PLwZVa1pUWw5tzIaknYrGvgoZYoXKRv9+U/c09xoj0viKV58AUrUi3 rZ76ZiNg==; Received: from gemulon.postgresql.org ([72.32.157.198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uhkrf-000PI6-B2 for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uhkre-000A49-2F for pgsql-committers@lists.postgresql.org; Fri, 01 Aug 2025 08:11:43 +0000 Content-Type: multipart/mixed; boundary="===============7959812436635655097==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 01 Aug 2025 08:11:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7959812436635655097== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGEgZGVhZGxvY2sgZHVyaW5nIEFMVEVSIFNVQlNDUklQVElPTiAuLi4gRFJPUCBQVUJMSUNB VElPTi4KCkEgZGVhZGxvY2sgY2FuIG9jY3VyIHdoZW4gdGhlIERETCBjb21tYW5kIGFuZCB0aGUg YXBwbHkgd29ya2VyIGFjcXVpcmUKY2F0YWxvZyBsb2NrcyBpbiBkaWZmZXJlbnQgb3JkZXJzIHdo aWxlIGRyb3BwaW5nIHJlcGxpY2F0aW9uIG9yaWdpbnMuCgpUaGUgaXNzdWUgaXMgcmFyZSBpbiBQ RzE2IGFuZCBoaWdoZXIgYnJhbmNoZXMgYmVjYXVzZSwgaW4gbW9zdCBjYXNlcywgdGhlCnRhYmxl c3luYyB3b3JrZXIgcGVyZm9ybXMgdGhlIG9yaWdpbiBkcm9wIGluIHRob3NlIGJyYW5jaGVzLCBh bmQgaXRzCmxvY2tpbmcgc2VxdWVuY2UgZG9lcyBub3QgY29uZmxpY3Qgd2l0aCBEREwgb3BlcmF0 aW9ucy4KClRoaXMgcGF0Y2ggZW5zdXJlcyBjb25zaXN0ZW50IGxvY2sgYWNxdWlzaXRpb24gdG8g cHJldmVudCBzdWNoIGRlYWRsb2Nrcy4KCkFzIHBlciBidWlsZGZhcm0uCgpSZXBvcnRlZC1ieTog QWxleGFuZGVyIExha2hpbiA8ZXhjbHVzaW9uQGdtYWlsLmNvbT4KQXV0aG9yOiBBamluIENoZXJp YW4gPGl0c2FqaW5AZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSGF5YXRvIEt1cm9kYSA8a3Vyb2Rh LmhheWF0b0BmdWppdHN1LmNvbT4KUmV2aWV3ZWQtYnk6IHZpZ25lc2ggQyA8dmlnbmVzaDIxQGdt YWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0LmthcGlsYTE2QGdtYWlsLmNv bT4KQmFja3BhdGNoLXRocm91Z2g6IDE0LCB3aGVyZSBpdCB3YXMgaW50cm9kdWNlZApEaXNjdXNz aW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2JhYjk1ZTEyLTZjYzUtNGViYi04MGE4LTNlNDE5NTZh YTI5N0BnbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KUkVMXzE0X1NUQUJMRQoKRGV0YWlscwotLS0t LS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvNDFmYjNmNTFjYjc0 ZWNhMWJhOTU5Y2NkMmZiMWMwZDdmZTBiZjExYgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0t LS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19zdWJzY3JpcHRpb24uYyAgICAgICB8IDMzICsrKysr KysrKysrKysrKysrKysrKysrKystLS0tCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwv dGFibGVzeW5jLmMgfCAyNyArKysrKysrKysrKysrKysrKysrKy0tLQpzcmMvaW5jbHVkZS9jYXRh bG9nL3BnX3N1YnNjcmlwdGlvbl9yZWwuaCAgIHwgIDIgKysKMyBmaWxlcyBjaGFuZ2VkLCA1NSBp bnNlcnRpb25zKCspLCA3IGRlbGV0aW9ucygtKQoK --===============7959812436635655097==--