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 1mgSv6-0008Or-A0 for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Oct 2021 14:31:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgSv5-0007Ek-9y for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Oct 2021 14:31:47 +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 1mgRVQ-0004k4-43 for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 13:01:12 +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 1mgRVJ-0002tE-8K for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 13:01:11 +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=hTqDRNuafQc2Gi+0IwdasXaQ6DPsxS4QBMZJJKxTq3E=; b=ZwKTXGGvLg/cu2dos1zZkj5jjm r+/UGUNDUEaZmxajtlYKEAibW6sdm2CVwLmqwu3ghNTam2w9rr9cofylml2+S7yBhRdOzTPbclfyD nWfODa5By24p+heZKDCrq64dWdyxOxkLLmLhoDQe7lZTBrOxXQ8BLQqg7DR335y6T3JGs43Xq6EmS Nv7+YcM8ms5pvXnT3O+o1CVP5nHr2NJw9YmkXxmoPcQmb1yDTFbM1lWbgCzPneZ2xYTsM2P109uli lieazM2uQnQBKNl/fXsPmiBz8mfAGaqIHPwpPZqzMyDif0Jgk/EAHBiyHKgRT4/2IARmrIWPtK65W CnKArOtA==; 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 1mgRVH-0005pt-SH for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 13:01:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgRVG-0008I5-LU for pgsql-bugs@lists.postgresql.org; Fri, 29 Oct 2021 13:01:02 +0000 Content-Type: multipart/mixed; boundary="===============3323833953440008605==" MIME-Version: 1.0 Subject: BUG #17257: (auto)vacuum hangs within lazy_scan_prune() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: exclusion@gmail.com Reply-To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 29 Oct 2021 13:00:03 +0000 Message-ID: <17257-1e46de26bec11433@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 --===============3323833953440008605== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI1NwpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTQuMApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBydW5uaW5nIGNvbmN1cnJlbnQgaW5zdGFsbGNoZWNrcyAoeDEwMCkgSSd2ZSBv YnNlcnZlZCB0aGUgYXV0b3ZhY3V1bQpwcm9jZXNzIGhhbmdpbmc6DQoNCnRlc3RlciAgICAzMjg3 MTMgIDMyODcwNiAgMCAxMjoxOSA/ICAgICAgICAwMDowMjowMyBwb3N0Z3JlczogbG9naWNhbApy ZXBsaWNhdGlvbiBsYXVuY2hlciANCnRlc3RlciAgIDMzMDE3ODggIDMyODcwNiAgMCAxNjozMyA/ ICAgICAgICAwMDowMDowMiBwb3N0Z3JlczogcG9zdGdyZXMKcmVncmVzczAzMCAxMjcuMC4wLjEo NDQ1MzQpIENSRUFURSBUQUJMRQ0KdGVzdGVyICAgMzMwMjA3NiAgMzI4NzA2IDk5IDE2OjMzID8g ICAgICAgIDA1OjE3OjEwIHBvc3RncmVzOiBhdXRvdmFjdXVtCndvcmtlciByZWdyZXNzMDMwDQp0 ZXN0ZXIgICAzMzExNDI0ICAzMjg3MDYgIDAgMTY6MzQgPyAgICAgICAgMDA6MDM6MDkgcG9zdGdy ZXM6IHBvc3RncmVzCnJlZ3Jlc3MwOTAgMTI3LjAuMC4xKDQ4NzQ0KSBBTFRFUiBUQUJMRQ0KdGVz dGVyICAgMzMxMTQ1MyAgMzI4NzA2ICAxIDE2OjM0ID8gICAgICAgIDAwOjAzOjEyIHBvc3RncmVz OiBwb3N0Z3JlcwpyZWdyZXNzMDQ4IDEyNy4wLjAuMSg0ODc2OCkgQUxURVIgVEFCTEUNCnRlc3Rl ciAgIDMzMTE0NjEgIDMyODcwNiAgMSAxNjozNCA/ICAgICAgICAwMDowMzoxMSBwb3N0Z3Jlczog cG9zdGdyZXMKcmVncmVzczAxNyAxMjcuMC4wLjEoNDg3NzQpIERST1AgVEFCTEUNCnRlc3RlciAg IDMzMTE0OTAgIDMyODcwNiAgMCAxNjozNCA/ICAgICAgICAwMDowMzowOSBwb3N0Z3JlczogcG9z dGdyZXMKcmVncmVzczAwNiAxMjcuMC4wLjEoNDg4MDQpIEFMVEVSIFRBQkxFDQp0ZXN0ZXIgICAz MzExNDkzICAzMjg3MDYgIDAgMTY6MzQgPyAgICAgICAgMDA6MDM6MDggcG9zdGdyZXM6IHBvc3Rn cmVzCnJlZ3Jlc3MwMDggMTI3LjAuMC4xKDQ4ODA2KSBBTFRFUiBUQUJMRQ0KDQpnZGIgc2hvd2Vk IHRoZSBmb2xsb3dpbmcgc3RhY2t0cmFjZToNCjB4MDAwMDU2NGQ2YzkzY2QxZiBpbiBHZXRQcml2 YXRlUmVmQ291bnRFbnRyeSAoYnVmZmVyPTxvcHRpbWl6ZWQgb3V0PiwKZG9fbW92ZT08b3B0aW1p emVkIG91dD4pIGF0IGJ1Zm1nci5jOjMxMg0KMzEyICAgICAgICAgICAgIEFzc2VydChCdWZmZXJJ c1ZhbGlkKGJ1ZmZlcikpOw0KKGdkYikgYnQNCiMwICAweDAwMDA1NjRkNmM5M2NkMWYgaW4gR2V0 UHJpdmF0ZVJlZkNvdW50RW50cnkgKGJ1ZmZlcj08b3B0aW1pemVkIG91dD4sCmRvX21vdmU9PG9w dGltaXplZCBvdXQ+KSBhdCBidWZtZ3IuYzozMTINCiMxICAweDAwMDA1NjRkNmM5M2ZiNzkgaW4g R2V0UHJpdmF0ZVJlZkNvdW50IChidWZmZXI9MTExNDIyKSBhdApidWZtZ3IuYzozOTgNCiMyICBC dWZmZXJHZXRCbG9ja051bWJlciAoYnVmZmVyPWJ1ZmZlckBlbnRyeT0xMTE0MjIpIGF0IGJ1Zm1n ci5jOjI3NzENCiMzICAweDAwMDA1NjRkNmI4MzUxOWQgaW4gaGVhcF9wcnVuZV9jaGFpbiAocHJz dGF0ZT0weDdmZmYwN2YwM2UxMCwKcm9vdG9mZm51bT03LCBidWZmZXI9MTExNDIyKSBhdCBwcnVu ZWhlYXAuYzo2MjUNCiM0ICBoZWFwX3BhZ2VfcHJ1bmUgKHJlbGF0aW9uPXJlbGF0aW9uQGVudHJ5 PTB4N2ZhNjBhOWNmZjgwLApidWZmZXI9YnVmZmVyQGVudHJ5PTExMTQyMiwgDQogICAgdmlzdGVz dD12aXN0ZXN0QGVudHJ5PTB4NTY0ZDcxMDgxNmEwIDxHbG9iYWxWaXNDYXRhbG9nUmVscz4sCm9s ZF9zbmFwX3htaW49b2xkX3NuYXBfeG1pbkBlbnRyeT0wLCANCiAgICBvbGRfc25hcF90cz1vbGRf c25hcF90c0BlbnRyeT0wLCByZXBvcnRfc3RhdHM9cmVwb3J0X3N0YXRzQGVudHJ5PWZhbHNlLApv ZmZfbG9jPTxvcHRpbWl6ZWQgb3V0PikgYXQgcHJ1bmVoZWFwLmM6Mjc4DQojNSAgMHgwMDAwNTY0 ZDZiODRhN2Q0IGluIGxhenlfc2Nhbl9wcnVuZSAodmFjcmVsPTB4NjI1MDAwMDQ0MTkwLApidWY9 PG9wdGltaXplZCBvdXQ+LCBibGtubz08b3B0aW1pemVkIG91dD4sIA0KICAgIHBhZ2U9MHg3ZmE2 NDJiZGQ1ODAgPGluY29tcGxldGUgc2VxdWVuY2UgXDMzND4sIHZpc3Rlc3Q9PG9wdGltaXplZCBv dXQ+LApwcnVuZXN0YXRlPTxvcHRpbWl6ZWQgb3V0PikNCiAgICBhdCB2YWN1dW1sYXp5LmM6MTc0 MQ0KIzYgIDB4MDAwMDU2NGQ2Yjg1OTdjZCBpbiBsYXp5X3NjYW5faGVhcCAoYWdncmVzc2l2ZT08 b3B0aW1pemVkIG91dD4sCnBhcmFtcz08b3B0aW1pemVkIG91dD4sIHZhY3JlbD08b3B0aW1pemVk IG91dD4pDQogICAgYXQgdmFjdXVtbGF6eS5jOjEzODQNCiM3ICBoZWFwX3ZhY3V1bV9yZWwgKHJl bD08b3B0aW1pemVkIG91dD4sIHBhcmFtcz08b3B0aW1pemVkIG91dD4sCmJzdHJhdGVneT08b3B0 aW1pemVkIG91dD4pIGF0IHZhY3V1bWxhenkuYzo2MzgNCiM4ICAweDAwMDA1NjRkNmJmOWI2YjYg aW4gdGFibGVfcmVsYXRpb25fdmFjdXVtIChic3RyYXRlZ3k9PG9wdGltaXplZCBvdXQ+LApwYXJh bXM9MHg2MjUwMDAwMjcyYzQsIHJlbD0weDdmYTYwYTljZmY4MCkNCiAgICBhdCAuLi8uLi8uLi9z cmMvaW5jbHVkZS9hY2Nlc3MvdGFibGVhbS5oOjE2NzgNCiM5ICB2YWN1dW1fcmVsIChyZWxpZD08 b3B0aW1pemVkIG91dD4sIHJlbGF0aW9uPTxvcHRpbWl6ZWQgb3V0PiwKcGFyYW1zPTB4NjI1MDAw MDI3MmM0KSBhdCB2YWN1dW0uYzoyMDM0DQojMTAgMHgwMDAwNTY0ZDZiZmExMWYwIGluIHZhY3V1 bSAocmVsYXRpb25zPTB4NjI1MDAwMDQxMjc4LApyZWxhdGlvbnNAZW50cnk9MHg2MjUwMDAwNTUy YjAsIA0KICAgIHBhcmFtcz1wYXJhbXNAZW50cnk9MHg2MjUwMDAwMjcyYzQsIGJzdHJhdGVneT08 b3B0aW1pemVkIG91dD4sCmJzdHJhdGVneUBlbnRyeT0weDYyNTAwMDA1MzA0OCwgDQogICAgaXNU b3BMZXZlbD1pc1RvcExldmVsQGVudHJ5PXRydWUpIGF0IHZhY3V1bS5jOjQ3NQ0KIzExIDB4MDAw MDU2NGQ2YzZlM2EzNyBpbiBhdXRvdmFjdXVtX2RvX3ZhY19hbmFseXplCihic3RyYXRlZ3k9MHg2 MjUwMDAwNTMwNDgsIHRhYj0weDYyNTAwMDAyNzJjMCkgYXQgYXV0b3ZhY3V1bS5jOjMyNDINCiMx MiBkb19hdXRvdmFjdXVtICgpIGF0IGF1dG92YWN1dW0uYzoyNDkwDQojMTMgMHgwMDAwNTY0ZDZj NmU2NjgxIGluIEF1dG9WYWNXb3JrZXJNYWluIChhcmd2PTB4MCwgYXJnYz0wKSBhdAphdXRvdmFj dXVtLmM6MTcxNA0KIzE0IDB4MDAwMDU2NGQ2YzZlNmE5NSBpbiBTdGFydEF1dG9WYWNXb3JrZXIg KCkgYXQgYXV0b3ZhY3V1bS5jOjE0OTkNCiMxNSAweDAwMDA1NjRkNmM3MjcyZDQgaW4gU3RhcnRB dXRvdmFjdXVtV29ya2VyICgpIGF0IHBvc3RtYXN0ZXIuYzo1NTYxDQojMTYgc2lndXNyMV9oYW5k bGVyIChwb3N0Z3Jlc19zaWduYWxfYXJnPTxvcHRpbWl6ZWQgb3V0PikgYXQKcG9zdG1hc3Rlci5j OjUyNjYNCiMxNyA8c2lnbmFsIGhhbmRsZXIgY2FsbGVkPg0KIzE4IF9fR0lfX19zaWdwcm9jbWFz ayAoaG93PTIsIHNldD08b3B0aW1pemVkIG91dD4sIG9zZXQ9MHgwKSBhdAouLi9zeXNkZXBzL3Vu aXgvc3lzdi9saW51eC9zaWdwcm9jbWFzay5jOjM5DQojMTkgMHgwMDAwNTY0ZDZiNTJlZmM0IGlu IF9faW50ZXJjZXB0b3Jfc2lncHJvY21hc2sucGFydC4wICgpDQojMjAgMHgwMDAwNTY0ZDZjNzI3 ZDllIGluIFNlcnZlckxvb3AgKCkgYXQgcG9zdG1hc3Rlci5jOjE3MDcNCiMyMSAweDAwMDA1NjRk NmM3MmMzMDkgaW4gUG9zdG1hc3Rlck1haW4gKGFyZ2M9YXJnY0BlbnRyeT0zLAphcmd2PWFyZ3ZA ZW50cnk9MHg2MDMwMDAwMDAyNTApIGF0IHBvc3RtYXN0ZXIuYzoxNDE3DQojMjIgMHgwMDAwNTY0 ZDZiNGY2OTk1IGluIG1haW4gKGFyZ2M9MywgYXJndj0weDYwMzAwMDAwMDI1MCkgYXQgbWFpbi5j OjIwOQ0KDQooZ2RiKSBiIDE4MjANCkJyZWFrcG9pbnQgMSBhdCAweDU2NGQ2Yjg0YjM3ODogZmls ZSB2YWN1dW1sYXp5LmMsIGxpbmUgMTgyMC4NCihnZGIpIGNvbnQNCkNvbnRpbnVpbmcuDQoNCkJy ZWFrcG9pbnQgMSwgbGF6eV9zY2FuX3BydW5lICh2YWNyZWw9MHg2MjUwMDAwNDQxOTAsIGJ1Zj08 b3B0aW1pemVkIG91dD4sCmJsa25vPTxvcHRpbWl6ZWQgb3V0PiwgDQogICAgcGFnZT0weDdmYTY0 MmJkZDU4MCA8aW5jb21wbGV0ZSBzZXF1ZW5jZSBcMzM0PiwgdmlzdGVzdD08b3B0aW1pemVkIG91 dD4sCnBydW5lc3RhdGU9PG9wdGltaXplZCBvdXQ+KQ0KICAgIGF0IHZhY3V1bWxhenkuYzoxODIw DQoxODIwICAgICAgICAgICAgICAgICAgICAgICAgICAgIGdvdG8gcmV0cnk7DQoNCihnZGIpIHBy aW50ICp2YWNyZWwNCiQxNSA9IHtyZWwgPSAweDdmYTYwYTljZmY4MCwgaW5kcmVscyA9IDB4NjI1 MDAwMDQzYjcwLCBuaW5kZXhlcyA9IDUsCmZhaWxzYWZlX2FjdGl2ZSA9IGZhbHNlLCANCiAgY29u c2lkZXJfYnlwYXNzX29wdGltaXphdGlvbiA9IHRydWUsIGRvX2luZGV4X3ZhY3V1bWluZyA9IHRy dWUsCmRvX2luZGV4X2NsZWFudXAgPSB0cnVlLCBkb19yZWxfdHJ1bmNhdGUgPSB0cnVlLCANCiAg YnN0cmF0ZWd5ID0gMHg2MjUwMDAwNTMwNDgsIGxwcyA9IDB4MCwgb2xkX3JlbF9wYWdlcyA9IDYs IG9sZF9saXZlX3R1cGxlcwo9IDEzMywgcmVsZnJvemVueGlkID0gNzI2LCByZWxtaW5teGlkID0g MSwgDQogIE9sZGVzdFhtaW4gPSA0ODE1NTAwNCwgRnJlZXplTGltaXQgPSA0MjkzMTIyMzAwLCBN dWx0aVhhY3RDdXRvZmYgPQo0Mjg5OTczMzExLCANCiAgcmVsbmFtZXNwYWNlID0gMHg2MjUwMDAw NDQxNDAgInBnX2NhdGFsb2ciLCByZWxuYW1lID0gMHg2MjUwMDAwNDQxNjgKInBnX2NvbnN0cmFp bnQiLCBpbmRuYW1lID0gMHgwLCBibGtubyA9IDExLCANCiAgb2ZmbnVtID0gMzIsIHBoYXNlID0g VkFDVVVNX0VSUkNCX1BIQVNFX1NDQU5fSEVBUCwgZGVhZF90dXBsZXMgPQoweDYyYTAwMDBhODI0 MCwgcmVsX3BhZ2VzID0gMTMsIHNjYW5uZWRfcGFnZXMgPSAxMiwgDQogIHBpbnNraXBwZWRfcGFn ZXMgPSAwLCBmcm96ZW5za2lwcGVkX3BhZ2VzID0gMCwgdHVwY291bnRfcGFnZXMgPSAxMiwKcGFn ZXNfcmVtb3ZlZCA9IDAsIGxwZGVhZF9pdGVtX3BhZ2VzID0gOSwgDQogIG5vbmVtcHR5X3BhZ2Vz ID0gMTEsIG5ld19yZWxfdHVwbGVzID0gMCwgbmV3X2xpdmVfdHVwbGVzID0gMCwgaW5kc3RhdHMg PQoweDYyNTAwMDA0NDRkOCwgbnVtX2luZGV4X3NjYW5zID0gMCwgDQogIHR1cGxlc19kZWxldGVk ID0gOSwgbHBkZWFkX2l0ZW1zID0gMjI2LCBuZXdfZGVhZF90dXBsZXMgPSAwLCBudW1fdHVwbGVz ID0KMjM3LCBsaXZlX3R1cGxlcyA9IDIzN30NCg0KSSd2ZSBhbHNvIGNhdWdodCB0aGUgc2ltaWxh ciBoYW5nIG9uIChhdXRvKXZhY3V1bWluZyBwZ19hdHRyZGVmLApwZ19zaGRlcGVuZCwgcGdfY2xh c3MuDQoNCkl0IHNlZW1zIHRoYXQgdGhpcyBldGVybmFsIHJldHJ5IGlzIGNhdXNlZCBieSB0aGUg SEVBUFRVUExFX1JFQ0VOVExZX0RFQUQKc3RhdGUgb2YgYSB0dXBsZSBwcm9jZXNzZWQgaW4gdGhl IGxhenlfc2Nhbl9wcnVuZSBsb29wLgoK --===============3323833953440008605==--