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 1u3y5Y-005jVr-C0 for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Apr 2025 14:13:36 +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 1u3y5W-007Icr-7h for pgsql-bugs@arkaria.postgresql.org; Sun, 13 Apr 2025 14:13:35 +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.94.2) (envelope-from ) id 1u3y5V-007Icj-VS for pgsql-bugs@lists.postgresql.org; Sun, 13 Apr 2025 14:13:34 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u3y5V-0007sM-0I for pgsql-bugs@lists.postgresql.org; Sun, 13 Apr 2025 14:13:33 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 53DEDVkx829594; Sun, 13 Apr 2025 10:13:31 -0400 From: Tom Lane To: Robins Tharakan cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18893: Segfault during analyze pg_database In-reply-to: References: <18893-da17531047e6447f@postgresql.org> Comments: In-reply-to Robins Tharakan message dated "Sun, 13 Apr 2025 21:41:00 +0930" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <829592.1744553611.1@sss.pgh.pa.us> Date: Sun, 13 Apr 2025 10:13:31 -0400 Message-ID: <829593.1744553611@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Robins Tharakan writes: > On Sat, 12 Apr 2025 at 13:05, PG Bug reporting form > wrote: >> Creating a few Databases followed by CHECKPOINT causes a segfault. > Simply running pgbench (or any workload that triggers AV) causes a segfault. At this point I'm starting to suspect a compiler bug (or hardware fault?) on your machine. I spent awhile last night trying to replicate your previous report and failed, both on x86_64/RHEL8 and Apple M4/Sequoia. Moreover, we're not seeing the sort of instability in the buildfarm that would inevitably appear if AV were as broken as it seems to be for you. regards, tom lane