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 1wfHsq-005NPg-0e for pgpool-hackers@arkaria.postgresql.org; Thu, 02 Jul 2026 13:55:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wfHso-001ptD-0J for pgpool-hackers@arkaria.postgresql.org; Thu, 02 Jul 2026 13:55:14 +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.96) (envelope-from ) id 1wfHsn-001pt6-31 for pgpool-hackers@lists.postgresql.org; Thu, 02 Jul 2026 13:55:13 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wfHsl-00000001NLJ-2ErR for pgpool-hackers@lists.postgresql.org; Thu, 02 Jul 2026 13:55:13 +0000 Received: by mail-pj1-x102b.google.com with SMTP id 98e67ed59e1d1-37ff8e0ad0fso1653693a91.2 for ; Thu, 02 Jul 2026 06:55:10 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783000508; cv=none; d=google.com; s=arc-20260327; b=a+BgsoOgtIkYoulBC/nWE2sXLIpVATob9L5msXk/0D8WMx7tDHD2qEMhE+mLuiuvRQ LbdPgrgzEp6g0XeVZWuXnfbzAyNCJFYkzoJhKrk49+x3vZlbQBr6mACHygYhGd9LsKQa uoja1K5s9dVDjOKy/UVDCPdyvS6BlLdysVWVUP5u6aKFxneMXPzVEYbjrZ16/rBQO08i P78Ye0PjYGIt+8Z2WYVdz0SmQZYONo9NRLDRLGG44XG/8N6cRqzGa5H76hl4W9zyavi/ Gv/rORgnV/69yirnBWnsB5qF4YsCE2OuK2WO9vEMephZ8Ty6fp46q8pc7oPZ++MQIn+4 rDYA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=en9oYr4DL7wUIf/EMZMOM+/etlxPOiKVDUaD465bz7M=; fh=m3oiE62fRN5J1XaE+5vpHZRIgCyFefxVI0mFw3d8yxA=; b=Bv2rW13tv91QG6IP2NaXjZonApJ8gJgmEkecTWwJlMWlvTqIopheQDnJwc/HGP+NyY VxbgVxGwUSIJFhggHjq0K0ON41/D/QZ5Akli72vewrD49mZU1MHnto+XClZTbxVbaxyM fpSceZrjmXd8hUvFmR1DE1n9JFWj+1ldixFEZs9WADow4O03SRcxuHfvHnZIGDnZqqfT 0WSLc3VDjVJ85qMDNWycX0Qk5Wac7rEkLeV2jU6Ob2UiPNNm55F3GcOrfoKno3tJ0LWi 4rLe+lRQRHR2vNftvWf/x1wMrChaXsB1T1PGvOE8onWFJLj4Fnmt+BzPzMY0BBib9yrD EcrA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783000508; x=1783605308; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=en9oYr4DL7wUIf/EMZMOM+/etlxPOiKVDUaD465bz7M=; b=IrMmS6NcpGiLOc4f4wn8p7h3BU0HyAln55tkxjpya9mTyS7/29airJHd34KkgtnJ0+ hLgTeebpDCiPGaL5QDJZ7eDxEySKnMy1483Cpgl7dV7NFV+HYNMbVvoYwAByE9QWBI3W 7X+mkiHyIj/G181iHtfFQlf9KXJbXh4KM1lqOreGKtuDRT+9WrSYg4QMhRB3ogCOmcsG PD2AjBDEZGasoWoRoMCxVD/zlZB1N+swm/yh0ojcagzAy2sOe1V1nOJTpNWVCIPCu+b4 wfM73J3xSGlXS/R490d8d3Zrq8JClfItdiXQ0W2OEfV3LAW5P/FvdBJ/QvdVMe6K608d /u+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783000508; x=1783605308; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=en9oYr4DL7wUIf/EMZMOM+/etlxPOiKVDUaD465bz7M=; b=SgL5zXgT8d23bECLdbNCStd2yTQ0eGqq47GXKw3aIE2x3E94yV3M0UopMc5g8LU6yW ncp51QX+2m8tkN2zlakeSMNuL0SNltAhEVd+J/Vd/8iF2IDgNLGsgTdCzukUNxli2uOL 1gl+AcEYahomyAyXHupPO9KzFBWc+fEermZSyyw46UYS/fEW0xk4Gr/45phEXyZ/ih6S XGs2ZmD/Xp2xOMxd+7E5/ckF4OW0w7y9q0af8ukxWXKgMb8pIk6qahjUPopZs7bAWXxP T9EPhum6tVOc5CPwGZsuTuYOFuvMtj9YjTIagZI9QIZjKtchvhmFQ6p0wbx0Og+oevAb xbzw== X-Gm-Message-State: AOJu0YyuF3homzi04S2E59OJxfnDSCv5X9geFnBoJLBgyk3KpKG4mAkC qCO5eAGv5pdzi8dlE2nC0+F41ceXoCQYGznPz5RP8pXd3JlHfXxc6lzbMfa5UurGlJ6de5R8UAY Aw66q0QdqTB6V/2j+4HSR736QxOfBu01yfWtYduc= X-Gm-Gg: AfdE7ckGiFoy4X2ymx3/o3fglgLuy145Bd5uJHqf+IWPzEkVUfXtNNTkJUC7g/2/SD8 ooAJM9CSnJUmIpnvJ/G5HWyce1CUrVhep+e0Cxs9C27mLDfT8JH6bJjvZHEa+Ty0zuYZXw8hosB 26rOIOs6W7ZSoQTdusN1C2k02dhqZ10wzLqjwDdduSmNJFSHmFcTmSQzLctJysYJxnU152fhXkU xXPMPMT3ocj5aRRUBd0xNrggmsCoHNltDt4GeyXSsr48tdYwzouS3eFwrCTFJV0iU6uz0GX7G1E KIuXFPhIpc8snq6GYi5XAOee5VBisA== X-Received: by 2002:a05:6a21:4801:b0:3bf:ab02:439e with SMTP id adf61e73a8af0-3bfed2078f6mr6875388637.27.1783000508059; Thu, 02 Jul 2026 06:55:08 -0700 (PDT) MIME-Version: 1.0 References: <20260702.163922.30147080599128209.ishii@postgresql.org> <20260702.224517.1668373716426906512.ishii@postgresql.org> In-Reply-To: <20260702.224517.1668373716426906512.ishii@postgresql.org> From: Emond Papegaaij Date: Thu, 2 Jul 2026 15:54:56 +0200 X-Gm-Features: AVVi8CfXyxW6xbTlz93yUB0KJDGYc_385VfulcBLtGW96pAucegVT5ILFCOmdfE Message-ID: Subject: Re: [PATCH] Segfault in pool_do_auth() when failover races with a new connection To: Tatsuo Ishii Cc: pgpool-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Tatsuo, Yes, this looks good. There's one small nit: there's some whitespace noise in the patch (space before tab) on the line with "my_main_node_id = *(volatile int *) &REAL_MAIN_NODE_ID;" Best regards, Emond Op do 2 jul 2026 om 15:45 schreef Tatsuo Ishii : > > Hi Emond, > > > The new patch looks fine to me. There's however one thing Claude > > pointed out. According to it, my_main_node_id, > > private_backend_status[], and my_backend_status[] are per-process > > globals (copied on fork), not shared memory. So, making any of those > > volatile should not make any difference. > > You are right. Attached is the v3 patch. > > Regards, > -- > Tatsuo Ishii > SRA OSS K.K. > English: http://www.sraoss.co.jp/index_en/ > Japanese:http://www.sraoss.co.jp