Add wait_for_subscription_sync for TAP tests.

Amit Kapila <akapila@postgresql.org>

Commit: 0c20dd33db1607d6a85ffce24238c1e55e384b49
Author: Amit Kapila <akapila@postgresql.org>
Date: 2022-08-03T10:01:17Z
Releases: 16.0
Add wait_for_subscription_sync for TAP tests.

The TAP tests for logical replication in src/test/subscription are using
the following code in many places to make sure that the subscription is
synchronized with the publisher:

  $node_publisher->wait_for_catchup('tap_sub');
  $node_subscriber->poll_query_until('postgres',
    qq[SELECT count(1) = 0
       FROM pg_subscription_rel
       WHERE srsubstate NOT IN ('r', 's')]);

The new function wait_for_subscription_sync() can be used to replace the
above code. This eliminates duplicated code and makes it easier to write
future tests.

Author: Masahiko Sawada
Reviewed by: Amit Kapila, Shi yu
Discussion: https://postgr.es/m/CAD21AoC-fvAkaKHa4t1urupwL8xbAcWRePeETvshvy80f6WV1A@mail.gmail.com

Files

PathChange+/−
src/test/perl/PostgreSQL/Test/Cluster.pm modified +44 −0
src/test/subscription/t/001_rep_changes.pl modified +4 −14
src/test/subscription/t/002_types.pl modified +1 −6
src/test/subscription/t/004_sync.pl modified +5 −13
src/test/subscription/t/005_encoding.pl modified +2 −7
src/test/subscription/t/006_rewrite.pl modified +2 −7
src/test/subscription/t/007_ddl.pl modified +2 −7
src/test/subscription/t/008_diff_schema.pl modified +3 −9
src/test/subscription/t/010_truncate.pl modified +2 −6
src/test/subscription/t/011_generated.pl modified +1 −4
src/test/subscription/t/013_partition.pl modified +6 −14
src/test/subscription/t/014_binary.pl modified +1 −4
src/test/subscription/t/015_stream.pl modified +2 −7
src/test/subscription/t/016_stream_subxact.pl modified +2 −7
src/test/subscription/t/017_stream_ddl.pl modified +2 −7
src/test/subscription/t/018_stream_subxact_abort.pl modified +2 −7
src/test/subscription/t/019_stream_subxact_ddl_abort.pl modified +2 −7
src/test/subscription/t/021_twophase.pl modified +4 −14
src/test/subscription/t/023_twophase_stream.pl modified +2 −8
src/test/subscription/t/024_add_drop_pub.pl modified +3 −15
src/test/subscription/t/025_rep_changes_for_schema.pl modified +5 −13
src/test/subscription/t/027_nosuperuser.pl modified +2 −7
src/test/subscription/t/028_row_filter.pl modified +4 −15
src/test/subscription/t/029_on_error.pl modified +1 −4
src/test/subscription/t/030_origin.pl modified +4 −15
src/test/subscription/t/031_column_list.pl modified +18 −32
src/test/subscription/t/100_bugs.pl modified +3 −11

Discussion