RE: [BUG]"FailedAssertion" reported in lazy_scan_heap() when running logical replication

From: "tanghy(dot)fnst(at)fujitsu(dot)com" <tanghy(dot)fnst(at)fujitsu(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: "Amit(dot)Kapila(at)fujitsu(dot)com" <Amit(dot)Kapila(at)fujitsu(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [BUG]"FailedAssertion" reported in lazy_scan_heap() when running logical replication
Date: 2021-04-29 05:46:00
Message-ID: OS0PR01MB61131168BB199957E9227B5DFB5F9@OS0PR01MB6113.jpnprd01.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thursday, April 29, 2021 1:22 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote

>Is setting all_visible_according_to_vm false as below enough to avoid
>the assertion failure?
>
>diff --git a/src/backend/access/heap/vacuumlazy.c
>b/src/backend/access/heap/vacuumlazy.c
>index c3fc12d76c..76c17e063e 100644
>--- a/src/backend/access/heap/vacuumlazy.c
>+++ b/src/backend/access/heap/vacuumlazy.c
>@@ -1146,6 +1146,7 @@ lazy_scan_heap(LVRelState *vacrel, VacuumParams
>*params, bool aggressive)
> {
> ReleaseBuffer(vmbuffer);
> vmbuffer = InvalidBuffer;
>+ all_visible_according_to_vm = false;
> }
>
> /* Remove the collected garbage tuples from table and indexes */

Thanks for your reply.
I tried your patch but the problem seems not be fixed.

Regards,
Tang

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2021-04-29 06:18:27 Re: [BUG] "FailedAssertion" reported when streaming in logical replication
Previous Message Masahiko Sawada 2021-04-29 05:43:44 Re: Replication slot stats misgivings