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 1uqcSk-009mOO-I6 for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Aug 2025 19:02:39 +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 1uqcSj-00D6aB-5h for pgsql-hackers@arkaria.postgresql.org; Mon, 25 Aug 2025 19:02:37 +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 1uqcSi-00D6a2-SX for pgsql-hackers@lists.postgresql.org; Mon, 25 Aug 2025 19:02:37 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uqcSh-001onf-18 for pgsql-hackers@postgresql.org; Mon, 25 Aug 2025 19:02:37 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3e66c013e4dso24863975ab.0 for ; Mon, 25 Aug 2025 12:02:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756148552; x=1756753352; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=aay+imsbTQppNGqAMnK1dxXi8wIi+WGtdq7F66z4ZOw=; b=TKwAqNbvb6Q+gVgneP8qH04kP7GA4MxvC15StbGghKJDKEYShtsWP0mjF2h2g/SCAJ G8e7s8nhabSjbQiZmC1IgV7JIz7K9pyvc2884k9dCAa3o01lEaubGSkE672AJAIldKdG SlxD77AAIseLvdJkHEk29cyXT5DRbdXixjOa25QacDo/OiGonekAb0waEX8lO52HcZdM sxjy/nwPRsvh7fFWhPVKVxvUtjhzFfvZH7ENXrAvAj/fYdERYvXvRp+APpjaFv9YIK+4 DL5oClgTj8/U8LrpxlFz9m5gn1JWfsXSZKfDGkprTGEbLEnxxINwskmvmAg6ikbzzE/X qwuQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756148552; x=1756753352; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=aay+imsbTQppNGqAMnK1dxXi8wIi+WGtdq7F66z4ZOw=; b=AghV/9F4QSUJ3zTVZGt/TcgPs8KOHpsGhCVmpvP28TjsiFt+LbqoEHAecvMiDL+eMN UUy2qyWQDKBKXmZjlWJ/EV2Z2Z/JI0La7lMgQrdwfjfjHL0ZnDDPpkXTkYeMTUh07c9a jCVlXR3tzu9B2h/TaDR38nRUtAqgrMeR/CvFdrH5jPFEfFlNJevujpYvevbIk2DHDKtF aghGn3Fs3fHTCRT5HvCFYpT69KPr0S8jN/4gkuTyFvnsToUiB/jLwYosfwsz/3lW8Zxv tvzlJryroU8pybvE6EdsqoqfCTUskQaf/CZpzNPKuICYS/iS6GnpTzLsLlKPlHgRN/cw uE0Q== X-Gm-Message-State: AOJu0Yw+heyy6LSlCf3gslnEgyaR+oAiO983JRTEryRJNLbRWMHbOXsv HzX1c1ZzVjudl8PlZZFrDOQtoHl/DCFGwbwTEjJAWkh+ohBYU3663i4MYJk9/A== X-Gm-Gg: ASbGncuW9J8Wm60qNMqK/iiLoO68YiU6BIjynaVkZBYKtblv5rlbGtK7N0kQeGwJDp0 GXSzQDSOcOuv5FIO8rC1r40ausl+80oKOUYqoFRt3SmkUKR7qDDT1M1j+xgbCtrBsm00YYxJLRw 0DGTfbzO7fezTfkW8dvHmxE9QOsKmcShq/kLLO5KSygJ9ab6L9s2VSctBCA6Hq7VuxObob9EbX/ I8hGAaTvx4k1LvAZVlNfsGKmLMcgnMEXj1aDPS1mIM4XfkCafxRr5q9T+cSzK4cD6Bul8L42SdZ D7d7zkdNA5qGxlgtguVJ3oqHahfGl3XYiPWfaMP/EVr6r/sTkgmiglxdQKLrL1w3nywt2pSj5cv 1WD1W/Aqrbx6Mterw5cf55AlYEudcgIuIuTB6u9HTUqwBb3YBvN9SPAaxBkA0IZ7gSCZoYvXLG1 cMR6XyC5dR73sS X-Google-Smtp-Source: AGHT+IECB3JIlwDKVQluMPOBK6YG+5aWfy0pISR+RvLo1EbXUeKMZyj5tNdKZibEBXR7OZ0gFuNOyg== X-Received: by 2002:a05:6e02:1b0c:b0:3e6:7d1a:8f22 with SMTP id e9e14a558f8ab-3ee5da0af78mr11745575ab.6.1756148548593; Mon, 25 Aug 2025 12:02:28 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3eba4bb1eacsm34905725ab.5.2025.08.25.12.02.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 25 Aug 2025 12:02:28 -0700 (PDT) Date: Mon, 25 Aug 2025 14:02:26 -0500 From: Nathan Bossart To: Sami Imseih Cc: pgsql-hackers Subject: Re: GetNamedLWLockTranche crashes on Windows in normal backend Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Aug 25, 2025 at 01:44:22PM -0500, Sami Imseih wrote: > Another approach is to just change GetNamedLWLockTranche to use > NamedLWLockTrancheArray since that is already copied in EXEC_BACKEND, and > allow GetNamedLWLockTranche to continue to be used outside of startup. In > this case, we will need to add num_lwlocks field to > NamedLWLockTrancheArray. This might be better to backpatch, since we will > not be changing user facing behavior. That seems like a reasonable thing to try. It looks like NamedLWLockTrancheRequests is copied, too. Could we used that instead of adding a new variable? My guess is that this has been broken since this code was introduced in commit c1772ad from 2016/v9.6, and AFAIK you are the first to report it, so I don't feel a tremendous amount of urgency to fix it on the back-branches. -- nathan