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 1qdmy5-004kDI-Kl for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2023 07:28:53 +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 1qdmy3-007l2i-SF for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Sep 2023 07:28:51 +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 1qdcaq-004TCQ-TX for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 20:24:12 +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 1qdcal-003GIL-PG for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 20:24:12 +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=lT90uZyql9tgTSrGw78TlPdrQpWR5cXrDVrEMJIhjw4=; b=IS0Vjr/tzVJ1hJyiSvSNle6eAp iEMC/TQ0EhuBpGlsM4JabiaPtxXQfwZyOsZq/SxdWcAGJHc4VNn8bSnFmQm/wK5lzktWUKVVNa4jR f4aez8fr6ENJRdyCSiFBQPZ4J0QJ41AbwK48zJjjTfr+VCCysQzdloxa/duk0Zpp+vuiZjJyqn/Vn XXUtHGeC9onDhNbCKotibftERwJ4Dr7WwKe5yaM+44HJHIVEWcCEnX9/EWCUnV1AGj1Y+nPVOhTHA d08r4QbMNLYkjZNhYi/piPvNkrj45fBYu6JFONsqzKpp/iRyVGvCSgV/1YvDB9Y5F8VZBVIWNGkNI 3Br7Y6Kg==; 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 1qdcak-0000Vd-D6 for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 20:24:06 +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 1qdcag-009bbX-Me for pgsql-bugs@lists.postgresql.org; Tue, 05 Sep 2023 20:24:02 +0000 Content-Type: multipart/mixed; boundary="===============2307717136335859704==" MIME-Version: 1.0 Subject: BUG #18090: Encountering Toast Table Corruption and Missing Chunk Number Error During PostgreSQL Data Migration 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 20:23:45 +0000 Message-ID: <18090-d1a37c5c2a17d2bf@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 --===============2307717136335859704== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA5MApMb2dnZWQgYnk6ICAgICAgICAgIFJvb3QgQ2F1c2UKRW1haWwg YWRkcmVzczogICAgICByb290Y2F1c2UwMDBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog VW5zdXBwb3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIE1pY3Jvc29mdCBXaW5kb3dz IFNlcnZlciAyMDE5IFN0YW5kYXJkCkRlc2NyaXB0aW9uOiAgICAgICAgCgpWZXJzaW9uIC0gUG9z dGdyZVNRTCAxMC4yMSwgY29tcGlsZWQgYnkgVmlzdWFsIEMrKyBidWlsZCAxODAwLCA2NC1iaXQN Cg0KUGxhdGZvcm0gLSBXaW5kb3dzDQoNCldoZW4gbWlncmF0aW5nIGRhdGEgZnJvbSBQb3N0Z3Jl U1FMIDEwLjIxIHRvIDE0LjcsIHdlIGVuY291bnRlcmVkIGFuIGlzc3VlCmR1cmluZyB0aGUgZHVt cCBwcm9jZXNzIHJlbGF0ZWQgdG8gdGFibGUgY29ycnVwdGlvbiwgcmVzdWx0aW5nIGluIHRoZSBl cnJvcgptZXNzYWdlICdjb3VsZCBub3Qgb3BlbiBmaWxlICJiYXNlLzE2NTEwLzM3ODU3IjogTm8g c3VjaCBmaWxlIG9yCmRpcmVjdG9yeS4nDQoNCkVSUk9SOiBjb3VsZCBub3Qgb3BlbiBmaWxlICJi YXNlLzE2NTEwLzM3ODU3IjogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeQ0KDQpVcG9uIGNoZWNr aW5nIHRoZSAncmVsa2luZCcgZm9yICdyZWxmaWxlbm9kZScsIGl0IHdhcyBkZXRlcm1pbmVkIHRo YXQgdGhlCnR5cGUgaXMgdG9hc3QgdGFibGUuIEluIGFuIGF0dGVtcHQgdG8gcmVjb3ZlciB0aGUg ZGF0YSwgd2UgaW5pdGlhbGx5IHRyaWVkCnRydW5jYXRpbmcgdGhlIHRvYXN0IHRhYmxlLCBidXQg ZW5jb3VudGVyZWQgYW4gZXJyb3IgcHJldmVudGluZyBzdWNjZXNzZnVsCnRydW5jYXRpb24uIEFz IGEgd29ya2Fyb3VuZCwgd2UgY3JlYXRlZCBhIG5ldyBlbXB0eSBmaWxlIG5hbWVkICIzNzg1NyIg dW5kZXIKdGhlIGRpcmVjdG9yeSAiYmFzZS8xNjUxMC4iIEhvd2V2ZXIsIHRoaXMgbGVkIHRvIGEg bmV3IGVycm9yOiAnbWlzc2luZyBjaHVuawpudW1iZXIgMCBmb3IgdG9hc3QgdmFsdWUgMTU5Nzc2 NjIgaW4gcGdfdG9hc3RfMzc3MjIuJw0KDQpFUlJPUjogbWlzc2luZyBjaHVuayBudW1iZXIgMCBm b3IgdG9hc3QgdmFsdWUgMTU5Nzc2NjIgaW4gcGdfdG9hc3RfMzc3MjINCg0KUHJvZERCPSMgc2Vs ZWN0IGNvdW50KCopIGZyb20gcHJyaHRhYjsNCiBjb3VudA0KLS0tLS0tLS0NCiAyMzI5NjYNCigx IHJvdykNCg0KUHJvZERCPSMgc2VsZWN0ICogZnJvbSBwcnJodGFiOw0KRVJST1I6ICBjb3VsZCBu b3Qgb3BlbiBmaWxlICJiYXNlLzE2NTEwLzM3ODU3IjogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9y eQ0KUHJvZERCPSMgc2VsZWN0IHJlbG5hbWUsIHJlbGtpbmQgZnJvbSBwZ19jbGFzcyB3aGVyZSBy ZWxmaWxlbm9kZT0zNzg1NzsNCiAgICByZWxuYW1lICAgICB8IHJlbGtpbmQNCi0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tDQogcGdfdG9hc3RfMzc3MjIgfCB0DQooMSByb3cpDQoNClByb2REQj0j IHNlbGVjdCAqIGZyb20gcGdfdG9hc3QucGdfdG9hc3RfMzc3MjI7DQpFUlJPUjogIGNvdWxkIG5v dCBvcGVuIGZpbGUgImJhc2UvMTY1MTAvMzc4NTciOiBObyBzdWNoIGZpbGUgb3IgZGlyZWN0b3J5 DQpQcm9kREI9IyBzZWxlY3QgY291bnQoKikgZnJvbSBwZ190b2FzdC5wZ190b2FzdF8zNzcyMjsN CkVSUk9SOiAgY291bGQgbm90IG9wZW4gZmlsZSAiYmFzZS8xNjUxMC8zNzg1NyI6IE5vIHN1Y2gg ZmlsZSBvciBkaXJlY3RvcnkNCg0KUHJvZERCPSMgdHJ1bmNhdGUgdGFibGUgcGdfdG9hc3QucGdf dG9hc3RfMzc3MjI7DQpFUlJPUjogICJwZ190b2FzdF8zNzcyMiIgaXMgbm90IGEgdGFibGUNCg0K UHJvZERCPSMgc2VsZWN0IGNvdW50KCopIGZyb20gcGdfdG9hc3QucGdfdG9hc3RfMzc3MjI7DQog Y291bnQNCi0tLS0tLS0NCiAgICAgMA0KKDEgcm93KQ0KDQpQcm9kREI9IyBzZWxlY3QgKiBmcm9t IHBycmh0YWI7DQpFUlJPUjogIGNvdWxkIG5vdCByZWFkIGJsb2NrIDI2MzUgaW4gZmlsZSAiYmFz ZS8xNjUxMC8zNzg1NyI6IHJlYWQgb25seSAwIG9mCjgxOTIgYnl0ZXMNClByb2REQj0jIHJlaW5k ZXggdGFibGUgcHJyaHRhYjsNClJFSU5ERVgNClByb2REQj0jIHNlbGVjdCAqIGZyb20gcHJyaHRh YjsNCkVSUk9SOiAgbWlzc2luZyBjaHVuayBudW1iZXIgMCBmb3IgdG9hc3QgdmFsdWUgMTU5Nzc2 NjIgaW4gcGdfdG9hc3RfMzc3MjINCg0KUHJvZERCPSMgc2VsZWN0IGNvdW50KCopIGZyb20gcHJy aHRhYjsNCiBjb3VudA0KLS0tLS0tLS0NCiAyMzI5NjYNCigxIHJvdykNCg0KDQpQcm9kREI9IyBz ZWxlY3QgKiBmcm9tIHBycmh0YWIgb3JkZXIgYnkgaWQgZGVzYyBsaW1pdCAxOw0KICAgIGlkICAg DQotLS0tLS0tLS0NCiAxMTc3MDI3IA0KKDEgcm93KQ0KVG8gcmVzb2x2ZSB0aGlzIGlzc3VlLCB3 ZSBwcm9jZWVkZWQgdG8gcmVtb3ZlIHRoZSBjb3JydXB0ZWQgcm93cyBvbmUgYnkgb25lLAphbmQg YXMgYSByZXN1bHQsIHRoZSAnbWlzc2luZyBjaHVuayBudW1iZXInIGVycm9yIG5vIGxvbmdlciBv Y2N1cnJlZC4NCg0KVW5mb3J0dW5hdGVseSwgd2UgZG8gbm90IGhhdmUgYSBiYWNrdXAgZnJvbSBi ZWZvcmUgdGhlIHRhYmxlIGNvcnJ1cHRpb24Kb2NjdXJyZWQuIFdoaWxlIHdlIHdlcmUgYWJsZSB0 byBwcm9jZWVkIHdpdGggdGhlIG1pZ3JhdGlvbiB1c2luZyB0aGUKYWZvcmVtZW50aW9uZWQgYXBw cm9hY2gsIHdlIHdlcmUgdW5jZXJ0YWluIGlmIHRoZXJlIG1pZ2h0IGJlIGFuIGFsdGVybmF0aXZl Cm1ldGhvZCB0byByZXNvbHZlIHRoaXMgaXNzdWUgd2l0aG91dCBhbnkgZGF0YSBsb3NzLiBGdXJ0 aGVybW9yZSwgdGhlIHByb2Nlc3MKb2YgY2hlY2tpbmcgcm93cyBvbmUgYnkgb25lIHRvIHJlc29s dmUgdGhlICdtaXNzaW5nIGNodW5rIG51bWJlcicgZXJyb3IgZG9lcwpub3QgYXBwZWFyIHRvIGJl IGVmZmljaWVudC4gVGhlcmVmb3JlLCB3ZSB3b3VsZCBhcHByZWNpYXRlIGFueSBzdWdnZXN0aW9u cwpmb3IgYW4gb3B0aW1hbCBzb2x1dGlvbiBhbmQgd2hhdCBjb3VsZCBoYXZlIGJlZW4gdGhlIGNh dXNlIHNvIHRoYXQgc2ltaWxhcgppc3N1ZXMgY2FuIGJlIGF2b2lkZWQgaW4gZnV0dXJlLgoK --===============2307717136335859704==--