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 1oK4rb-00021A-6l for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Aug 2022 21:28:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oK4rZ-0002d0-WA for pgsql-bugs@arkaria.postgresql.org; Fri, 05 Aug 2022 21:28:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oK4gw-0005tO-4A for pgsql-bugs@lists.postgresql.org; Fri, 05 Aug 2022 21:17:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oK4gq-0004rB-At for pgsql-bugs@lists.postgresql.org; Fri, 05 Aug 2022 21:17:09 +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=AJooogDaaAHn8G2aQsjh6/oT23I68aT5Yb1uNj5Y094=; b=0rRSMx8GCCX+sZyfyATek+SXtv TWySPgmYZqSoPNQjBRvI5g5T9x2PQCsTZUOH1jAv5qT+J1sq/Kn1nWHCLqlQd4lsx6oIJtOOmEPo+ mhOf9xoS0vsKt+jlGUU0J3lc7UqT9ZDBCxe93mJ2qejsX4oYQnXPJyxhFzx6CNcGbzDWaDjblzNMm HEIz+VB+l8l50x2JMA7JgDtdmf7uhtXO3x77PKsW8jskuqYoDJnL1GFjqBjw6YYQxp5r5dHK0BFMc 1NYrLhjs/JNm5UQc4trCcD5JrZS9jz0u4aHRM+V2YMZqU/3dC2EeqUlfn5fY2xcsgtkQ9hPg7UFTo /11D98EQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oK4gp-0002hR-PM for pgsql-bugs@lists.postgresql.org; Fri, 05 Aug 2022 21:17:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oK4go-002187-CY for pgsql-bugs@lists.postgresql.org; Fri, 05 Aug 2022 21:17:02 +0000 Content-Type: multipart/mixed; boundary="===============1949918638442443359==" MIME-Version: 1.0 Subject: BUG #17578: undetected (on one side) deadlock with reindex CONCURRENTLY partitioned index vs drop index To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 05 Aug 2022 21:16:57 +0000 Message-ID: <17578-6c41993c9876cb92@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 --===============1949918638442443359== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU3OApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuNApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KSXQncyBvZiBjb3Vyc2UgdmVyeSBzeW50aGV0aWMgY2FzZSBidXQgaXQgbWlnaHQgYmUgc3lt cHRvbSBvZiBzb21lIGlzc3Vlcwp3aXRoIGRlYWRsb2NrIGRldGVjdGlvbiBpbiBzb21lIGNhc2Vz Lg0KTXkgZXhwZWN0YXRpb25zIHdhcyB0aGF0IHRoZSBzZXNzaW9uIHdpdGggbG9uZ2VyIGRlYWRs b2NrIHRpbWVvdXQgc2hvdWxkCmFsd2F5cyB3aW4gYW5kIHNlc3Npb24gd2l0aCBzaG9ydGVyIGRl YWRsb2NrIHRpbWVvdXQgc2hvdWxkIGxvc3QgbG9ja2luZwpyYWNlIChhbmQgZXJyb3Igb3V0IHdp dGggZGVhZGxvY2sgbWVzc2FnZSkuDQoNCkhvd2V2ZXIgdGhlcmUgaXMgY2FzZSB3aGVyZSBkZWFk bG9jayBkZXRlY3Rpb24gZG9lc24ndCB3b3JrIHRoYXQgd2F5IGluClNFU1NJT04gVFdPOg0KDQot LXByZXBhcmUgZGF0YQ0KY3JlYXRlIHRhYmxlIHRlc3QgKGlkIGludGVnZXIpIHBhcnRpdGlvbiBi eSByYW5nZShpZCk7DQpjcmVhdGUgdGFibGUgdGVzdF9wYXJ0XzEwMDAwMDAgcGFydGl0aW9uIG9m IHRlc3QgZm9yIHZhbHVlcyBmcm9tICgwKSB0bwooMTAwMDAwMCk7DQppbnNlcnQgaW50byB0ZXN0 X3BhcnRfMTAwMDAwMCBzZWxlY3QgKHJhbmRvbSgpKjk5OTk5OSk6OmludGVnZXIgZnJvbQpnZW5l cmF0ZV9zZXJpZXMoMSwgMTAwMDAwMDApOw0KY3JlYXRlIGluZGV4IHRlc3RfaWRfa2V5IG9uIG9u bHkgdGVzdChpZCk7DQpjcmVhdGUgaW5kZXggQ09OQ1VSUkVOVExZIHRlc3RfcGFydF8xMDAwMDAw X2lkX2tleSBvbgp0ZXN0X3BhcnRfMTAwMDAwMChpZCk7DQphbHRlciBpbmRleCB0ZXN0X2lkX2tl eSBhdHRhY2ggcGFydGl0aW9uIHRlc3RfcGFydF8xMDAwMDAwX2lkX2tleTsNCg0KU0VTU0lPTiBP TkUNCnNldCBkZWFkbG9ja190aW1lb3V0IHRvICcxMDAwcyc7DQpTRVQNCnJlaW5kZXggaW5kZXgg Q09OQ1VSUkVOVExZIHRlc3RfaWRfa2V5Ow0KDQoNClNFU1NJT04gVFdPIA0Kc2hvdyBkZWFkbG9j a190aW1lb3V0IDsNCiBkZWFkbG9ja190aW1lb3V0IA0KLS0tLS0tLS0tLS0tLS0tLS0tDQogMXMN CihydW4gd2hpbGUgcmVpbmRleCBjb25jdXJyZW50bHkgcnVuIGluIHNlc3Npb24gMSkNCmRyb3Ag aW5kZXggdGVzdF9wYXJ0XzEwMDAwMDBfaWRfa2V5X2NjbmV3Ow0KDQoNCmV4cGVjdGVkIGJlaGF2 aW9yDQpTRVNTSU9OIFRXTyBpbiBvbmUgc2Vjb25kIGRldGVjdCBpdCBpbiBkZWFkbG9jayBjb25k aXRpb24gYW5kIGVycm9yIG91dA0KYWN0dWFsIGJlaGF2aW9yDQpTRVNTSU9OIHdhaXQgdW50aWwg U0VTU0lPTiBPTkUgcmVhY2ggaXQgMTAwMHMgZGVhZGxvY2sgdGltZW91dCBhbmQgU0VTU0lPTgpP TkUgZXJyb3Igb3V0IHdpdGggZGVhZGxvY2sgbWVzc2FnZQ0KKA0Kc2Vzc2lvbiBvbmU6DQpyZWlu ZGV4IGluZGV4IENPTkNVUlJFTlRMWSB0ZXN0X2lkX2tleTsNCkVSUk9SOiAgZGVhZGxvY2sgZGV0 ZWN0ZWQNCkRFVEFJTDogIFByb2Nlc3MgMjY2MDkzIHdhaXRzIGZvciBTaGFyZUxvY2sgb24gdmly dHVhbCB0cmFuc2FjdGlvbiA0LzIyMzgxOwpibG9ja2VkIGJ5IHByb2Nlc3MgMjY2MTA3Lg0KUHJv Y2VzcyAyNjYxMDcgd2FpdHMgZm9yIEFjY2Vzc0V4Y2x1c2l2ZUxvY2sgb24gcmVsYXRpb24gNDA5 ODYgb2YgZGF0YWJhc2UKMjQ1Nzk7IGJsb2NrZWQgYnkgcHJvY2VzcyAyNjYwOTMuDQpISU5UOiAg U2VlIHNlcnZlciBsb2cgZm9yIHF1ZXJ5IGRldGFpbHMuDQoNCnNlc3Npb24gdHdvOg0KZHJvcCBp bmRleCB0ZXN0X3BhcnRfMTAwMDAwMF9pZF9rZXlfY2NuZXc7DQpEUk9QIElOREVYDQpUaW1lOiAx MDA1MDUyLjIxMCBtcyAoMTY6NDUuMDUyKQ0KKQ0KDQpQUzogdGhlcmUgYXJlIHNlZW1zIHNvbWUg bW9yZSBjYXNlcyBvZiBmdW5ueSBiZWhhdmlvciBiZXR3ZWVuIGRpZmZlcmVudApjb25jdXJyZW50 IG9wZXJhdGlvbnMgb24gcGFydGl0aW9uZWQgaW5kZXhlcyANCih0aGlzIGlzIGVhc2llc3QgdG8g cmVwcm9kdWNlKS4KCg== --===============1949918638442443359==--