Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'
Date: 2023-11-23 02:33:46
Message-ID: CAMbWs49oGdqF7aLg3OsSjo3tRFgU=vUAtKC28DtWFZNds5mc=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Nov 19, 2023 at 9:17 AM Alexander Korotkov <aekorotkov(at)gmail(dot)com>
wrote:

> It's here. New REALLOCATE_BITMAPSETS forces bitmapset reallocation on
> each modification.

+1 to the idea of introducing a reallocation mode to Bitmapset.

> I had the feeling of falling into a rabbit hole while debugging all
> the cases of failure with this new option. With the second patch
> regressions tests pass.

It seems to me that we have always had situations where we share the
same pointer to a Bitmapset structure across different places. I do not
think this is a problem as long as we do not modify the Bitmapsets in a
way that requires reallocation or impact the locations sharing the same
pointer.

So I'm wondering, instead of attempting to avoid sharing pointer to
Bitmapset in all locations that have problems, can we simply bms_copy
the original Bitmapset within replace_relid() before making any
modifications, as I proposed previously? Of course, as Andres pointed
out, we need to do so also for the "Delete relid without substitution"
path. Please see the attached.

Thanks
Richard

Attachment Content-Type Size
v2-0001-Fix-how-SJE-replaces-join-clauses.patch application/octet-stream 3.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2023-11-23 03:25:14 Re: [HACKERS] psql casts aspersions on server reliability
Previous Message Bruce Momjian 2023-11-23 01:23:42 Re: [HACKERS] Changing references of password encryption to hashing