Re: pgsql: Stablize tests added in 3abe9dc188.

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Amit Kapila <akapila(at)postgresql(dot)org>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Stablize tests added in 3abe9dc188.
Date: 2025-03-28 11:50:53
Message-ID: CAA4eK1J0ZYk5500+pJs9MjhwEMphCrEXuhmgkitjn+bTN7vGZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Fri, Mar 28, 2025 at 11:18 AM Amit Kapila <akapila(at)postgresql(dot)org> wrote:
>
> Stablize tests added in 3abe9dc188.
>
> The problem is that after the ALTER SUBSCRIPTION tap_sub SET PUBLICATION
> command, we didn't wait for the new walsender to start on the publisher.
> Immediately after ALTER, we performed Insert and expected it to replicate.
> However, the replication could start from a point after the INSERT location,
> and as the subscription isn't copying initial data, we could miss such an
> Insert.
>
> The fix is to wait for connection to be established between publisher and
> subscriber before starting DML operations that are expected to replicate.
>
> As per CI.
>
> Reported-by: Andres Freund <andres(at)anarazel(dot)de>
> Author: Hayato Kuroda <kuroda(dot)hayato(at)fujitsu(dot)com>
> Discussion: https://postgr.es/m/CALDaNm2ms1deM5EYNLFEfESv_Kw=Y4AiTB0LP=qGS-UpFwGbPg@mail.gmail.com
>

By mistake, I added a wrong discussion link. The correct one is
https://postgr.es/m/ksxbayuk5hgqdsryjxqkbnjyvk6amd2jf5tui565ex6vazglls@jva4njirno4u

--
With Regards,
Amit Kapila.

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2025-03-28 12:54:29 pgsql: Add support for not-null constraints on virtual generated column
Previous Message Peter Eisentraut 2025-03-28 09:51:46 pgsql: Modernize some code a bit