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-00087M-G6 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-0006Ea-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 1pKAdB-0004s3-FV for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:57 +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-0000hV-5l for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:57 +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=dSPUbAyZRnhskjHkC/EGfIO/V1yoMzzFawUWAh/VSnI=; b=ZDn06UW5KTxTaNahVLW8uJZhVf hi9CfL1MpbL7DelGAoEb6CRN/hvrgfQbJb8rTuDEpZKIeEvs+uc+3w2+dh3FVVgOBKlc1r+SO3MJK 2fWk/hK4qC0I3SD5JMsYdFi1/ntokbxnhRpw5G3el7sqx2hg4VBlQ1HdNXxSkcrl97PRoCvukdKqt wCtGYR++qjjIgR0jZMz0tOEik8eu9szYkaE1I3PlNsm7acXg1sBgFhTaoY9cUlHm5H/3JpAK5fvjk DPhenJfH7GAWL4V5MKJunvbBB9ZzWlowUU5E3X5gHPf5B+es0Ol5dyde07TRatC1BMHZa2kk97bkn cLT9k43Q==; 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 1pKAd6-0002T0-T5 for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:52 +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 1pKAd5-005BKs-Vr for pgsql-committers@lists.postgresql.org; Tue, 24 Jan 2023 04:09:52 +0000 Content-Type: multipart/mixed; boundary="===============5802706819250135620==" 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 --===============5802706819250135620== 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 dVBvTjFRckVqOGMtck1Sb2RyTE9uc2dAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFz dGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0 ZGlmZi82YzZkNmJhM2VlMmMxNjBiNTNmNzI3Y2Y4ZTYxMjAxNGIzMTZkNmU0CgpNb2RpZmllZCBG aWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL3RhYmxl c3luYy5jIHwgIDcgLS0tLS0tLQpzcmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMDRfc3luYy5wbCAg ICAgICAgIHwgMTAgKysrKysrKy0tLQoyIGZpbGVzIGNoYW5nZWQsIDcgaW5zZXJ0aW9ucygrKSwg MTAgZGVsZXRpb25zKC0pCgo= --===============5802706819250135620==--