From: | David Rowley <dgrowleyml(at)gmail(dot)com> |
---|---|
To: | Yuri Zamyatin <yuri(at)yrz(dot)am> |
Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #19078: Segfaults in tts_minimal_store_tuple() following pg_upgrade |
Date: | 2025-10-12 08:10:13 |
Message-ID: | CAApHDvriuYHvGcuci+h6kMc306DgHkfTbro53AU=3UokpSOSOw@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, 10 Oct 2025 at 14:34, Yuri Zamyatin <yuri(at)yrz(dot)am> wrote:
>
> Hi. I was able to reproduce the crash with the simpler (non hash-agg) plan from the previous message.
> Basically I launched it in multiple infinite loops that do BEGIN - UPDATE - ROLLBACK. Other clients could also modify the tables during this time.
> We've seen this query crash on multiple physical hosts.
> > #0 0x0000555fe8678300 in PartitionDirectoryLookup (pdir=0x0, rel=0x7f14d172b288) at ./build/../src/backend/partitioning/partdesc.c:462
> > pde = <optimized out>
> > relid = 21856
> > found = 27
Looks like that's crashing in a different place from the last
backtrace you showed.
Are you able to test this without any extensions loaded to see if you
still get a crash?
At a wild guess, perhaps an extension has gone rogue and spawned
another thread resulting in something like concurrent palloc requests
getting confused and causing something strange to happen when
accessing certain palloc'd chunks. Running without extensions may help
narrow things down.
> postgresql_effective_cache_size = 560GB
> postgresql_shared_buffers = 225GB
Which extension are these GUCs from?
David
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2025-10-12 08:24:27 | Re: [BUGS] BUG #11500: PRIMARY KEY index not being used |
Previous Message | Álvaro Herrera | 2025-10-11 18:35:36 | Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently |