Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: 1026592243(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943
Date: 2024-03-19 12:33:01
Message-ID: 202403191233.myi4xwsav5om@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2024-Mar-06, David Rowley wrote:

> On Tue, 5 Mar 2024 at 20:17, PG Bug reporting form
> <noreply(at)postgresql(dot)org> wrote:
> > 1943 Assert(partdesc->nparts >= pinfo->nparts);
> > (gdb) p partdesc->nparts
> > $1 = 1
> > (gdb) p pinfo->nparts
> > $2 = 2
>
> The following comment says this shouldn't happen, but apparently it can:
>
> * Because we request detached partitions to be included, and
> * detaching waits for old transactions, it is safe to assume that
> * no partitions have disappeared since this query was planned.
>
> Added Álvaro as he knows this area best.

Oh, ugh, apologies, I hadn't noticed this report. I'll have a look ...

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2024-03-19 14:26:16 Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting large tuples into gist index
Previous Message Tender Wang 2024-03-19 12:07:12 Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting large tuples into gist index