Date: Wed, 12 Jan 2022 19:24:25 +0800
From: Julien Rouhaud <rjuju123@gmail.com>
To: Michail Nikolaev <michail.nikolaev@gmail.com>
Cc: Pavel Borisov <pashkin.elfe@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Stream replication test fails of cfbot/windows server 2019
Message-ID: <20220112112425.pgzymqcgdy62e7m3@jrouhaud>
References: <CALT9ZEG=C=JSypzt2gz6NoNtx-ew2tYHbwiOfY_xNo+yBY_=jw@mail.gmail.com>
 <CANtu0oiQ+KSDZba3_AAhDB9H1cuFut4ZsHb-E4cTedOqGwDmVw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <CANtu0oiQ+KSDZba3_AAhDB9H1cuFut4ZsHb-E4cTedOqGwDmVw@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/20220112112425.pgzymqcgdy62e7m3%40jrouhaud>
Precedence: bulk

On Wed, Jan 12, 2022 at 01:51:24PM +0300, Michail Nikolaev wrote:
> Hello.
> 
> Looks like logical replication also affected:
> 
> [08:26:35.599] # poll_query_until timed out executing this query:
> [08:26:35.599] # SELECT count(1) = 0 FROM pg_subscription_rel WHERE
> srsubstate NOT IN ('r', 's');
> [08:26:35.599] # expecting this output:
> [08:26:35.599] # t
> [08:26:35.599] # last actual query output:
> [08:26:35.599] # f
> 
> https://cirrus-ci.com/task/6532060239101952
> https://cirrus-ci.com/task/4755551606276096

Indeed, and yet CI on postgres tree doesn't exhibit any problem:
https://cirrus-ci.com/github/postgres/postgres