Re: BUG #18893: Segfault during analyze pg_database

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Robins Tharakan <tharakan(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18893: Segfault during analyze pg_database
Date: 2025-04-24 23:31:55
Message-ID: aArJ663ha1v9lxrN@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Apr 14, 2025 at 06:48:32PM +0930, Robins Tharakan wrote:
> I didn't see any disk errors / memtest returned nothing / machine uses
> stock gcc (v12.2.0-14 - Ubuntu bookworm).
>
> I could reproduce this at will until this morning but not any more. A fresh
> git clone and compile in another folder on the same machine proved that the
> machine is okay, so my current guess is that I fell victim to not doing a
> 'git clean -xdf' when I was double-checking (before reporting). In most of
> my reports I try to triage the commit (which ensures this doesn't happen) -
> but I had to bypass that step this time since this was not a simple repro.
>
> Apologies for the noise, and once again thanks for taking a look.

FWIW, I've been puzzled by your report here, and also run similar
workloads on HEAD with an aggressive autovacuum setup to stress more
the code paths you have mentioned in your backtraces. That could be a
lack of luck because of a lack of friction with several concurrent
actions required, of course, but I've not been able to see your
problem. :/
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2025-04-25 02:16:37 Re: BUG #18902: TRAP:: failed Assert("!is_sorted") in File: "createplan.c"
Previous Message Japin Li 2025-04-24 15:07:53 Re: pg_restore error with partitioned table having exclude constraint