Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihq1f-00046r-7z for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Dec 2019 07:15:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ihq1e-0001SU-0F for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Dec 2019 07:15:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ihq1d-0001SM-O5 for pgsql-bugs@lists.postgresql.org; Thu, 19 Dec 2019 07:15:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ihq1a-0001M3-OX for pgsql-bugs@lists.postgresql.org; Thu, 19 Dec 2019 07:15:09 +0000 Content-Type: multipart/mixed; boundary="===============8049099402944913650==" MIME-Version: 1.0 Subject: BUG #16172: failure of vacuum file truncation can cause permanent data corruption To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: harukat@sraoss.co.jp Reply-To: harukat@sraoss.co.jp, pgsql-bugs@lists.postgresql.org Date: Thu, 19 Dec 2019 07:14:42 +0000 Message-ID: <16172-8d7483d5119bad9d@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8049099402944913650== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE3MgpMb2dnZWQgYnk6ICAgICAgICAgIFRBS0FUU1VLQSBIYXJ1a2EK RW1haWwgYWRkcmVzczogICAgICBoYXJ1a2F0QHNyYW9zcy5jby5qcApQb3N0Z3JlU1FMIHZlcnNp b246IDEyLjEKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzL0xpbnV4CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIZWxsbywgcGdzcWwgaGFja2VycywNCg0KSSBmb3VuZCB0aGF0IGZhaWx1cmUgb2Yg dmFjdXVtIGZpbGUgdHJ1bmNhdGlvbiBjYW4gY2F1c2UgcGVybWFuZW50IGRhdGEKY29ycnVwdGlv bi4NCkkgYW0gcmVwb3J0aW5nIHRoZSByZXByb2R1Y2Ugc3RlcHMgYmVsb3cuDQoNCkluIFdpbmRv d3MgaW5zdGFsbGF0aW9uLCB0aGUgdHJ1bmNhdGlvbiBzb21ldGltZSBmYWlscyBieSBwZXJtaXNz aW9uDQpkZW5pZWQgZXJyb3IgYmVjYXVzZSBvZiBhbnRpLXZpcnVzIHNvZnR3YXJlLiBJdCBoYXMg Y2F1c2VkIGp1c3QgRVJST1INCmFuZCBwZW9wbGUgaGF2ZSBvZmZlbiBkaXNtaXNzZWQgaXQuDQoN ClRydW5jYXRpb24gZmFpbHVyZSBjYW4gYWxzbyBtYWtlIHRoZSBzdGFuZGJ5IHBhbmljIHdpdGgg dGhlIGZvbGxvd2luZw0KbWVzc2FnZXMgd2hlbiByZXBsYXlpbmcgSGVhcDIvVklTSUJMRSBvciBI ZWFwMi9DTEVBTiwgYmVjYXVzZSB0cnVuY2F0aW9uDQp3YWwgaXMgZW1pdHRlZCBldmVuIGlmIGl0 IGRvZXNuJ3QgY29tcGxldGUgYWN0dWFsbHkgaW4gdGhlIHByaW1hcnkuDQoNCiBXQVJOSU5HOiAg cGFnZSAuLiBvZiByZWxhdGlvbiBiYXNlLy4uLi4vLi4uLiBkb2VzIG5vdCBleGlzdA0KIENPTlRF WFQ6ICBXQUwgcmVkbyBhdCAuLi4uLiBmb3IgLi4uLjogY3V0b2ZmIHhpZCAuLi4gZmxhZ3MgLi4u DQogUEFOSUM6ICBXQUwgY29udGFpbnMgcmVmZXJlbmNlcyB0byBpbnZhbGlkIHBhZ2VzDQoNCkkg dGhpbmsgdHJ1bmNhdGlvbiBmYWlsdXJlIGlzIHRvIGJlIGhhbmRsZWQgYXMgbW9yZSBzZXZlcmUg bGV2ZWwuDQpBbnkgdGhvdWdodHM/DQoNCndpdGggYmVzdCByZWdhcmRzLA0KSGFydWthIFRha2F0 c3VrYSAvIFNSQSBPU1MsIEluYy4gSmFwYW4NCg0KDQpyZXByb2R1Y2Ugc3RlcHMgKFBHMTIpDQo9 PT09PT09PT09PT09PT09PT09PT09DQoNCiQgcHNxbCAtVSBwb3N0Z3JlcyAtZCBkYjENClBhZ2Vy IHVzYWdlIGlzIG9mZi4NCnBzcWwgKDEyLjEpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KZGIx PSMgDQoNCiAgJCBnZGIgLXAge2l0cyBiYWNrZW5kIHByb2Nlc3N9DQoNCiAgKGdkYikgYiBGaWxl VHJ1bmNhdGUNCiAgQnJlYWtwb2ludCAxIGF0IDB4NzNkMzIwOiBmaWxlIGZkLmMsIGxpbmUgMjA1 Ny4NCiAgKGdkYikgYw0KICBDb250aW51aW5nLg0KDQpkYjE9IyBTSE9XIGF1dG92YWN1dW07DQog YXV0b3ZhY3V1bQ0KLS0tLS0tLS0tLS0tDQogb2ZmDQooMSByb3cpDQoNCmRiMT0jIENSRUFURSBU QUJMRSB0MSAoaWQgaW50IHByaW1hcnkga2V5LCB2IHRleHQpOw0KQ1JFQVRFDQoNCmRiMT0jIElO U0VSVCBJTlRPIHQxIFNFTEVDVCBnLCBtZDUoZzo6dGV4dCkgRlJPTSBnZW5lcmF0ZV9zZXJpZXMo MSwgMTAwMDApCmFzIGc7DQpJTlNFUlQgMCAxMDAwMA0KDQpkYjE9IyBDSEVDS1BPSU5UOw0KDQog IFByb2dyYW0gcmVjZWl2ZWQgc2lnbmFsIFNJR1VTUjEsIFVzZXIgZGVmaW5lZCBzaWduYWwgMS4N CiAgMHgwMDAwMDAzNmNhYWU5MWEzIGluIF9fZXBvbGxfd2FpdF9ub2NhbmNlbCAoKSBmcm9tIC9s aWI2NC9saWJjLnNvLjYNCiAgKGdkYikgYw0KICBDb250aW51aW5nLg0KDQpDSEVDS1BPSU5UDQoN CmRiMT0jIERFTEVURSBGUk9NIHQxIFdIRVJFIGlkID4gNTA7DQpERUxFVEUgOTk1MA0KDQpkYjE9 IyBWQUNVVU0gdDE7DQoNCiAgQnJlYWtwb2ludCAxLCBGaWxlVHJ1bmNhdGUgKGZpbGU9NTksIG9m ZnNldD04MTkyLAp3YWl0X2V2ZW50X2luZm89MTY3NzcyMTc1KQ0KICAgICAgYXQgZmQuYzoyMDU3 DQogIDIwNTcgICAgew0KICAoZ2RiKSBuDQogIDIwNjUgICAgICAgICAgICByZXR1cm5Db2RlID0g RmlsZUFjY2VzcyhmaWxlKTsNCiAgKGdkYikgbg0KICAyMDY2ICAgICAgICAgICAgaWYgKHJldHVy bkNvZGUgPCAwKQ0KICAoZ2RiKSBwIHJldHVybkNvZGUgPSAtMTAwDQogICQ2ID0gLTEwMA0KICAo Z2RiKSBjDQogIENvbnRpbnVpbmcuDQoNCkVSUk9SOiAgY291bGQgbm90IHRydW5jYXRlIGZpbGUg ImJhc2UvMTYzODQvMTY2NDUiIHRvIDEgYmxvY2tzOiBTdWNjZXNzDQoNCmRiMT0jIFNFTEVDVCBj b3VudCgqKSBGUk9NIHQxOw0KIGNvdW50DQotLS0tLS0tDQogIDk5MzANCigxIHJvdykNCg0KZGIx PSMgU0VMRUNUICogRlJPTSB0MSBXSEVSRSBpZCA+IDUwIExJTUlUIDEwOw0KIGlkICB8ICAgICAg ICAgICAgICAgIHYNCi0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiAx MjEgfCA0YzU2ZmY0Y2U0YWFmOTU3M2FhNWRmZjkxM2RmOTk3YQ0KIDEyMiB8IGEwYTA4MGY0MmU2 ZjEzYjNhMmRmMTMzZjA3MzA5NWRkDQogMTIzIHwgMjAyY2I5NjJhYzU5MDc1Yjk2NGIwNzE1MmQy MzRiNzANCiAxMjQgfCBjOGZmZTlhNTg3YjEyNmYxNTJlZDNkODlhMTQ2YjQ0NQ0KIDEyNSB8IDNk ZWYxODRhZDhmNDc1NWZmMjY5ODYyZWE3NzM5M2RkDQogMTI2IHwgMDY5MDU5YjdlZjg0MGYwYzc0 YTgxNGVjOTIzN2I2ZWMNCiAxMjcgfCBlYzVkZWNjYTVlZDNkNmI4MDc5ZTJlN2U3YmFjYzlmMg0K IDEyOCB8IDc2ZGM2MTFkNmViYWFmYzY2Y2MwODc5YzcxYjVkYjVjDQogMTI5IHwgZDFmNDkxYTQw NGQ2ODU0ODgwOTQzZTVjM2NkOWNhMjUNCiAxMzAgfCA5Yjg2MTkyNTFhMTkwNTdjZmY3MDc3OTI3 M2U5NWFhNg0KKDEwIHJvd3MpDQoNCmRiMT0jIFZBQ1VVTSBGVUxMIEZSRUVaRSB0MTsNClZBQ1VV TQ0KDQpkYjE9IyBSRUlOREVYIFRBQkxFIHQxOw0KUkVJTkRFWA0KDQpkYjE9IyBTRUxFQ1QgY291 bnQoKikgRlJPTSB0MTsNCiBjb3VudA0KLS0tLS0tLQ0KICA5OTMwDQooMSByb3cpDQoNCmRiMT0j IFNFTEVDVCAqIEZST00gdDEgV0hFUkUgaWQgPiA1MCBMSU1JVCAxMDsNCiBpZCAgfCAgICAgICAg ICAgICAgICB2DQotLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogMTIx IHwgNGM1NmZmNGNlNGFhZjk1NzNhYTVkZmY5MTNkZjk5N2ENCiAxMjIgfCBhMGEwODBmNDJlNmYx M2IzYTJkZjEzM2YwNzMwOTVkZA0KIDEyMyB8IDIwMmNiOTYyYWM1OTA3NWI5NjRiMDcxNTJkMjM0 YjcwDQogMTI0IHwgYzhmZmU5YTU4N2IxMjZmMTUyZWQzZDg5YTE0NmI0NDUNCiAxMjUgfCAzZGVm MTg0YWQ4ZjQ3NTVmZjI2OTg2MmVhNzczOTNkZA0KIDEyNiB8IDA2OTA1OWI3ZWY4NDBmMGM3NGE4 MTRlYzkyMzdiNmVjDQogMTI3IHwgZWM1ZGVjY2E1ZWQzZDZiODA3OWUyZTdlN2JhY2M5ZjINCiAx MjggfCA3NmRjNjExZDZlYmFhZmM2NmNjMDg3OWM3MWI1ZGI1Yw0KIDEyOSB8IGQxZjQ5MWE0MDRk Njg1NDg4MDk0M2U1YzNjZDljYTI1DQogMTMwIHwgOWI4NjE5MjUxYTE5MDU3Y2ZmNzA3NzkyNzNl OTVhYTYNCigxMCByb3dzKQ0KDQoNCg0KcmVhbCBpbmNpZGVudCBsb2cgc2FtcGxlIChmcm9tIFdp bmRvd3MgUEcxMC54KQ0KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PQ0KDQpwcmltYXJ5IHNlcnZlcjoNCi0tLS0tLS0tLS0tLS0tLQ0KMjAxOS0xMi0xNyAxOTox MDoxOSBKU1QgWzE0MzIxXSBFUlJPUjogIDQyNTAxOiBjb3VsZCBub3QgdHJ1bmNhdGUgZmlsZQoi YmFzZS80NDQ4MDcvNDQ3NzkxIiB0byA3IGJsb2NrczogUGVybWlzc2lvbiBkZW5pZWQNCjIwMTkt MTItMTcgMTk6MTA6MTkgSlNUIFsxNDMyMV0gQ09OVEVYVDogIGF1dG9tYXRpYyB2YWN1dW0gb2Yg dGFibGUKImRkZC5zc3NzLnR0dHQiDQoNCmhvdCBzdGFuZGJ5IHNlcnZlcjoNCi0tLS0tLS0tLS0t LS0tLS0tLS0NCjIwMTktMTItMTcgMTk6MTE6MjAgSlNUIFsxMjM0NV0gV0FSTklORzogIDAxMDAw OiBwYWdlIDcgb2YgcmVsYXRpb24KYmFzZS80NDQ4MDcvNDQ3NzkxIGRvZXMgbm90IGV4aXN0DQoy MDE5LTEyLTE3IDE5OjExOjIwIEpTVCBbMTIzNDVdIENPTlRFWFQ6ICBXQUwgcmVkbyBhdCA0RS9G QzVBRDA2MCBmb3IKSGVhcDIvVklTSUJMRTogY3V0b2ZmIHhpZCAwIGZsYWdzIDMNCjIwMTktMTIt MTcgMTk6MTE6MjAgSlNUIFsxMjM0NV0gUEFOSUM6ICBYWDAwMDogV0FMIGNvbnRhaW5zIHJlZmVy ZW5jZXMgdG8KaW52YWxpZCBwYWdlcw0KMjAxOS0xMi0xNyAxOToxMToyMCBKU1QgWzEyMzQ1XSBD T05URVhUOiAgV0FMIHJlZG8gYXQgNEUvRkM1QUQwNjAgZm9yCkhlYXAyL1ZJU0lCTEU6IGN1dG9m ZiB4aWQgMCBmbGFncyAzCgo= --===============8049099402944913650==--