Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKAdT-00087N-G7 for pgsql-committers@arkaria.postgresql.org; Tue, 24 Jan 2023 04:10:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pKAdS-0006EZ-FT for pgsql-committers@arkaria.postgresql.org; Tue, 24 Jan 2023 04:10:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKAdA-0004fX-HU for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:56 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKAd8-0000hX-6x for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:56 +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=vRovdI0Sbk4jC5ksEB6XPLAHqEAsnBRM8oclVJU/5Ro=; b=g2tbwwICK5cbJmHdSGD0fVztij 3MPMjiIltec0y4UbPGHY472ukX86y2Wp1cDQg+8mizaPz82Fkjeq8kIx5eI73lXu/HHxoOmni40F1 Iy4cxQrPbKUseCcI5jy6IjCk4UHJfXyfCtuUd4b5KufroBjeE1VfRLajzn86xXopAVAerp5ZKAdo2 uNPASkwFdNBubFZsHymzVjZ5IQfksOnQDoGXk3deJglkgj5H3wwJIZ9n3mHr0FnZ63VnC+VFrQDO5 Eo8wMs0eTLC8/5EJU6FNaLzlN8tJ3nlxkUjU2p+uh5jCeX2A9W+su66TrzduAwDG9Cbnk9uoJ9XL5 OG1G8Jww==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKAd7-0002Sz-14 for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:53 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pKAd6-005BKw-0b for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:52 +0000 Content-Type: multipart/mixed; boundary="===============2795615913971380046==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix the Drop Database hang. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 24 Jan 2023 04:09:52 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2795615913971380046== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHRoZSBEcm9wIERhdGFiYXNlIGhhbmcuCgpUaGUgZHJvcCBkYXRhYmFzZSBjb21tYW5kIHdh aXRzIGZvciB0aGUgbG9naWNhbCByZXBsaWNhdGlvbiBzeW5jIHdvcmtlciB0bwphY2NlcHQgUHJv Y1NpZ25hbEJhcnJpZXIgYW5kIHRoZSB3b3JrZXIncyBzbG90IGNyZWF0aW9uIHdhaXRzIGZvciB0 aGUgZHJvcApkYXRhYmFzZSB0byBmaW5pc2ggd2hpY2ggbGVhZHMgdG8gYSBkZWFkbG9jay4gVGhp cyBoYXBwZW5zIGJlY2F1c2UgdGhlCnRhYmxlc3luYyB3b3JrZXIgaG9sZHMgaW50ZXJydXB0cyB3 aGlsZSBjcmVhdGluZyBhIHNsb3QuCgpXZSBwcmV2ZW50IGNhbmNlbC9kaWUgaW50ZXJydXB0cyB3 aGlsZSBjcmVhdGluZyBhIHNsb3QgaW4gdGhlIHRhYmxlIHN5bmMKd29ya2VyIGJlY2F1c2UgaXQg aXMgcG9zc2libGUgdGhhdCBiZWZvcmUgdGhlIHNlcnZlciBmaW5pc2hlcyB0aGlzCmNvbW1hbmQs IGEgY29uY3VycmVudCBkcm9wIHN1YnNjcmlwdGlvbiBoYXBwZW5zIHdoaWNoIHdvdWxkIGNvbXBs ZXRlCndpdGhvdXQgcmVtb3ZpbmcgdGhpcyBzbG90IGFuZCB0aGF0IGxlYWRzIHRvIHRoZSBzbG90 IGV4aXN0aW5nIHVudGlsIHRoZQplbmQgb2Ygd2Fsc2VuZGVyLiBIb3dldmVyLCB0aGUgc2xvdCB3 aWxsIGV2ZW50dWFsbHkgZ2V0IGRyb3BwZWQgYXQgdGhlCndhbHNlbmRlciBleGl0IHRpbWUsIHNv IHRoZXJlIGlzIG5vIGRhbmdlciBvZiB0aGUgZGFuZ2xpbmcgc2xvdC4KClRoaXMgcGF0Y2ggcmVh bGxvd3MgY2FuY2VsL2RpZSBpbnRlcnJ1cHRzIHdoaWxlIGNyZWF0aW5nIGEgc2xvdCBhbmQKbW9k aWZpZXMgdGhlIHRlc3QgdG8gd2FpdCBmb3Igc2xvdHMgdG8gYmVjb21lIHplcm8gdG8gcHJldmVu dCBmaW5kaW5nIGFuCmVwaGVtZXJhbCBzbG90LgoKVGhlIHJlcG9ydGVkIGhhbmcgZG9lc24ndCBo YXBwZW4gaW4gUEcxNCBhcyB0aGUgZHJvcCBkYXRhYmFzZSBzdGFydHMgdG8Kd2FpdCBmb3IgUHJv Y1NpZ25hbEJhcnJpZXIgd2l0aCBQRzE1IChjb21taXRzIDRlYjIxNzYzMTggYW5kIGUyZjY1ZjQy NTUpCmJ1dCBpdCBpcyBnb29kIHRvIGJhY2twYXRjaCB0aGlzIHRpbGwgUEcxNCBhcyBpdCBpcyBu b3QgYSBnb29kIGlkZWEgdG8KcHJldmVudCBpbnRlcnJ1cHRzIGR1cmluZyBhIG5ldHdvcmsgY2Fs bCB0aGF0IGNvdWxkIGJsb2NrIGluZGVmaW5pdGVseS4KClJlcG9ydGVkLWJ5OiBMYWtzaG1pIE5h cmF5YW5hbiBTcmVldGhhcgpEaWFnbm9zZWQtYnk6IEFuZHJlcyBGcmV1bmQKQXV0aG9yOiBIb3Ug WmhpamllClJldmlld2VkLWJ5OiBWaWduZXNoIEMsIEFtaXQgS2FwaWxhCkJhY2twYXRjaC10aHJv dWdoOiAxNCwgd2hlcmUgaXQgd2FzIGludHJvZHVjZWQgaW4gY29tbWl0IDZiNjdkNzJiNjAKRGlz Y3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQStrdm1aRUxYUTRaRDNVPVhDWHVHM0t2Rmdr dVBvTjFRckVqOGMtck1Sb2RyTE9uc2dAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KUkVM XzE0X1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3Bn L2NvbW1pdGRpZmYvZmQyNzBiNzI4YjI4YmQxYTI5NzM4Mzc0OTg5NzdkZTY3ZDBhODg3ZQoKTW9k aWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNh bC90YWJsZXN5bmMuYyB8ICA3IC0tLS0tLS0Kc3JjL3Rlc3Qvc3Vic2NyaXB0aW9uL3QvMDA0X3N5 bmMucGwgICAgICAgICB8IDEwICsrKysrKystLS0KMiBmaWxlcyBjaGFuZ2VkLCA3IGluc2VydGlv bnMoKyksIDEwIGRlbGV0aW9ucygtKQoK --===============2795615913971380046==--