Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruXYw-0061M2-3k for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Apr 2024 13:00:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ruXYv-002OJN-Bi for pgsql-bugs@arkaria.postgresql.org; Wed, 10 Apr 2024 13:00:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruVgW-0011WM-Ki for pgsql-bugs@lists.postgresql.org; Wed, 10 Apr 2024 11:00:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruVgU-002AWX-3Q for pgsql-bugs@lists.postgresql.org; Wed, 10 Apr 2024 11:00: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=xG/cb0RtZgyGi1RC6f2HYwsRh+xe8u269LCSDN580xg=; b=HYzU3Dm080VxM6FAJO5Bw12h0c LttoXYLijq6IMsZDTq/udrBtXS1rrlGE0y3WxiS7kHAUKTSNacU93X4pmffK6pflrN86PMH8drf4T 3th3QJ0oMdAxYDCgFXp4DW3EPLAZmW0m06wdy3QAbLsrt6k3ME+4NV0CgMowhzPL3XTPfdHUEogkx 5IxJsVazdesdvttCj7+/PpiH8rBjv/vInRZ8yMWPUwYQ9vWqaHXvSHwTZgmRCK/CQ01xwjEdsR44F 1NjhF49/c/5XIzdlLleA4Bbh/OnHVa2CS+EDvunKegxci4l+RiVIiipmVsVshZ2Fcy4RBB612Lo+y VEWIP+fA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruVgT-004Wlo-5b for pgsql-bugs@lists.postgresql.org; Wed, 10 Apr 2024 11:00: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 1ruVgR-00GQh9-6d for pgsql-bugs@lists.postgresql.org; Wed, 10 Apr 2024 11:00:03 +0000 Content-Type: multipart/mixed; boundary="===============8327660174071831856==" MIME-Version: 1.0 Subject: BUG #18426: Canceling vacuum while truncating a relation leads to standby PANIC 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: Wed, 10 Apr 2024 11:00:00 +0000 Message-ID: <18426-2d18da6586f152d6@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 --===============8327660174071831856== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODQyNgpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBMYWtoaW4K RW1haWwgYWRkcmVzczogICAgICBleGNsdXNpb25AZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTYuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAg ICAgIAoKV2hlbiBydW5uaW5nIHRlc3QgMDI3X3N0cmVhbV9yZWdyZXNzIG9uIGEgcmF0aGVyIHNs b3cgQVJNdjcgZGV2aWNlLCBJDQpjYW1lIHVwb24gdGhlIGZvbGxvd2luZyB0ZXN0IGZhaWx1cmU6 DQoNClsyMTozMTozMC43ODldKDQ4OS45NjJzKSAjIHBvbGxfcXVlcnlfdW50aWwgdGltZWQgb3V0 IGV4ZWN1dGluZyB0aGlzCnF1ZXJ5Og0KIyBTRUxFQ1QgJzAvMTY5NTJERTAnIDw9IHJlcGxheV9s c24gQU5EIHN0YXRlID0gJ3N0cmVhbWluZycNCiMgICAgICAgICAgRlJPTSBwZ19jYXRhbG9nLnBn X3N0YXRfcmVwbGljYXRpb24NCiMgICAgICAgICAgV0hFUkUgYXBwbGljYXRpb25fbmFtZSBJTiAo J3N0YW5kYnlfMScsICd3YWxyZWNlaXZlcicpDQojIGV4cGVjdGluZyB0aGlzIG91dHB1dDoNCiMg dA0KIyBsYXN0IGFjdHVhbCBxdWVyeSBvdXRwdXQ6DQojIA0KIyB3aXRoIHN0ZGVycjoNCnRpbWVk IG91dCB3YWl0aW5nIGZvciBjYXRjaHVwIGF0IHQvMDI3X3N0cmVhbV9yZWdyZXNzLnBsIGxpbmUg MTAwLg0KDQpsb2cvMDI3X3N0cmVhbV9yZWdyZXNzX3N0YW5kYnlfMS5sb2cgZW5kcyB3aXRoOg0K Li4uDQoyMDI0LTA0LTA0IDIxOjA0OjAxLjk0NiBVVEMgWzE3OTAzXSBMT0c6ICByZWNvdmVyeSBy ZXN0YXJ0IHBvaW50IGF0CjAvMTFDNzE0MzANCjIwMjQtMDQtMDQgMjE6MDQ6MDEuOTQ2IFVUQyBb MTc5MDNdIERFVEFJTDogIExhc3QgY29tcGxldGVkIHRyYW5zYWN0aW9uIHdhcwphdCBsb2cgdGlt ZSAyMDI0LTA0LTA0IDIxOjAyOjE5LjQ1NjQ3MSswMy4NCjIwMjQtMDQtMDQgMjE6MDY6MTYuMDE0 IFVUQyBbMTc5MDVdIFdBUk5JTkc6ICBwYWdlIDcgb2YgcmVsYXRpb24KYmFzZS8xNjM4NC8yNjA2 IGRvZXMgbm90IGV4aXN0DQoyMDI0LTA0LTA0IDIxOjA2OjE2LjAxNCBVVEMgWzE3OTA1XSBDT05U RVhUOiAgV0FMIHJlZG8gYXQgMC8xMzg0MURFOCBmb3IKSGVhcDIvUFJVTkU6IHNuYXBzaG90Q29u ZmxpY3RIb3Jpem9uOiAxMzA1MCwgbnJlZGlyZWN0ZWQ6IDAsIG5kZWFkOiAxNCwKbnVudXNlZDog MSwgcmVkaXJlY3RlZDogW10sIGRlYWQ6IFsxLCAyLCAzLCA0LCA1LCA2LCAyOCwgMzEsIDMyLCAz MywgMzQsIDM1LAozNiwgMzddLCB1bnVzZWQ6IFs3XTsgYmxrcmVmICMwOiByZWwgMTY2My8xNjM4 NC8yNjA2LCBibGsgNw0KMjAyNC0wNC0wNCAyMTowNjoxNi4wMTQgVVRDIFsxNzkwNV0gUEFOSUM6 ICBXQUwgY29udGFpbnMgcmVmZXJlbmNlcyB0bwppbnZhbGlkIHBhZ2VzDQoyMDI0LTA0LTA0IDIx OjA2OjE2LjAxNCBVVEMgWzE3OTA1XSBDT05URVhUOiAgV0FMIHJlZG8gYXQgMC8xMzg0MURFOCBm b3IKSGVhcDIvUFJVTkU6IHNuYXBzaG90Q29uZmxpY3RIb3Jpem9uOiAxMzA1MCwgbnJlZGlyZWN0 ZWQ6IDAsIG5kZWFkOiAxNCwKbnVudXNlZDogMSwgcmVkaXJlY3RlZDogW10sIGRlYWQ6IFsxLCAy LCAzLCA0LCA1LCA2LCAyOCwgMzEsIDMyLCAzMywgMzQsIDM1LAozNiwgMzddLCB1bnVzZWQ6IFs3 XTsgYmxrcmVmICMwOiByZWwgMTY2My8xNjM4NC8yNjA2LCBibGsgNw0KMjAyNC0wNC0wNCAyMTow NjoxNi45MjcgVVRDIFsxNzg4OF0gTE9HOiAgc3RhcnR1cCBwcm9jZXNzIChQSUQgMTc5MDUpIHdh cwp0ZXJtaW5hdGVkIGJ5IHNpZ25hbCA2OiBBYm9ydGVkDQoNCnRfMDI3X3N0cmVhbV9yZWdyZXNz X3N0YW5kYnlfMV9kYXRhL3BnZGF0YS9wZ193YWwvMDAwMDAwMDEwMDAwMDAwMDAwMDAwMDEzCmNv bnRhaW5zOg0KLi4uDQpybWdyOiBYTE9HICAgICAgICBsZW4gKHJlYy90b3QpOiAgICAgNDkvICA4 MjQxLCB0eDogICAgICAxMzEwMywgbHNuOgowLzEzN0MzNTM4LCBwcmV2IDAvMTM3QzE0RTgsIGRl c2M6IEZQSSAsIGJsa3JlZiAjMDogcmVsIDE2NjMvMTYzODQvMjYwNiBmb3JrCnZtIGJsayAwIEZQ Vw0Kcm1ncjogU3RvcmFnZSAgICAgbGVuIChyZWMvdG90KTogICAgIDQ2LyAgICA0NiwgdHg6ICAg ICAgMTMxMDMsIGxzbjoKMC8xMzdDNTU4OCwgcHJldiAwLzEzN0MzNTM4LCBkZXNjOiBUUlVOQ0FU RSBiYXNlLzE2Mzg0LzI2MDYgdG8gNyBibG9ja3MKZmxhZ3MgNw0KLi4uDQpybWdyOiBUcmFuc2Fj dGlvbiBsZW4gKHJlYy90b3QpOiAgICAgMzgvICAgIDM4LCB0eDogICAgICAxMzEwMywgbHNuOgow LzEzN0M3NTg4LCBwcmV2IDAvMTM3Qzc1NDAsIGRlc2M6IEFCT1JUIDIwMjQtMDQtMDQgMjE6MDU6 MzEuMTc2ODY5IFVUQw0KIyMjIFRoYXQgaXMsIHRoZSByZWxhdGlvbiAyNjA2IChwZ19jb25zdHJh aW50KSB3YXMgdHJ1bmNhdGVkIGluDQojIyMgdHJhbnNhY3Rpb24gMTMxMDMsIGFuZCB0aGVuIHRo ZSB0cmFuc2FjdGlvbiB3YXMgYWJvcnRlZC4NCi4uLg0Kcm1ncjogSGVhcDIgICAgICAgbGVuIChy ZWMvdG90KTogICAgIDg1LyAgICA4NSwgdHg6ICAgICAgICAgIDAsIGxzbjoKMC8xMzg0MURFOCwg cHJldiAwLzEzODQxREE4LCBkZXNjOiBQUlVORSBzbmFwc2hvdENvbmZsaWN0SG9yaXpvbjogMTMw NTAsCm5yZWRpcmVjdGVkOiAwLCBuZGVhZDogMTQsIG51bnVzZWQ6IDEsIHJlZGlyZWN0ZWQ6IFtd LCBkZWFkOiBbMSwgMiwgMywgNCwgNSwKNiwgMjgsIDMxLCAzMiwgMzMsIDM0LCAzNSwgMzYsIDM3 XSwgdW51c2VkOiBbN10sIGJsa3JlZiAjMDogcmVsCjE2NjMvMTYzODQvMjYwNiBibGsgNw0KIyMj IFRoZSByZWNvcmQgdGhhdCBzdGFuZGJ5IGNvdWxkIG5vdCByZXBsYXkgYmVjYXVzZSBpdCBkaWQg dHJ1bmNhdGUNCiMjIyBwZ19jb25zdHJhaW50IHdoZW4gcmVwbGF5aW5nIDAvMTM3QzU1ODguDQoN CjAyN19zdHJlYW1fcmVncmVzc19wcmltYXJ5LmxvZyAgY29udGFpbnM6DQoyMDI0LTA0LTA0IDIx OjA1OjMxLjE3NiBVVEMgWzI5MzI5XSBFUlJPUjogIGNhbmNlbGluZyBhdXRvdmFjdXVtIHRhc2sN CjIwMjQtMDQtMDQgMjE6MDU6MzEuMTc2IFVUQyBbMjkzMjldIENPTlRFWFQ6ICB3aGlsZSB0cnVu Y2F0aW5nIHJlbGF0aW9uCiJwZ19jYXRhbG9nLnBnX2NvbnN0cmFpbnQiIHRvIDcgYmxvY2tzDQog ICAgICAgIGF1dG9tYXRpYyB2YWN1dW0gb2YgdGFibGUgInJlZ3Jlc3Npb24ucGdfY2F0YWxvZy5w Z19jb25zdHJhaW50Ig0KDQpBcyBmYXIgYXMgSSBjYW4gc2VlLCB0aGUgVFJVTkNBVEUgcmVjb3Jk IHdhcyBXQUwtbG9nZ2VkIGJ5IHRoZSBhdXRvdmFjdXVtDQpwcm9jZXNzIGluIHRhYmxlX3JlbGF0 aW9uX3ZhY3V1bSgpIC0+IGhlYXBfdmFjdXVtX3JlbCgpIC0+DQpsYXp5X3RydW5jYXRlX2hlYXAo KSAtPiBSZWxhdGlvblRydW5jYXRlKCksIGFuZCB0aGVuIHRoYXQgcHJvY2VzcyB3YXMNCmludGVy cnVwdGVkIGluc2lkZSBSZWxhdGlvblRydW5jYXRlKCkgLT4gc21ncnRydW5jYXRlKCkgLT4NCkRy b3BSZWxhdGlvbkJ1ZmZlcnMoKSAtPiBJbnZhbGlkYXRlQnVmZmVyKCkgLT4gV2FpdElPKCkuDQoN CkEgZGVtbyB0ZXN0IGZvciB0aGUgaXNzdWUgdG8gZm9sbG93Li4uCgo= --===============8327660174071831856==--