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 1pEsCZ-0002qF-Sj for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Jan 2023 13:28:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEsCV-0003Es-Ho for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Jan 2023 13:28:31 +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 1pEnfU-0000d9-2j for pgsql-bugs@lists.postgresql.org; Mon, 09 Jan 2023 08:38:08 +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 1pEnfR-0001Wr-KD for pgsql-bugs@lists.postgresql.org; Mon, 09 Jan 2023 08:38:07 +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=B1hU4KFSieKHUZLQANcJ4cbNityqHGBvcPr+RpuY48M=; b=dilMSLfs/JuQJ2Ap/LBT2EdqGQ t/oI9gO5c3AXZcVXmQuivtM9SzBhP19Lkn7fFr2lPjswjD9KW8CB0PSdtsqlK0Czh23gMKGYtX2qC 76ubSMmF1jkyfapMK6h+wRD87YnI1HaV88SeLp+mG9YlTtGzI+F7uL+eLwv/txxWIARSAKJzyyumV 22Yzx2A4oaGKaVJUC/i6DR9aN6Z/CMJb07e9GfO7CfvFm2Odcid6uhXJtfZNK1pyXLC7XHxXG8LOU hI7mebjx8qaRqXYnjlRrTNv0MVY4OCfNSxeTzmBOUuzFQ6Ll2Yvg9pdx3Nvck1/rrx9Vx6oLtXHXm OQatqNsg==; 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 1pEnfQ-00053M-5y for pgsql-bugs@lists.postgresql.org; Mon, 09 Jan 2023 08:38:05 +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 1pEnfN-00AQne-Km for pgsql-bugs@lists.postgresql.org; Mon, 09 Jan 2023 08:38:02 +0000 Content-Type: multipart/mixed; boundary="===============7668392185187192746==" MIME-Version: 1.0 Subject: BUG #17741: vacuum process hangs after pg_surgery manipulations To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: a.kozhemyakin@postgrespro.ru Reply-To: a.kozhemyakin@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Mon, 09 Jan 2023 08:37:37 +0000 Message-ID: <17741-5d8764718b2c2b6f@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 --===============7668392185187192746== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzc0MQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBLb3poZW15 YWtpbgpFbWFpbCBhZGRyZXNzOiAgICAgIGEua296aGVteWFraW5AcG9zdGdyZXNwcm8ucnUKUG9z dGdyZVNRTCB2ZXJzaW9uOiAxNS4xCk9wZXJhdGluZyBzeXN0ZW06ICAgRGViaWFuIDEwICh4ODZf NjQpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpPbiB0aGUgUkVMXzE1X1NUQUJMRSwgeW91IGNhbiBo YW5nIHZhY3V1bSBmcmVlemUuIE1heWJlIHRoaXMgaXMgbm90CmRlc2lyZWQ/DQpodHRwczovL3d3 dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvcGdzdXJnZXJ5Lmh0bWwNCg0KcmVwcm9kdWNl IHNjcmlwdDoNCmNyZWF0ZSBleHRlbnNpb24gcGdfc3VyZ2VyeTsNCmNyZWF0ZSB0YWJsZSB0MShh IGludCk7DQppbnNlcnQgaW50byB0MSB2YWx1ZXMgKDEpOw0KdXBkYXRlIHQxIHNldCBhID0gMjsN CnNlbGVjdCBoZWFwX2ZvcmNlX2tpbGwoJ3QxJzo6cmVnY2xhc3MsIEFSUkFZWycoMCwgMSknXTo6 dGlkW10pOw0Kc2VsZWN0IGN0aWQgZnJvbSB0MTsNCnVwZGF0ZSB0MSBzZXQgYSA9IDM7DQpzZWxl Y3QgY3RpZCBmcm9tIHQxOw0KdmFjdXVtIGZyZWV6ZSB0MTsNCg0KTm93IHdlIGhhdmUgaHVuZyB2 YWN1dW0gcHJvY2Vzcy4NCnN0YWNrdHJhY2U6DQojMCAgMHgwMDAwNTYxYjg5MTcwNTE1IGluIGhl YXBfcHJ1bmVfY2hhaW4gKHByc3RhdGU9MHg3ZmZkMjQzYThmYjAsCnJvb3RvZmZudW09MiwgYnVm ZmVyPTEyOSkgYXQgcHJ1bmVoZWFwLmM6NjE1DQojMSAgaGVhcF9wYWdlX3BydW5lIChyZWxhdGlv bj1yZWxhdGlvbkBlbnRyeT0weDdmZDE0ZmEzY2JhOCwKYnVmZmVyPWJ1ZmZlckBlbnRyeT0xMjks IHZpc3Rlc3Q9PG9wdGltaXplZCBvdXQ+LApvbGRfc25hcF94bWluPW9sZF9zbmFwX3htaW5AZW50 cnk9MCwgb2xkX3NuYXBfdHM9b2xkX3NuYXBfdHNAZW50cnk9MCwKbm5ld2xwZGVhZD1ubmV3bHBk ZWFkQGVudHJ5PTB4N2ZmZDI0M2E5YzA0LCBvZmZfbG9jPTB4NTYxYjhhZTNmODdjKQ0KICAgIGF0 IHBydW5laGVhcC5jOjM3Ng0KIzIgIDB4MDAwMDU2MWI4OTE3Mjc1NyBpbiBsYXp5X3NjYW5fcHJ1 bmUKKHZhY3JlbD12YWNyZWxAZW50cnk9MHg1NjFiOGFlM2Y3ZjgsIGJ1Zj1idWZAZW50cnk9MTI5 LCBibGtubz1ibGtub0BlbnRyeT0wLApwYWdlPXBhZ2VAZW50cnk9MHg3ZmQxNTAzYWJjMDAgIiIs CnBydW5lc3RhdGU9cHJ1bmVzdGF0ZUBlbnRyeT0weDdmZmQyNDNhYWViMCkgYXQgdmFjdXVtbGF6 eS5jOjE1OTANCiMzICAweDAwMDA1NjFiODkxNzQ1MWIgaW4gbGF6eV9zY2FuX2hlYXAgKHZhY3Jl bD0weDU2MWI4YWUzZjdmOCkgYXQKdmFjdXVtbGF6eS5jOjEwNDgNCiM0ICBoZWFwX3ZhY3V1bV9y ZWwgKHJlbD0weDdmZDE0ZmEzY2JhOCwgcGFyYW1zPTB4N2ZmZDI0M2FiMzYwLApic3RyYXRlZ3k9 PG9wdGltaXplZCBvdXQ+KSBhdCB2YWN1dW1sYXp5LmM6NTM0DQojNSAgMHgwMDAwNTYxYjg5Mjlk MWJiIGluIHRhYmxlX3JlbGF0aW9uX3ZhY3V1bSAoYnN0cmF0ZWd5PTxvcHRpbWl6ZWQgb3V0PiwK cGFyYW1zPTB4N2ZmZDI0M2FiMzYwLCByZWw9MHg3ZmQxNGZhM2NiYTgpIGF0Ci4uLy4uLy4uL3Ny Yy9pbmNsdWRlL2FjY2Vzcy90YWJsZWFtLmg6MTY4MA0KIzYgIHZhY3V1bV9yZWwgKHJlbGlkPTI0 NTc2LCByZWxhdGlvbj08b3B0aW1pemVkIG91dD4sCnBhcmFtcz1wYXJhbXNAZW50cnk9MHg3ZmZk MjQzYWIzNjApIGF0IHZhY3V1bS5jOjIwODYNCiM3ICAweDAwMDA1NjFiODkyOWU2ZjUgaW4gdmFj dXVtIChyZWxhdGlvbnM9MHg1NjFiOGFlZTY2NjgsCnBhcmFtcz0weDdmZmQyNDNhYjM2MCwgYnN0 cmF0ZWd5PTxvcHRpbWl6ZWQgb3V0PiwgaXNUb3BMZXZlbD08b3B0aW1pemVkCm91dD4pIGF0IHZh Y3V1bS5jOjQ3NQ0KIzggIDB4MDAwMDU2MWI4OTI5ZWMxZiBpbiBFeGVjVmFjdXVtIChwc3RhdGU9 cHN0YXRlQGVudHJ5PTB4NTYxYjhhZWRiYWU4LAp2YWNzdG10PXZhY3N0bXRAZW50cnk9MHg1NjFi OGFlMWEyNjgsIGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10cnVlKSBhdAp2YWN1dW0uYzoy NzUNCiM5ICAweDAwMDA1NjFiODk0MGMzZDAgaW4gc3RhbmRhcmRfUHJvY2Vzc1V0aWxpdHkgKHBz dG10PTB4NTYxYjhhZTFhNjI4LApxdWVyeVN0cmluZz0weDU2MWI4YWUxOTdiOCAidmFjdXVtIGZy ZWV6ZSB0MTsiLCByZWFkT25seVRyZWU9PG9wdGltaXplZApvdXQ+LCBjb250ZXh0PVBST0NFU1Nf VVRJTElUWV9UT1BMRVZFTCwgcGFyYW1zPTB4MCwgcXVlcnlFbnY9MHgwLApkZXN0PTB4NTYxYjhh ZTFhNzA4LCBxYz0weDdmZmQyNDNhYjZiMCkNCiAgICBhdCB1dGlsaXR5LmM6ODY2DQojMTAgMHgw MDAwNTYxYjg5NDBhYjNmIGluIFBvcnRhbFJ1blV0aWxpdHkKKHBvcnRhbD1wb3J0YWxAZW50cnk9 MHg1NjFiOGFlODcwMTgsIHBzdG10PXBzdG10QGVudHJ5PTB4NTYxYjhhZTFhNjI4LAppc1RvcExl dmVsPWlzVG9wTGV2ZWxAZW50cnk9dHJ1ZSwKc2V0SG9sZFNuYXBzaG90PXNldEhvbGRTbmFwc2hv dEBlbnRyeT1mYWxzZSwgZGVzdD0weDU2MWI4YWUxYTcwOCwKcWM9MHg3ZmZkMjQzYWI2YjApIGF0 IHBxdWVyeS5jOjExNTgNCiMxMSAweDAwMDA1NjFiODk0MGFjNzMgaW4gUG9ydGFsUnVuTXVsdGkK KHBvcnRhbD1wb3J0YWxAZW50cnk9MHg1NjFiOGFlODcwMTgsIGlzVG9wTGV2ZWw9aXNUb3BMZXZl bEBlbnRyeT10cnVlLApzZXRIb2xkU25hcHNob3Q9c2V0SG9sZFNuYXBzaG90QGVudHJ5PWZhbHNl LCBkZXN0PWRlc3RAZW50cnk9MHg1NjFiOGFlMWE3MDgsCmFsdGRlc3Q9YWx0ZGVzdEBlbnRyeT0w eDU2MWI4YWUxYTcwOCwgcWM9cWNAZW50cnk9MHg3ZmZkMjQzYWI2YjApDQogICAgYXQgcHF1ZXJ5 LmM6MTMxNQ0KIzEyIDB4MDAwMDU2MWI4OTQwYjE3ZiBpbiBQb3J0YWxSdW4gKHBvcnRhbD1wb3J0 YWxAZW50cnk9MHg1NjFiOGFlODcwMTgsCmNvdW50PWNvdW50QGVudHJ5PTkyMjMzNzIwMzY4NTQ3 NzU4MDcsIGlzVG9wTGV2ZWw9aXNUb3BMZXZlbEBlbnRyeT10cnVlLApydW5fb25jZT1ydW5fb25j ZUBlbnRyeT10cnVlLCBkZXN0PWRlc3RAZW50cnk9MHg1NjFiOGFlMWE3MDgsCmFsdGRlc3Q9YWx0 ZGVzdEBlbnRyeT0weDU2MWI4YWUxYTcwOCwNCiAgICBxYz0weDdmZmQyNDNhYjZiMCkgYXQgcHF1 ZXJ5LmM6NzkxDQojMTMgMHgwMDAwNTYxYjg5NDA3NzYzIGluIGV4ZWNfc2ltcGxlX3F1ZXJ5IChx dWVyeV9zdHJpbmc9MHg1NjFiOGFlMTk3YjgKInZhY3V1bSBmcmVlemUgdDE7IikgYXQgcG9zdGdy ZXMuYzoxMjUwDQojMTQgMHgwMDAwNTYxYjg5NDA4NDBiIGluIFBvc3RncmVzTWFpbiAoZGJuYW1l PTxvcHRpbWl6ZWQgb3V0PiwKdXNlcm5hbWU9PG9wdGltaXplZCBvdXQ+KSBhdCBwb3N0Z3Jlcy5j OjQ1OTMNCiMxNSAweDAwMDA1NjFiODkzOGU3OTEgaW4gQmFja2VuZFJ1biAocG9ydD08b3B0aW1p emVkIG91dD4sIHBvcnQ9PG9wdGltaXplZApvdXQ+KSBhdCBwb3N0bWFzdGVyLmM6NDUwNA0KIzE2 IEJhY2tlbmRTdGFydHVwIChwb3J0PTxvcHRpbWl6ZWQgb3V0PikgYXQgcG9zdG1hc3Rlci5jOjQy MzINCiMxNyBTZXJ2ZXJMb29wICgpIGF0IHBvc3RtYXN0ZXIuYzoxODA2DQojMTggMHgwMDAwNTYx Yjg5MzhmNzE4IGluIFBvc3RtYXN0ZXJNYWluIChhcmdjPTMsIGFyZ3Y9MHg1NjFiOGFlMTNkYjAp IGF0CnBvc3RtYXN0ZXIuYzoxNDc4DQojMTkgMHgwMDAwNTYxYjg5MTIzZjE5IGluIG1haW4gKGFy Z2M9MywgYXJndj0weDU2MWI4YWUxM2RiMCkgYXQgbWFpbi5jOjIwMgoK --===============7668392185187192746==--