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 1qLIlT-002miB-Tl for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Jul 2023 07:35:28 +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 1qLIlR-006FhF-OP for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Jul 2023 07:35:25 +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 1qLGP2-004mRw-F2 for pgsql-bugs@lists.postgresql.org; Mon, 17 Jul 2023 05:04:08 +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 1qLGP0-000zq5-9o for pgsql-bugs@lists.postgresql.org; Mon, 17 Jul 2023 05:04: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=ZgckyuW6u5Z8AgzLvC0RrjUlkB9sJlb9/4Gf5TUwL9o=; b=dkwQ2E5RHT8hDUTIrvsmbpsBgu ++If6RVoLiI+vNtEyJrSvaN/8Ba5jBDSIOVTPKwA/RmeaDnUdQp4a9ETQmMqm2kR8ENFlVbc8k+8m NGWzhLlIl8TAW3FB1c8p0BWgpBmukw+C5KAApBegZ/ylnHIqMjJjHe1sekPYSU7HqC0wtTYE1lDZU Y4wwgBPZM2Aa0eIHE1hcFU09rL1WCnU+ptkk5l/n6mx0yoTUfA+QYbZ9UFwkLpPa5D7y3n/Oz3Ca2 cX4vdblgAb7LQDSH+4vcWRjMe7ECGRyo9PHWyJFLAH0jRZz4OtHtYLeXnLFgZRqIWyrajPez/Wb/L QonMu3RA==; 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 1qLGOz-0004nc-0L for pgsql-bugs@lists.postgresql.org; Mon, 17 Jul 2023 05:04: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 1qLGOv-002Xjf-Og for pgsql-bugs@lists.postgresql.org; Mon, 17 Jul 2023 05:04:02 +0000 Content-Type: multipart/mixed; boundary="===============3997555862650141517==" MIME-Version: 1.0 Subject: BUG #18025: Probably we need to change behaviour of the checkpoint failures in PG To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hargudekishor@gmail.com Reply-To: hargudekishor@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 17 Jul 2023 05:03:17 +0000 Message-ID: <18025-85e7e63f3ff93d40@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 --===============3997555862650141517== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODAyNQpMb2dnZWQgYnk6ICAgICAgICAgIEtpc2hvciBIYXJndWRlCkVt YWlsIGFkZHJlc3M6ICAgICAgaGFyZ3VkZWtpc2hvckBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNC44Ck9wZXJhdGluZyBzeXN0ZW06ICAgcmhlbApEZXNjcmlwdGlvbjogICAgICAgIAoK SGVsbG8gLCANCg0KSSBoYXZlIGp1c3Qgd2l0bmVzc2VkIHRoZSBkYXRhIGxvc3Mgc2NlbmFyaW8u IA0KDQpTY2VuYXJpbyBpcyBsaWtlLCB0aGVyZSB3YXMgY2hlY2twb2ludCBvcGVyYXRpb24gZmFp bHVyZXMgZ29pbmcgb24gdGhlIERCCnNlcnZlciBzaW5jZSBsYXN0IDggaG91cnMgd2hpY2ggbWVh bnMgbm8gc3VjY2Vzc2Z1bCBjaGVja3BvaW50IGhhcHBlbmVkIGluCnRoZSBEQiBzZXJ2ZXIgc2lu Y2UgbGFzdCA4IGhvdXJzLiBUaGVuIERCIHNlcnZlciB3ZW50IGludG8gdGhlIGNyYXNoIG1vZGUK ZHVlIHRvIHRoZSBleGhhdXN0ZWQgZGlzayBzcGFjZSBhbmQgZGlkIG5vdCBjYW1lIHVwIGFzIHBh cnQgb2YgY3Jhc2gKcmVjb3ZlcnkuIEFjdHVhbGx5IHRoZSB2aWN0aW0gaGFkIG1vdmVkIGZldyBX QUxzIGZyb20gdGhlIHBnX3dhbCB0byBvdGhlcgpsb2NhdGlvbiBhbmQgcmVpbXBvcnRpbmcgdGhv c2Ugd2FsIG9uIG9yaWdpbmFsIGxvY2F0aW9uIGFsc28gZGlkIG5vdCBzb2x2ZWQKdGhlIHByb2Js ZW0uIERCIHNlcnZlciB3YXMgbm90IGFibGUgdG8gZmluZCBvdXQgdGhlIHZhbGlkIGNoZWNrcG9p bnQgcmVjb3JkLgpUaGUgdmljdGltIHdhcyBub3QgaGF2aW5nIHRoZSBiYWNrdXAgd2hpY2ggaGUg Y291bGQgdXNlIHRoYXQgYmFja3VwIHRvCnJlY292ZXIgdGhlIGRhdGEgd2l0aCB0aGUgaGVscCBv ZiBhdmFpbGFibGUgYXJjaGl2ZWQgV0FMcy4gU28gLCB0aGUgdmljdGltCmhhZCBvbmx5IG9uZSBv cHRpb24gbGVmdCBpbiBoaXMgaGFuZCB0aGF0IGlzIHBnX3Jlc2V0d2FsLiAgV2UgaGF2ZSB0cmll ZApldmVyeSBwb3NzaWJsZSBzb2x1dGlvbiBidXQgZGlkIG5vdCB3b3JrZWQgc28gd2UgZGlkIG5v dCBsZWZ0IHdpdGggbW9yZQpjaG9pY2VzIG90aGVyIHRoYW4gcGdfUmVzZXR3YWwNCg0KTm93LCBU aGUgdmljdGltIGhhcyB0byBvcHQgZm9yIHBnX3Jlc2V0d2FsIGJ1dCB0aGUgY29zdCBmb3IgdGhp cyBvcHRpb24gaXMgOApob3VycyBvZiBkYXRhIGxvc3MgYXMgbGFzdCBzdWNjZXNzZnVsIGNoZWNr cG9pbnQgd2FzIGhhcHBlbmVkIDggaG91cnMgYmFjay4KVGhlcmUgaXMgbm90IG90aGVyIG9wdGlv biBhdmFpbGFibGUgb3RoZXIgdGhhbiBwZ19yZXNldHdhbC4gDQoNCkFib3ZlIG1lbnRpb25lZCBz Y2VuYXJpbyBjYW4gb2NjdXJyZWQgd2l0aCBtYW55IG9mIHRoZSBQb3N0Z3JlU1FMIGN1c3RvbWVy cwphcyB0aGUgY3VzdG9tZXIgZG9lcyBub3QgYm90aGVyIGFib3V0IHRvIG1vbml0b3IgdGhlIERC IGxvZ3MgZm9yIGZpbmRpbmcgb3V0CnRoZSBlcnJvcnMvZmF0YWxzL1BBTklDcyBvbiBkYWlseSBi YXNpcyBvciBob3VybHkgYmFzaXMgKGZvciB0aGUgZXZlbnRzIGxpa2UKY2hlY2twb2ludCBmYWls dXJlcy8vYXJjaGl2aW5nIGZhaWx1cmVzKS4gRHVlIHRoZSBpZ25vcmFuY2Ugb2YgbW9uaXRvcmlu Zwp0aGUgREIgbG9ncyBvciBpbXByb3BlciBiYWNrdXAgcmVjb3Zlcnkgc3RyYXRlZ2llcyAsYW55 IGN1c3RvbWVyIGNhbiBtZWV0CndpdGggdGhlIGFib3ZlIG1lbnRpb25lZCBzY2VuYXJpbyB3aGlj aCBjb3N0cyB0byBkYXRhIGxvc3MuIA0KDQpJbiBteSBvcGluaW9uLCB0byBsaW1pdCB0aGUgZGF0 YSBsb3NzIG9yIGRhbWFnZSB0byB0aGUgZGF0YSBpbiBhYm92ZQpzY2VuYXJpbywgd2Ugc2hvdWxk IHRoaW5rIG9uIGNoYW5naW5nIHRoZSBiZWhhdmlvdXIgb2YgdGhlIGNoZWNrcG9pbnQKZmFpbHVy ZSBvcGVyYXRpb25zLiByaWdodCBub3cgLCB3ZSBhcmUganVzdCBlcnJvcmluZyBvdXQgdGhlIGNo ZWNrcG9pbnQKZmFpbHVyZXMgYW5kIGFsbG93aW5nIHdyaXRlIHRyYW5zY3Rpb25zIG9uIERCIHNl cnZlciB3aGljaCBrZXB0IGdlbmVyYXRpbmcKdGhlIFdBTHMuIE5vdyBhcyBjaGVja3BvaW50cyBh cmUgdW5hYmxlIHRvIHJlY3ljbGUgb3IgcmVtb3ZlIHRoZSB1bndhbnRlZApXQUxzIGZyb20gcGdf d2FsICwgdGhlIFdBTHMga2VlcHMgYWNjdW11bGF0aW5nIGFuZCBldmVudHVhbGx5IGxlYWRzIHRv IGRpc2sKZnVsbCBpc3N1ZSBhbmQgc2VydmVyIGdldHMgY3Jhc2hlZC5BbmQgdGhlbiBhYm92ZSBz Y2VuYXJpbyBtYXkgaGFwcGVucy4gDQoNCkkgYW0gc2hhcmluZyBteSB0aG91Z2h0IHRvIGxpbWl0 IHRoZSBkYXRhIGxvc3MgaW4gYWJvdmUgc2l0dWF0aW9uOg0KDQpJIGxlYXJuZWQgdGhhdCBmYWls dXJlIG9mIHRoZSBjaGVja3BvaW50IG9wZXJhdGlvbiBjYW4gbGVhZCB0byBkYXRhIGxvc3MgLgpU aGUgZGF0YWxvc3Mgb2Ygc2V2ZXJhbCBob3Vycy9kYXlzIGV0Yy4gDQoNCkN1c3RvbWVycyB3aWxs IG5vdCBhY2NlcHQgdGhlaXIgbWlzdGFrZXMgYnV0IGJsYW1lIG9uIFBvc3RncmVTUUwuDQoNCkkg dGhpbmsgd2UgY2FuIGltcHJvdmUgdGhlIGJlaGF2aW91ciBvZiB0aGUgUG9zdGdyZVNRTCB3aGVu IGl0IGNvbWVzIHRvCmNvbnN0YW50bHkgZmFpbHVyZXMgb2YgdGhlIGNoZWNrcG9pbnRzIG9wZXJh dGlvbi4gV2Ugc2hvdWxkIHN0b3AgYWNjZXB0aW5nCnRoZSB3cml0ZSB0cmFuc2FjdGlvbnMgYW5k IGFsbG93IG9ubHkgcmVhZCBvbmx5IHRyYW5zYWN0aW9ucyBhcyBzb29uIGFzCnBvc3RncmVzIGRl dGVjdHMgdGhlIGZhaWx1cmUgb2YgdGhlIGNoZWNrcG9pbnQgb3BlcmF0aW9uICh3aGljaCBjYW4g bm90IGJlCnJlc29sdmVkKSAuIFRoaXMgd2lsbCBnaXZlIG9wcG9ydHVuaXR5IGN1c3RvbWVyIHRv IGltcG9ydCB0aGUgZGF0YWJhc2VzIGZyb20KcHJvYmxlbWF0aWMgY2x1c3RlciBhbmQgYnVpbGQg bmV3IGNsdXN0ZXIuIEJ1dCB0aGlzIHdpbGwgZGVmaW5pdGVseSBsaW1pdAp0aGUgbG9zcyBvZiB0 aGUgZGF0YSBpZiBhbnkgY3VzdG9tZXIgc3VmZmVyIHRocm91Z2ggdGhlIHNjZW5hcmlvIG1lbnRp b25lZAphcyBhYm92ZS4gVGhpcyBhcHByb2FjaCBhbHNvIHdpbGwgZ2l2ZSBpbW1lZGlhdGUgYWxh cm0gdG8gdGhlIGN1c3RvbWVyIHRvCmZpeCB0aGUgaXNzdWUgaWYgaXRzIGZpeGFibGUgb3RoZXJ3 aXNlIGRvIHRoZSByZWNvdmVyeSBzdGVwcy4gSGF2aW5nCmRvd250aW1lIGlzIGFsd2F5cyBhbHdh eXMgYmV0dGVyIHRoYW4gbG9vc2luZyBkYXRhLiANCg0KVGhhbmsgWW91LgoK --===============3997555862650141517==--