Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation

From: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Nikolay Samokhvalov <nik(at)postgres(dot)ai>, Srinath Reddy Sadipiralla <srinath2133(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation
Date: 2026-10-01 11:08:40
Message-ID: CABdArM5dFEwEnOYaF1XgK37fLeWB447fz9jfunh3wNK79shXTQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Sep 26, 2026 at 3:54 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
>
> I've incorporated your comment suggestions, and updated cosmetic
> things.Please review them.
>

Hi,
I reviewed the TAP test and it LGTM. I found no correctness issues,
just a couple of nits compared to the neighboring tests. Please
consider these if they look okay to you:

1) Add the sync_slot condition to injection_points_attach() similar to
the neighboring tests, so the wait happens only when sync_slot itself
is being created.
2) Add a note() after wait_for_event(), as in the other tests, so the
test output shows when the sync is paused at the injection point.

Suggestion:

--- a/src/test/recovery/t/051_effective_wal_level.pl
+++ b/src/test/recovery/t/051_effective_wal_level.pl
@@ -617,11 +617,12 @@ select pg_sync_replication_slots();
qr/sync_slots/,
q(\echo sync_slots
select injection_points_set_local();
-select injection_points_attach('replication-slot-create-begin', 'wait');
+select injection_points_attach('replication-slot-create-begin',
'wait', 'sync_slot');
select pg_sync_replication_slots();
));
$standby5->wait_for_event('client backend',
'replication-slot-create-begin');
+ note("injection_point 'replication-slot-create-begin' is reached");

# Drop and re-create the slot, and wait for the standby to replay both
# the deactivation and the activation.

--
Thanks,
Nisha

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias van de Meent 2026-10-01 11:17:02 Re: [PATCH] Report no unpinned buffers as insufficient resources
Previous Message vignesh C 2026-10-01 10:53:20 Re: Publication DDL can race with a concurrent UPDATE