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 1krSuA-0006r8-5w for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Dec 2020 21:39:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krSu9-000538-4K for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Dec 2020 21:39:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krSXL-0001Is-3T for pgsql-bugs@lists.postgresql.org; Mon, 21 Dec 2020 21:16:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krSXF-00009I-F1 for pgsql-bugs@lists.postgresql.org; Mon, 21 Dec 2020 21:16: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=Hqhs9TEtFDaSz4bpvxa3155awci31mfeCSsZcDidmns=; b=h8WF4eMGR51JDTpukyH2ZQKwOf prjYbP0wn6y9YMKk5a7GvpL0UQrRxdYvWo0vxmsi3BmZhl9JRE5g6ypTKcmpHxGYzju2DpCTMyq/i pf/V2SZekgFaNhB+Bid+ogX5Luf2Juc09Ke9kO//JQgiQe7J4m4Bzu9kWLTasiKXkgJlpuvB9wjKU dedh2Q3Nuz20xq+aVfUcak350UEncX8hBttsMMvHKmkFNxi95UmlEuvfbXv0ZG7M1NN1HQPUV3Z35 6wMru0YKlt7ukCQYZ1yz+nGOPAShtw2xdURMnnY/1P2KN9/acKS3zhDCNcL9Qat111xnFWhJNuxC2 15ix8Qjw==; 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 1krSXE-0002gp-Vt for pgsql-bugs@lists.postgresql.org; Mon, 21 Dec 2020 21:16:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krSXC-0007fc-Cj for pgsql-bugs@lists.postgresql.org; Mon, 21 Dec 2020 21:16:02 +0000 Content-Type: multipart/mixed; boundary="===============8057209997277975537==" MIME-Version: 1.0 Subject: BUG #16785: Postgresql shutdown during initial pg_prewarm prewarming causes Pg to get stuck To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jthompson@maxmind.com Reply-To: jthompson@maxmind.com, pgsql-bugs@lists.postgresql.org Date: Mon, 21 Dec 2020 21:15:24 +0000 Message-ID: <16785-c0207d8c67fb5f25@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8057209997277975537== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc4NQpMb2dnZWQgYnk6ICAgICAgICAgIEpvaG4gVGhvbXBzb24KRW1h aWwgYWRkcmVzczogICAgICBqdGhvbXBzb25AbWF4bWluZC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxMi41Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IExpbnV4CkRlc2NyaXB0aW9uOiAgICAg ICAgCgpXZSB1c2UgcGdfcHJld2FybSB2aWEgc2hhcmVkX3ByZWxvYWRfbGlicmFyaWVzIGFuZCB3 ZSd2ZSBub3RpY2VkIHRoYXQgaWYgd2UKc3RhcnQgUGcgdGhlbiBzdG9wIGl0IGFnYWluIGJlZm9y ZSBwZ19wcmV3YXJtIGZpbmlzaGVzIGl0cyBpbml0aWFsCnByZXdhcm1pbmcsIFBnIGdldHMgc3R1 Y2sgaW4gc2h1dGRvd24gdW50aWwgd2Uga2lsbCB0aGUgJ2F1dG9wcmV3YXJtIG1hc3RlcicKcHJv Y2VzcyB3aXRoICdraWxsIC05Jy4gUmVtb3ZpbmcgcGdfcHJld2FybSBmcm9tIHNoYXJlZF9wcmVs b2FkX2xpYnJhcmllcwphbGxvd3MgUGcgdG8gc3RvcCB3aXRob3V0IGlzc3VlLiBBbHNvLCBpZiB3 ZSBzdGFydCBQZywgd2FpdCBmb3IgJ2F1dG9wcmV3YXJtCnN1Y2Nlc3NmdWxseSBwcmV3YXJtZWQg WFhYWFhYIG9mIFlZWVlZWSBwcmV2aW91c2x5LWxvYWRlZCBibG9ja3MnIHRvIGFwcGVhcgppbiB0 aGUgbG9ncywgdGhlbiBzdG9wLCBpdCBzaHV0cyBkb3duIGFzIGV4cGVjdGVkLg0KDQpUaGlzIGlz IGhhcHBlbmluZyBvbiBzZXZlcmFsIGRpZmZlcmVudCBzZXJ2ZXJzLCBidXQgdGhlIG9uZSBJJ3Zl IGJlZW4KdGVzdGluZyBvbiBoYXMgODU1NTY5IGxpbmVzIGluCi92YXIvbGliL3Bvc3RncmVzcWwv MTIvbWFpbi9hdXRvcHJld2FybS5ibG9ja3MsIDMyR0Igb2YgUkFNLCBhbmQKc2hhcmVkX2J1ZmZl cnMgaXMgODAyOE1CLg0KDQpXZSdyZSB1c2luZyB0aGUgMTIuNSBwYWNrYWdlcyBmcm9tIGFwdC5w b3N0Z3Jlc3FsLm9yZy4gTm9ybWFsbHkgd2UgdXNlCnN5c3RlbWQgdG8gc3RhcnQgYW5kIHN0b3Ag c2VydmljZXMsIGJ1dCBoZXJlJ3MgYW4gZXhhbXBsZSB3aXRoIGp1c3QKcGdfY3RsOg0KDQokIHN1 ZG8gLXUgcG9zdGdyZXMgL3Vzci9saWIvcG9zdGdyZXNxbC8xMi9iaW4vcGdfY3RsIHN0YXJ0IC1E Ci92YXIvbGliL3Bvc3RncmVzcWwvMTIvbWFpbiAtbCAvdmFyL2xvZy9wb3N0Z3Jlc3FsL3Bvc3Rn cmVzcWwtMTItbWFpbi5sb2cgLW8KJy1jIGNvbmZpZ19maWxlPSIvZXRjL3Bvc3RncmVzcWwvMTIv bWFpbi9wb3N0Z3Jlc3FsLmNvbmYiJw0Kd2FpdGluZyBmb3Igc2VydmVyIHRvIHN0YXJ0Li4uLiBk b25lDQpzZXJ2ZXIgc3RhcnRlZA0KJCBzdWRvIC11IHBvc3RncmVzIC91c3IvbGliL3Bvc3RncmVz cWwvMTIvYmluL3BnX2N0bCBzdG9wIC1zIC13IC1ECi92YXIvbGliL3Bvc3RncmVzcWwvMTIvbWFp biAtbSBmYXN0DQpwZ19jdGw6IHNlcnZlciBkb2VzIG5vdCBzaHV0IGRvd24NCiQgcHMgYXV4d3d3 IHwgZ3JlcCBecG9zdGdyZXMNCnBvc3RncmVzICAgNDQ4ICAwLjcgIDAuNyA4NjY3MTY4IDI0MDI1 MiA/ICAgICAgU3MgICAyMToxMCAgIDA6MDEKL3Vzci9saWIvcG9zdGdyZXNxbC8xMi9iaW4vcG9z dGdyZXMgLUQgL3Zhci9saWIvcG9zdGdyZXNxbC8xMi9tYWluIC1jCmNvbmZpZ19maWxlPS9ldGMv cG9zdGdyZXNxbC8xMi9tYWluL3Bvc3RncmVzcWwuY29uZg0KcG9zdGdyZXMgICA0NTUgIDAuMSAg MC4wIDE4MjAzNiAgNDI1MiA/ICAgICAgICBTcyAgIDIxOjEwICAgMDowMCBwb3N0Z3JlczoKbG9n Z2VyICAgDQpwb3N0Z3JlcyAgIDQ1OCAgMC4wICAwLjAgODY2NjEzMiA0MDg4ID8gICAgICAgIFNz ICAgMjE6MTAgICAwOjAwIHBvc3RncmVzOgpjaGVja3BvaW50ZXIgICANCnBvc3RncmVzICAgNDYy ICAwLjAgIDAuMCAxODUyMzIgIDU5MjggPyAgICAgICAgU3MgICAyMToxMCAgIDA6MDAgcG9zdGdy ZXM6CnN0YXRzIGNvbGxlY3RvciAgIA0KcG9zdGdyZXMgICA0NjMgIDAuMyAgMC4wIDg2ODI5NzYg MjI3NDAgPyAgICAgICBTcyAgIDIxOjEwICAgMDowMCBwb3N0Z3JlczoKYXV0b3ByZXdhcm0gbWFz dGVyICAgDQpwb3N0Z3JlcyAgIDUwNyAgMC4wICAwLjAgODY2Nzk5NiAxMjYxNiA/ICAgICAgIFNz ICAgMjE6MTAgICAwOjAwIHBvc3RncmVzOgp3YWxzZW5kZXIgcmVwbWdyIDEwLjE1MC4wLjE2KDMz NzE4KSBzdHJlYW1pbmcgMzRBNjUvNDI0M0E1QzgNCnBvc3RncmVzICAgNTA4ICAwLjAgIDAuMCA4 NjY3OTk2IDEyNjEyID8gICAgICAgU3MgICAyMToxMCAgIDA6MDAgcG9zdGdyZXM6CndhbHNlbmRl ciByZXBtZ3IgMTAuMTUwLjAuMTUoNTI5ODIpIHN0cmVhbWluZyAzNEE2NS80MjQzQTVDOA0KJCBz dWRvIGtpbGwgNDYzIC05DQokIHBzIGF1eHd3dyB8IGdyZXAgXnBvc3RncmVzDQokIA0KDQpQbGVh c2UgbGV0IG1lIGtub3cgaWYgYW55IG90aGVyIGluZm9ybWF0aW9uIHdvdWxkIGJlIHVzZWZ1bCwg SSdtIGhhcHB5IHRvCmhlbHAuIFRoYW5rcyBmb3IgYW55IGhlbHAgeW91IGNhbiBvZmZlci4KCg== --===============8057209997277975537==--