Re: Assert while autovacuum was executing

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Assert while autovacuum was executing
Date: 2023-06-30 02:56:29
Message-ID: CAA4eK1KXQLC2h6+B3-zkUXPQy0LPyzgrOMQdSGrMeHULmp781Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 28, 2023 at 7:26 AM Zhijie Hou (Fujitsu)
<houzj(dot)fnst(at)fujitsu(dot)com> wrote:
>
> On Monday, June 26, 2023 12:18 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > Fair enough. If we could have been convinced of this then we can keep the
> > required change only for HEAD. But anyway let's remove the work related to
> > both commits (72e78d831a and 3ba59ccc89) for now and then we can come
> > back to it when we parallelize writes. The attached patch removes the changes
> > added by both commits with slight tweaking in comments/readme based on
> > the recent state.
>
> Thanks for the patch. I have confirmed that the patch to revert page lock
> handling applies cleanly on all branches(13~HEAD) and the assert failure and
> undetectable deadlock problem are fixed after applying the patch.
>

Thanks for the verification. Unless someone has any further comments
or suggestions, I'll push this next week sometime.

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2023-06-30 03:02:58 Re: Assert !bms_overlap(joinrel->relids, required_outer)
Previous Message Tristan Partin 2023-06-30 02:13:26 Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG