Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDS3z-0001cB-CZ for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Sep 2020 12:40:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kDS3y-0003j8-C7 for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Sep 2020 12:40:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kDQTv-0007qY-EG for pgsql-bugs@lists.postgresql.org; Wed, 02 Sep 2020 10:59:11 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kDQTn-00019R-Vp for pgsql-bugs@lists.postgresql.org; Wed, 02 Sep 2020 10:59:11 +0000 Content-Type: multipart/mixed; boundary="===============6165423545755584247==" MIME-Version: 1.0 Subject: BUG #16605: PostgreSQL recovery startup process waiting and blocking to application queries To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tushar11.takate@gmail.com Reply-To: tushar11.takate@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 02 Sep 2020 10:58:49 +0000 Message-ID: <16605-174a554a8e2f6385@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6165423545755584247== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYwNQpMb2dnZWQgYnk6ICAgICAgICAgIFR1c2hhciBUYWthdGUKRW1h aWwgYWRkcmVzczogICAgICB0dXNoYXIxMS50YWthdGVAZ21haWwuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTAuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIE9FTCA2LjkKRGVzY3JpcHRpb246ICAgICAg ICAKCkhpIFRlYW0gLA0KDQpQcm9ibGVtL2J1Zy9pc3N1ZXMgc3RhdGVtZW50IDogLSAgUG9zdGdy ZVNRTCByZWNvdmVyeSBzdGFydHVwIHByb2Nlc3MgaXMKYmxvY2tpbmcgdGhlIGFwcGxpY2F0aW9u IHF1ZXJpZXMgLg0KDQpFbnYgRGV0YWlscyAtIA0KDQpQb3N0Z3RyZVNRTCBjb21tdW5pdHkgdmVy c2lvbiAtIDEwLjUNCk9TIC0gT0VMIDYuOSANClJlcGxpY2F0aW9uIHR5cGUgLSBTdHJlYW1pbmcg LSBhc3luYyANCg0KREIgcGFyYW1ldGVycyBhdCByZXBsaWNhIHNpZGUgLSANCg0KbWF4X3N0YW5k Ynlfc3RyZWFtaW5nX2RlbGF5ID0gLTENCm1heF9zdGFuZGJ5X2FyY2hpdmVfZGVsYXkgPSAtMQ0K aG90X3N0YW5kYnlfZmVlZGJhY2sgPSBvZmYNCg0KU3RhcnR1cCBwcm9jZXNzIGJ5IHBzIC1lZiAg DQoNCnBvc3RncmVzICAgICAgICAgICAyNDQ4OSAyNDQ4NyAgMCAgMjAxOSA/ICAgICAgICAxLTIw OjIzOjM1IHBvc3RncmVzOgpzdGFydHVwIHByb2Nlc3MgICByZWNvdmVyaW5nIDAwMDAwMDA2MDAw MDIxRDQwMDAwMDBFRCB3YWl0aW5nDQoNClN0YXJ0dXAgcHJvY2VzcyBmcm9tIHBnX3N0YXRfYWN0 aXZpdHkgW0hlcmUgaXRzIG5vdCBzaG93aW5nIHByb2Nlc3MgaXMgaW4Kd2FpdGluZyBzdGF0ZSBd DQoNCnBvc3RncmVzPSMgc2VsZWN0ICogZnJvbSBwZ19zdGF0X2FjdGl2aXR5IHdoZXJlIHBpZD0n MjQ0ODknOw0KLVsgUkVDT1JEIDEgXS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t DQpkYXRpZCAgICAgICAgICAgIHwgDQpkYXRuYW1lICAgICAgICAgIHwgDQpwaWQgICAgICAgICAg ICAgIHwgMjQ0ODkNCnVzZXN5c2lkICAgICAgICAgfCANCnVzZW5hbWUgICAgICAgICAgfCANCmFw cGxpY2F0aW9uX25hbWUgfCANCmNsaWVudF9hZGRyICAgICAgfCANCmNsaWVudF9ob3N0bmFtZSAg fCANCmNsaWVudF9wb3J0ICAgICAgfCANCmJhY2tlbmRfc3RhcnQgICAgfCAyMDE5LTA2LTE3IDIy OjQ1OjMzLjY3OTU0NyswMA0KeGFjdF9zdGFydCAgICAgICB8IA0KcXVlcnlfc3RhcnQgICAgICB8 IA0Kc3RhdGVfY2hhbmdlICAgICB8IA0Kd2FpdF9ldmVudF90eXBlICB8IA0Kd2FpdF9ldmVudCAg ICAgICB8IA0Kc3RhdGUgICAgICAgICAgICB8IA0KYmFja2VuZF94aWQgICAgICB8IA0KYmFja2Vu ZF94bWluICAgICB8IA0KcXVlcnkgICAgICAgICAgICB8IA0KYmFja2VuZF90eXBlICAgICB8IHN0 YXJ0dXANCg0KDQpTdGFydHVwIHByb2Nlc3MgYmxvY2tpbmcgYWxsIHRoZSBhcHBsaWNhdGlvbiBx dWVyaWVzIG1vcmUgdGhhbiA0IGhvdXJzIC4NCg0KMjAyMC0wOC0yOSAwOTo1MDowNyBVVEMgWzQ1 OTZdOiBbMy0xXQp1c2VyPXBvc3RncmVzLGRiPXBncHJkX3Byb2R1Y3Rpb24sYXBwPXBzcWwsY2xp ZW50PVtsb2NhbF0gTE9HOiAgcHJvY2VzcyA0NTk2CnN0aWxsIHdhaXRpbmcgZm9yIEFjY2Vzc1No YXJlTG9jayBvbiByZWxhdGlvbiAxNzI4MCBvZiBkYXRhYmFzZSAxNjQwOCBhZnRlcgoxMDAwLjA3 NiBtcyBhdCBjaGFyYWN0ZXIgMTUNCjIwMjAtMDgtMjkgMDk6NTA6MDcgVVRDIFs0NTk2XTogWzQt MV0KdXNlcj1wb3N0Z3JlcyxkYj1wZ3ByZF9wcm9kdWN0aW9uLGFwcD1wc3FsLGNsaWVudD1bbG9j YWxdIERFVEFJTDogIFByb2Nlc3MKaG9sZGluZyB0aGUgbG9jazogMjQ0ODkuIFdhaXQgcXVldWU6 IDI1MDkxLCAyNzY3NiwgMjcxODYsIDI4NDQzLCAyNDc1NCwKMjcxMDksIDI3Njc5LCAyNjMxNCwg Mjg2ODIsIDI0NzU2LCAyNTM0OCwgMjY5MzgsIDMwOTkwLCAyOTQwNSwgMjg3NzAsIDI5NDA4LAoy NTM1MSwgMjc2MjUsIDI2MDkxLCAyNjQ3MCwgMjkxNzAsIDMwNzU2LCAyODY4MywgMjg1ODksIDI3 MTk1LCAyOTMzNiwgMjU2OTQsCjMwNjM3LCAyNTE5MSwgMjUzNDYsIDI5NjYwLCAyNzg3MiwgNjU2 MywgNjYyNSwgMjY0OTEsIDI5NDkyLCAzMDQ0MywgMjg3NjcsCjI3NzQyLCAyODg3NywgMjU2Mjks IDU5NDEsIDI2MzExLCAyNzk5MywgNjk1MSwgMjUwMjYsIDMwNTgxLCAyNzc0NiwgMzA1MjcsCjMw NzU3LCA2NTY0LCA2NTY2LCAyOTU4MiwgMjcxODgsIDMwMDg1LCAyNTAyMSwgMjcwNDEsIDI1MzUy LCAyNzE4NywgMjcwNDIsCjI5MTczLCAyNjAyOCwgMjUwNzMsIDI5NjQ5LCAyNjc5MywgMjUxOTQs IDI4NTkwLCA3NjY2LCAxMTA4MCwgMjY4MDgsIDI2Nzk4LAoyODUyOCwgMjc0OTksIDI0OTQ4LCAy OTY5NCwgMTM1ODAsIDY0NDQsIDMwNjg0LCA2NTY1LCAzMDUzMiwgNDU5Ni4NCjIwMjAtMDgtMjkg MDk6NTA6MDcgVVRDIFs0NTk2XTogWzUtMV0KdXNlcj1wb3N0Z3JlcyxkYj1wZ3ByZF9wcm9kdWN0 aW9uLGFwcD1wc3FsLGNsaWVudD1bbG9jYWxdIFNUQVRFTUVOVDogIHNlbGVjdAoqIGZyb20gbXl0 YWJsZSBsaW1pdCAxOw0KDQpBbGwgYXJlIHRoZSBwaWQgd2hpY2ggYXJlIGluIHdhaXQgcXVldWUg YXJlIGV4ZWN1dGluZyB0aGUgc2VsZWN0IHF1ZXJpZXMgb24Kc2FtZSB0YWJsZSB0aGF0IGlzICht eXRhYmxlKSAuDQoNCkNhbiB5b3UgcGxlYXNlIGhlbHAgdXMgdG8gdW5kZXJzdGFuZCB0aGUgaXNz dWVzIGFuZCBwb3NzaWJsZQpzb2x1dGlvbi93b3JrYXJvdW5kL2ZpeCBmb3IgaXQgLg0KDQpGb3Ig dGVtcCBmaXggd2UgaGF2ZSByZXN0YXJ0ZWQgdGhlIERCIHNlcnZpY2UgKCBCZWZvcmUgdGhhdCB3 ZSBoYXZlIHRyaWVkIHRvCmtpbGwgdGhlIHByb2Nlc3MgYnkgLTE1IGZsYWcgd2hpY2ggbm90IHdv cmtlZCApDQoNClRoYW5rcywNClR1c2hhciBUYWthdGUgLgoK --===============6165423545755584247==--