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 1qdWdC-003kca-SR for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Sep 2023 14:02:14 +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 1qdWdB-002Q12-H7 for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Sep 2023 14:02:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdW0Q-002Ffc-H4 for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:22:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qdW0M-003CHv-Lv for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:22: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=66DQtu7BvNMoXf+KNF5FTA0uwxihQ0KeKa1lYaxihM8=; b=ylDCE1K0CqR9nLSqhzs3R7/9NB 4Jxsd86p9yljBHiPt2GYdRazGIPN7AtiOMtUeiMpCY1Pl3aCxnDJfM1/41t6O0pSLP54P1opjAzLn YpG/ojYJ6RK2SoOqZQmOj8ScMbh/m7nCLdAuIVBxz30d0431QuyyR3ywoSaha2KpCsw11udFePbPC cEMnNk8fXIRGvwZeA7dQmih158FsTOj+fHZ1x0zgxpuwwj03dFJvLvvYDj60LSDFrRVvt8kfHsWa9 k589JbQxAkASrIBfawxHvIJ0b1MvP2/VTkodkBl5FMFGBwzsb0FuWxv0vnl9O8UtOciBAlNw7k00K n8+8V9vg==; 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 1qdW0L-0006zo-BQ for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:22: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 1qdW0I-009Qdn-Mj for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 13:22:02 +0000 Content-Type: multipart/mixed; boundary="===============4679763342800369592==" MIME-Version: 1.0 Subject: BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rootcause000@gmail.com Reply-To: rootcause000@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 05 Sep 2023 13:21:36 +0000 Message-ID: <18088-c0b663f3c5efb6e3@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 --===============4679763342800369592== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA4OApMb2dnZWQgYnk6ICAgICAgICAgIFJvb3QgQ2F1c2UKRW1haWwg YWRkcmVzczogICAgICByb290Y2F1c2UwMDBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog VW5zdXBwb3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIE1pY3Jvc29mdCBXaW5kb3dz IFNlcnZlciAyMDE5IFN0YW5kYXJkCkRlc2NyaXB0aW9uOiAgICAgICAgCgpEdXJpbmcgdGhlIFBv c3RncmVTUUwgbWlncmF0aW9uIGZyb20gdmVyc2lvbiAxMC4yMSB0byAxNC43LCB3ZSBlbmNvdW50 ZXJlZAphbiBpc3N1ZSBjYXVzZWQgYnkgY29ycnVwdGlvbiBpbiBhIHNwZWNpZmljIHRhYmxlLiBV cG9uIGNoZWNraW5nIHRoZSBsb2dzLAp3ZSBub3RpY2VkIG51bWVyb3VzIGluc3RhbmNlcyBvZiB0 aGUgc2VydmVyIGFicnVwdGx5IHNodXR0aW5nIGRvd24uIEFmdGVyCmVhY2ggc2VydmVyIHJlc3Rh cnQsIHdoZW4gYXR0ZW1wdGluZyB0byBhY2Nlc3MgdGhlIHRhYmxlLCB3ZSBlbmNvdW50ZXJlZCB0 aGUKZm9sbG93aW5nIGV4Y2VwdGlvbnM6DQoNCiJ1bnJlY29nbml6ZWQgd2luMzIgZXJyb3IgY29k ZTogMTM5Mg0KY291bGQgbm90IHJlYWQgYmxvY2sgMjM5NSBpbiBmaWxlICIiYmFzZS8xNjUwOS8z ODE4NDI0IiI6IEludmFsaWQKYXJndW1lbnQiDQoNCk9uIGNoZWNraW5nIHRoZSAncmVsa2luZCcg Zm9yICdyZWxmaWxlbm9kZSwnIHRoZSB0eXBlIGFwcGVhcmVkIHRvIGJlIGFuCm9yZGluYXJ5IHRh YmxlLiBXZSB3ZXJlIGFibGUgdG8gcmVnYWluIGFjY2VzcyB0byB0aGUgdGFibGUgYnkgdHJ1bmNh dGluZwppdC4NCg0KUHJvZERCPT4gc2VsZWN0IGNvdW50KCopIGZyb20gcHJyaHRhYjsNCkVSUk9S OiAgY291bGQgbm90IHJlYWQgYmxvY2sgMjM5NCBpbiBmaWxlICJiYXNlLzE2NTA5LzM4MTg0MjQi OiByZWFkIG9ubHkgMApvZiA4MTkyIGJ5dGVzDQpQcm9kREI9PiBTRUxFQ1QgcmVsbmFtZSwgcmVs a2luZCBGUk9NIHBnX0NsYXNzIFdIRVJFIHJlbGZpbGVub2RlPTM4MTg0MjQ7DQogICAgICAgIHJl bG5hbWUgICAgICAgIHwgcmVsa2luZA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t DQogcHJyaHRhYiB8IHINCigxIHJvdykNCg0KDQpQcm9kREI9PiB0cnVuY2F0ZSB0YWJsZSBwcnJo dGFiOw0KVFJVTkNBVEUgVEFCTEUNClByb2REQj0+IHNlbGVjdCBjb3VudCgqKSBmcm9tIHBycmh0 YWI7DQogY291bnQNCi0tLS0tLS0NCiAgICAgMA0KKDEgcm93KQ0KDQoNClByb2REQj0+DQoNCkhv d2V2ZXIsIHNpbmNlIHRoZXJlIGlzIG5vIGF2YWlsYWJsZSBiYWNrdXAsIHdlIGFyZSB1bmNlcnRh aW4gYWJvdXQgdGhlCnByZXNlbmNlIG9mIGFueSBkYXRhIGFuZCB3aGV0aGVyIGFueSBvdGhlciBy ZWNvdmVyeSBvcHRpb25zIGFyZSBwb3NzaWJsZS4NCg0KUGxlYXNlIGFkdmlzZSBpZiB0aGVyZSBh cmUgYWx0ZXJuYXRpdmUgbWV0aG9kcyB0byByZWNvdmVyIHRoZSBkYXRhIGFuZCBpZgp0aGVyZSBh cmUgb3B0aW9ucyB0byBwcmV2ZW50IHRoaXMgaXNzdWUgZnJvbSBvY2N1cnJpbmcgZXZlbiBpbiB0 aGUgZXZlbnQgb2YKYW4gYWJydXB0IHNlcnZlciBzaHV0ZG93bi4KCg== --===============4679763342800369592==--