Re: REPACK (CONCURRENTLY) can crash a logical decoding session

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Alexander Lakhin <exclusion(at)gmail(dot)com>
Cc: Álvaro Herrera <alvherre(at)kurilemu(dot)de>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, Thom Brown <thom(at)linux(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Antonin Houska <ah(at)cybertec(dot)at>
Subject: Re: REPACK (CONCURRENTLY) can crash a logical decoding session
Date: 2026-10-01 18:30:19
Message-ID: CAD21AoBVaCqFRCnukqV0ApTNG-L+1qRVhsSD0oHRyLKW-dGTxQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 30, 2026 at 10:19 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> On Tue, Sep 29, 2026 at 1:00 PM Alexander Lakhin <exclusion(at)gmail(dot)com> wrote:
> >
> > Hello Sawada-san,
> >
> > 11.09.2026 20:56, Masahiko Sawada wrote:
> >
> > No objections here -- they look good to me too. The isolation spec
> > addition is great, thanks.
> >
> > Thank you for looking at the patches! Pushed.
> >
> >
> > A recent failure of repack_decode.spec emitted by skink [1]:
> > # diff -U3 /home/bf/bf-build/skink-master/HEAD/pgsql/src/test/modules/injection_points/expected/repack_decode.out /home/bf/bf-build/skink-master/HEAD/pgsql.build/testrun/injection_points/isolation/results/repack_decode.out
> > # --- /home/bf/bf-build/skink-master/HEAD/pgsql/src/test/modules/injection_points/expected/repack_decode.out 2026-09-25 23:32:42.088355239 +0200
> > # +++ /home/bf/bf-build/skink-master/HEAD/pgsql.build/testrun/injection_points/isolation/results/repack_decode.out 2026-09-29 18:01:56.818281263 +0200
> > # @@ -26,7 +26,7 @@
> > #
> > # count
> > # -----
> > # - 8
> > # + 12
> > # (1 row)
> > #
> > # injection_points_detach
> > # 1 of 16 tests failed.
> >
> > apparently shows that the test is not immune to autovacuum.
>
> Thank you for the report. My bad.
>
> I've attached the patch that should fix the issue.

Pushed.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Jones 2026-10-01 18:45:24 Re: CREATE TABLE .. LIKE copies comments to an unrelated table
Previous Message Antonin Houska 2026-10-01 18:29:06 Re: REPACK enhancements