MIME-Version: 1.0
References: <CABPTF7Xs-64GQNjmbimZNhj2YSKbBny+evz6=cp3X2fkJS+vMQ@mail.gmail.com>
 <202601011659.ikh4ku4p3ovb@alvherre.pgsql> <CAPpHfduDVNo4VXgnQFZUg9=2yHQJfUUqjokbi3qVxuJiKNfcwg@mail.gmail.com>
 <CABPTF7UkwQZGx5ub731Q+=+rU8yx4ruqMdDt__L_dm9_32LsMw@mail.gmail.com>
 <CAPpHfds-KiZRuCruc0jHxLSxLqzKcHJGwOFFA0b_RgaJvtUOEQ@mail.gmail.com> <CABPTF7Vy4A0S0W7=B-fVd9Bo_15XG_FRYfKUF2CB_i=5svwEZQ@mail.gmail.com>
In-Reply-To: <CABPTF7Vy4A0S0W7=B-fVd9Bo_15XG_FRYfKUF2CB_i=5svwEZQ@mail.gmail.com>
From: Thomas Munro <thomas.munro@gmail.com>
Date: Tue, 6 Jan 2026 18:42:59 +1300
Message-ID: <CA+hUKG+L0OQR8dQtsNBSaA3FNNyQeFabdeRVzurm0b7Xtp592g@mail.gmail.com>
Subject: Re: Implement waiting for wal lsn replay: reloaded
To: Xuneng Zhou <xunengzhou@gmail.com>
Cc: Alexander Korotkov <aekorotkov@gmail.com>, =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>, 
	Chao Li <li.evan.chao@gmail.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>, 
	Andres Freund <andres@anarazel.de>, Michael Paquier <michael@paquier.xyz>, 
	jian he <jian.universality@gmail.com>, Tomas Vondra <tomas@vondra.me>, 
	Yura Sokolov <y.sokolov@postgrespro.ru>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CA%2BhUKG%2BL0OQR8dQtsNBSaA3FNNyQeFabdeRVzurm0b7Xtp592g%40mail.gmail.com>
Precedence: bulk

Could this be causing the recent flapping failures on CI/macOS in
recovery/031_recovery_conflict?  I didn't have time to dig personally
but f30848cb looks relevant:

Waiting for replication conn standby's replay_lsn to pass 0/03467F58 on primary
error running SQL: 'psql:<stdin>:1: ERROR:  canceling statement due to
conflict with recovery
DETAIL:  User was or might have been using tablespace that must be dropped.'
while running 'psql --no-psqlrc --no-align --tuples-only --quiet
--dbname port=25195
host=/var/folders/g9/7rkt8rt1241bwwhd3_s8ndp40000gn/T/LqcCJnsueI
dbname='postgres' --file - --variable ON_ERROR_STOP=1' with sql 'WAIT
FOR LSN '0/03467F58' WITH (MODE 'standby_replay', timeout '180s',
no_throw);' at /Users/admin/pgsql/src/test/perl/PostgreSQL/Test/Cluster.pm
line 2300.

https://cirrus-ci.com/task/5771274900733952

The master branch in time-descending order, macOS tasks only:

     task_id      | substring |  status
------------------+-----------+-----------
 6460882231754752 | c970bdc0  | FAILED
 5771274900733952 | 6ca8506e  | FAILED
 6217757068361728 | 63ed3bc7  | FAILED
 5980650261446656 | ae283736  | FAILED
 6585898394976256 | 5f13999a  | COMPLETED
 4527474786172928 | 7f9acc9b  | COMPLETED
 4826100842364928 | e8d4e94a  | COMPLETED
 4540563027918848 | b9ee5f2d  | FAILED
 6358528648019968 | c5af141c  | FAILED
 5998005284765696 | e212a0f8  | COMPLETED
 6488580526178304 | b85d5dc0  | FAILED
 5034091344560128 | 7dc95cc3  | ABORTED
 5688692477526016 | bb048e31  | COMPLETED
 5481187977723904 | d351063e  | COMPLETED
 5101831568752640 | f30848cb  | COMPLETED <-- the change
 6395317408497664 | 3f33b63d  | COMPLETED
 6741325208354816 | 877ae5db  | COMPLETED
 4594007789010944 | de746e0d  | COMPLETED
 6497208998035456 | 461b8cc9  | COMPLETED