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 1tqV5V-005sOM-W6 for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Mar 2025 10:37:54 +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 1tqV5U-00Fvhi-9w for pgsql-bugs@arkaria.postgresql.org; Fri, 07 Mar 2025 10:37:52 +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 1tqV5T-00Fvha-Vq for pgsql-bugs@lists.postgresql.org; Fri, 07 Mar 2025 10:37:52 +0000 Received: from fout-a4-smtp.messagingengine.com ([103.168.172.147]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tqV5Q-001TyT-0c for pgsql-bugs@lists.postgresql.org; Fri, 07 Mar 2025 10:37:51 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id 856E5138281B; Fri, 7 Mar 2025 05:37:48 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Fri, 07 Mar 2025 05:37:48 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1741343868; x=1741430268; bh=g bVvnKhukLq/g3FMcV3rv09rvXT+F0iwm1QOrH/BeGs=; b=BP5q33GfmMj+Je9Km v8W/41t86bGGOMKMdFn1KJhYdBhVxoKMG91qpdjSmwvRJa15aCmCnHsGCpp/pcNY H35m7uhjUSDqUeZYmsZ3yF+fNJ9j5+sUPBxzLiWgaMqe1zNCMqK0LHz8amRcykpg voQl9NQcphwziLPywAgQXiUmNauNj8C7bFvkfYw7K/vxBlgVEx6tJhkke6co5cnC F8f3E6REE/INZgGAblORu7I1w8by2zItQ2JrxXMrJase41chjaM1rzv7GYHCQG0j QkV+YQuqKWDV1XrwjiIaZLvg/hkYOKHtqOD+kKVgOwBaiHhu9mTmzmiMxVqvjBsv xCx6w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduuddtgeegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepfffhvfevuffkgggtugfgjgesthekredttddt jeenucfhrhhomheplmhlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepvdfhtefghfdvfeefieeu feevgefhveehueeftdehgfefheduffetffehffdujeeunecuffhomhgrihhnpehpohhsth hgrhgvshhqlhdrohhrghdpvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgvsegrlh hvhhdrnhhoqdhiphdrohhrghdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphho uhhtpdhrtghpthhtohepghhuohhfvghnghhlihhnuhigsehgmhgrihhlrdgtohhmpdhrtg hpthhtohepthhhrghrrghkrghnsehgmhgrihhlrdgtohhmpdhrtghpthhtohephhhlihhn nhgrkhgrsehikhhirdhfihdprhgtphhtthhopehpghhsqhhlqdgsuhhgsheslhhishhtsh drphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 7 Mar 2025 05:37:47 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1741343862; bh=gf4m1Yji1qGBYBHyU9dJ8cdXLPhw0jfCuuNVHw9nVV4=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=oYCPEI7+hzk9EGhe/Qfu1R+8YJH2TV68z9sDm/diMel0wxDAdo9CCsWoaCZCGsDVM e2tow7Rn7nAlBYpySM2RrDa7thD7yCyvK8GJwMIsciDeWi4Jk3j0nbUQD9w+5HhDwF yMasye/dOB/5tKea779SPf9r0Z00wtQw0X2wvKMdObxRcGnoQUOCQ9e8Lvxvd+VsyX BjhG6EYcRcbP4T+n8IU9JaDbmjSFe0WdzMs30tHmYtrXV7t7eUuqn2KbKiZodGjcOJ Pmsqt1+rhg3ZC1ElIhkvsaJ64VsiZ1N3GGuVU5zTBiHcMRywx/1dNs6fw++ZTadUG7 DQCJA5C1QcyZQ== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id C1CB28F; Fri, 7 Mar 2025 11:37:42 +0100 (CET) Date: Fri, 7 Mar 2025 11:37:42 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Richard Guo Cc: tharakan@gmail.com, pgsql-bugs@lists.postgresql.org, Heikki Linnakangas Subject: Re: BUG #18832: Segfault in GrantLockLocal Message-ID: <202503071037.nrgp6vmhflcl@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Mar-07, Richard Guo wrote: > I encountered the same issue months ago and reported it here [1]. > Heikki suspected that commit 3c0fd64fec might be the culprit. > Unfortunately, we haven't been able to track it down because we > couldn't find a reliable way to reproduce it. One way to capture this might be to run the problem workload under rr enough times until it reproduces, and then it can then be replayed under the debugger. https://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Recording_Postgres_using_rr_Record_and_Replay_Framework -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/