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

From David Rowley
Subject Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943
Date
Msg-id CAApHDvrGJ5K-cgMFLbfOUp_QAZhVb9CnQisygtvSoZG7X1wO7w@mail.gmail.com
Whole thread Raw
In response to BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18377: Assert false in "partdesc->nparts >= pinfo->nparts", fileName="execPartition.c", lineNumber=1943  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
On Tue, 5 Mar 2024 at 20:17, PG Bug reporting form
<noreply@postgresql.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.

David



pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently
Next
From: ocean_li_996
Date:
Subject: Re:RE: Re:BUG #18369: logical decoding core on AssertTXNLsnOrder()