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.96) (envelope-from ) id 1wW3ze-002MkL-39 for pgpool-hackers@arkaria.postgresql.org; Sun, 07 Jun 2026 03:16:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wW3zd-00Gsky-2i for pgpool-hackers@arkaria.postgresql.org; Sun, 07 Jun 2026 03:16:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wW3zd-00Gskq-2A for pgpool-hackers@lists.postgresql.org; Sun, 07 Jun 2026 03:16:09 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wW3zb-00000001TxZ-0QfT for pgpool-hackers@lists.postgresql.org; Sun, 07 Jun 2026 03:16:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=Gc3KR/W6BB8MjNg/47Ib7aHKOUOdfl0LjQrCJYezTT4=; b=65mqK7d/PQzm/mSq4AKyQiM/Ti Eqvloqo142pVSSxTaloyHB+7WlhGLG4xsScYPgOSIqncxQDQiDyiw/Y4kF7GX0NqWjfDavcWw3/Q6 GKOgVYczlENjSk7vMXKsSXnZ6xoF7I4e0QTGEmg+1Hy3leN/ArlEALzm0aJH+dJfTXLtVQe/khEsp KW2zHY8rhnga7JVEHa0809PnEYsvyZLuVHgfotB2Hv5Re3a4QQKxgC+RN1TBJSdpHp72AQxW05d3b 2B8aEXQOVUYMdT3dD7TrQoebNQk5Jhm5mbqqhwjYz3inZDXNLsSR0ldhZAuabAcdMCNPJmCo62Btu QDjkgCBg==; Received: from [2409:11:4120:300:47b8:214e:f63e:8a9] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wW3zS-00566K-2H; Sun, 07 Jun 2026 03:16:00 +0000 Date: Sun, 07 Jun 2026 12:14:51 +0900 (JST) Message-Id: <20260607.121451.1153620491531303302.ishii@postgresql.org> To: emond.papegaaij@gmail.com Cc: pgpool-hackers@lists.postgresql.org Subject: Re: Race condition in pcp_node_info can cause it to hang From: Tatsuo Ishii In-Reply-To: References: <20260605.080932.2120655380457259936.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-8859-7 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:47b8:214e:f63e:8a9 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGksDQoNCkZpeCBwdXNoZWQgdG8gYWxsIHN1cHBvcnRlZCBicmFuY2hlcy4NCmh0dHBzOi8vZ2l0 LnBvc3RncmVzcWwub3JnL2dpdHdlYi8/cD1wZ3Bvb2wyLmdpdDthPWNvbW1pdDtoPTdjOTE4ZGMy NDc2MTNkMTZkNTkwYTlmMzBlY2M3NDdkYTY4NzE3OTYNCg0KVGhhbmsgeW91IQ0KDQpSZWdhcmRz LA0KLS0NClRhdHN1byBJc2hpaQ0KU1JBIE9TUyBLLksuDQpFbmdsaXNoOiBodHRwOi8vd3d3LnNy YW9zcy5jby5qcC9pbmRleF9lbi8NCkphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQoN Cj4gSGksDQo+IA0KPiBUaGFua3MgZm9yIHRoZSBxdWljayBmb2xsb3d1cCENCj4gDQo+IEJlc3Qg cmVnYXJkcywNCj4gRW1vbmQNCj4gDQo+IE9wIHZyIDUganVuIDIwMjYgb20gMDE6MDkgc2NocmVl ZiBUYXRzdW8gSXNoaWkgPGlzaGlpQHBvc3RncmVzcWwub3JnPjoNCj4+DQo+PiBIaSBFbW9uZCwN Cj4+DQo+PiA+IEhpLA0KPj4gPg0KPj4gPiBXZSd2ZSBoaXQgYW5vdGhlciB2ZXJ5IHJhcmUgZmxh a2UgaW4gb3VyIHRlc3RzLCB3aGljaCBjYW4gY2F1c2UNCj4+ID4gcGNwX25vZGVfaW5mbyB0byBo YW5nIGluZGVmaW5pdGVseS4gSSd2ZSBhbmFseXplZCB0aGUgcHJvYmxlbSB3aXRoDQo+PiA+IENs YXVkZSBDb2RlLCBhbmQgaXQgY2FtZSB0byB0aGUgY29uY2x1c2lvbiBhbmQgKHF1aXRlIHNtYWxs KSBmaXgNCj4+ID4gYmVsb3cuIEF0dGFjaGVkIGlzIGEgcGF0Y2ggYWdhaW5zdCA0LjcuDQo+PiA+ DQo+PiA+IFRoZSBwcm9ibGVtOg0KPj4gPiBJbiBpbmZvcm1fbm9kZV9pbmZvKCkgKHNyYy9wY3Bf Y29uL3BjcF93b3JrZXIuYyksIHRoZSBQQ1AgcmVwbHkgcGFja2V0DQo+PiA+IHJlYWRzIGJpLT5y ZXBsaWNhdGlvbl9zdGF0ZSBhbmQgYmktPnJlcGxpY2F0aW9uX3N5bmNfc3RhdGUgZGlyZWN0bHkN Cj4+ID4gZnJvbSBzaGFyZWQgbWVtb3J5IHR3aWNlOiBvbmNlIHZpYSBzdHJsZW4oKSB0byBjb21w dXRlIHRoZSBwYWNrZXQNCj4+ID4gbGVuZ3RoLCBhbmQgb25jZSB2aWEgcGNwX3dyaXRlKCkgdG8g d3JpdGUgdGhlIHBheWxvYWQuDQo+PiA+DQo+PiA+IFRoZSBzdHJlYW1pbmctcmVwbGljYXRpb24g Y2hlY2sgd29ya2VyIHJld3JpdGVzIHRob3NlIHNhbWUNCj4+ID4gc2hhcmVkLW1lbW9yeSBzdHJp bmdzIHdpdGhvdXQgYSBsb2NrIChpdCBjbGVhcnMgdGhlbSB0byAiIiB0aGVuDQo+PiA+IHJlcG9w dWxhdGVzIHRoZW0gZXZlcnkgY2hlY2sgY3ljbGUgYW5kIG9uIHN0YXRlIHRyYW5zaXRpb25zLA0K Pj4gPiBzcmMvc3RyZWFtaW5nX3JlcGxpY2F0aW9uL3Bvb2xfd29ya2VyX2NoaWxkLmMpLiBJZiB0 aGUgc3RyaW5nJ3MgbGVuZ3RoDQo+PiA+IGNoYW5nZXMgYmV0d2VlbiB0aGUgdHdvIHJlYWRzLCB0 aGUgZGVjbGFyZWQgd3NpemUgbm8gbG9uZ2VyIG1hdGNoZXMNCj4+ID4gdGhlIGJ5dGVzIGFjdHVh bGx5IHdyaXR0ZW4sIHNvIHRoZSBQQ1AgYnl0ZSBzdHJlYW0gZGVzeW5jaHJvbmlzZXMuIFRoZQ0K Pj4gPiBjbGllbnQgdGhlbiBibG9ja3MgZm9yZXZlciBpbiBwY3BfcmVhZCgpIHdhaXRpbmcgZm9y IGJ5dGVzIHRoZSBzZXJ2ZXINCj4+ID4gbmV2ZXIgc2VuZHMuDQo+PiA+DQo+PiA+IFRoZSBmaXg6 DQo+PiA+IFNuYXBzaG90IHRoZSB0d28gc3RyaW5ncyBpbnRvIGxvY2FsIGJ1ZmZlcnMgb25jZSwg cmlnaHQgYWZ0ZXIgYmkgPQ0KPj4gPiBwb29sX2dldF9ub2RlX2luZm8oaSksDQo+PiA+IGFuZCB1 c2UgdGhlIGxvY2FscyBmb3IgYm90aCB0aGUgbGVuZ3RoIGFuZCB0aGUgcGF5bG9hZCCvIHNvIGEg c2luZ2xlDQo+PiA+IHBhY2tldCBpcyBhbHdheXMNCj4+ID4gaW50ZXJuYWxseSBjb25zaXN0ZW50 LiBUaGlzIG1hdGNoZXMgaG93IGV2ZXJ5IG90aGVyIGZpZWxkIGluIHRoZQ0KPj4gPiBwYWNrZXQg aXMgYWxyZWFkeQ0KPj4gPiBoYW5kbGVkLg0KPj4NCj4+IFRoYW5rIHlvdSBmb3IgdGhlIHJlcG9y dCBhbmQgZml4LiBZZXMsIEkgYWdyZWUgdGhlcmUncyBhIHJhY2UNCj4+IGNvbmRpdGlvbiBiZXR3 ZWVuIHNyIGNoZWNrZXIgcHJvY2VzcyBhbmQgcGNwX25vZGVfaW5mby4gSSB0aGluaw0KPj4gaW50 cm9kdWNpbmcgYSBsb2NrIHRvIHByb3RlY3QgYmktPnJlcGxpY2F0aW9uX3N0YXRlIGFuZA0KPj4g YmktPnJlcGxpY2F0aW9uX3N5bmNfc3RhdGUgaXMgb3ZlcmtpbGwuIFRoZSBzdWdnZXN0ZWQgZml4 IHNlZW1zIHRvIGJlDQo+PiBhIHJpZ2h0IGRpcmVjdGlvbi4gIFdpbGwgcHVzaCBhZnRlciBjdXJy ZW50IHJlbGVhc2UgZnJlZXplIGlzIG92ZXINCj4+IChzdXBwb3NlZCB0byBiZSBmaW5pc2hlZCBi eSB0aGUgZW5kIG9mIHRvZGF5KS4NCj4+DQo+PiBSZWdhcmRzLA0KPj4gLS0NCj4+IFRhdHN1byBJ c2hpaQ0KPj4gU1JBIE9TUyBLLksuDQo+PiBFbmdsaXNoOiBodHRwOi8vd3d3LnNyYW9zcy5jby5q cC9pbmRleF9lbi8NCj4+IEphcGFuZXNlOmh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwDQo+IA0KPiAN Cg==