Re: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled
Date
Msg-id CAA4eK1Lbimmi5MnLtm9vtz2UrFZGZ6JKBt7ATL_KeAuqVK=8yA@mail.gmail.com
Whole thread Raw
In response to Re: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled  (Michael Paquier <michael@paquier.xyz>)
Responses RE: Fix src/test/subscription/t/029_on_error.pl test when wal_debug is enabled
List pgsql-hackers
On Fri, May 17, 2024 at 5:25 AM Michael Paquier <michael@paquier.xyz> wrote:
>
> On Thu, May 16, 2024 at 09:00:47AM +0530, Amit Kapila wrote:
> > This can only be a problem if the apply worker generates more LOG
> > entries with the required context but it won't do that unless there is
> > an operation on the publisher to replicate. If we see any such danger
> > then I agree this can break on some slow machines but as of now, I
> > don't see any such race condition.
>
> Perhaps, still I'm not completely sure if this assumption is going to
> always stand for all the possible configurations we support.
>

As per my understanding, this will primarily rely on the apply worker
design, not the other configurations, whether we see additional LOG.

>  So,
> rather than coming back to this test again, I would choose to make the
> test as stable as possible from the start.  That's what mapping with
> the error message would offer when grabbing the LSN from the CONTEXT
> part of it, because there's a one-one mapping between the expected
> ERROR and its CONTEXT from which the information used by the test is
> retrieved.
>

I was slightly hesitant to do an ERROR string-based check because the
error string can change and it doesn't seem to bring additional
stability for this particular test. But if you and others are still
not convinced with the simple fix suggested by me then feel free to
proceed with an error-string based check.

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Shlok Kyal
Date:
Subject: Re: speed up a logical replica setup
Next
From: Thom Brown
Date:
Subject: Re: PostgreSQL 17 Beta 1 release announcement draft