pg_logicalinspect: Stabilize isolation tests.
authorMasahiko Sawada <msawada@postgresql.org>
Tue, 11 Mar 2025 16:30:00 +0000 (09:30 -0700)
committerMasahiko Sawada <msawada@postgresql.org>
Tue, 11 Mar 2025 16:30:00 +0000 (09:30 -0700)
commita49927f04cd0c66e1bc41f551160fce50f382d8c
treefd16c27c2ce4e061faa42934b22723902361662c
parent8b1b342544b69b281ffd3aafe594aec629ec4d3c
pg_logicalinspect: Stabilize isolation tests.

The previous isolation tests did not account for the possibility that
the background writer or the checkpointer could write a RUNNING_XACTS
record, which could cause logical decoding to produce more logical
snapshots than expected.

This commit modifies the isolation tests to verify that at least one
logical snapshot contains the expected number of committed or ongoing
catalog-change transactions.

Per buildfarm member skink.

Reported-by: Andres Freund <andres@anarazel.de>
Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Reviewed-by: Masahiko Sawada <sawada.mshk@gmail.com>
Discussion: https://postgr.es/m/5qbxud4pvnvmtuoi7weiizm5hmumxaeohx4vztfhrwlfhyz6rj@buh4435mllwo
contrib/pg_logicalinspect/expected/logical_inspect.out
contrib/pg_logicalinspect/specs/logical_inspect.spec