diff options
| author | Amit Kapila <akapila@postgresql.org> | 2024-07-31 08:53:55 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2024-07-31 08:53:55 +0530 |
| commit | 0dcea330babd46402f6ca3ea3a552829c99bbe5e (patch) | |
| tree | eb4031df25238e878c377eda0262d6b87b72a3f5 /src | |
| parent | 679c5084cf210c6e958276b657039e8ba0c077c0 (diff) | |
| download | postgresql-0dcea330babd46402f6ca3ea3a552829c99bbe5e.tar.gz postgresql-0dcea330babd46402f6ca3ea3a552829c99bbe5e.zip | |
Fix random failure in 021_twophase.
After disabling the subscription, the failed test was changing the
two_phase option for the subscription. We can't change the two_phase
option for a subscription till the corresponding apply worker is active.
The check to ensure that the replication apply worker has exited was
incorrect.
Author: Vignesh C
Discussion: https://postgr.es/m/CALDaNm3YY+bzj+JWJbY+DsUgJ2mPk8OR1ttjVX2cywKr4BUgxw@mail.gmail.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/subscription/t/021_twophase.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/subscription/t/021_twophase.pl b/src/test/subscription/t/021_twophase.pl index a47d3b7dd6e..5e50f1af338 100644 --- a/src/test/subscription/t/021_twophase.pl +++ b/src/test/subscription/t/021_twophase.pl @@ -385,7 +385,7 @@ is($result, qq(t), 'two-phase is enabled'); $node_subscriber->safe_psql('postgres', "ALTER SUBSCRIPTION tap_sub_copy DISABLE;"); $node_subscriber->poll_query_until('postgres', - "SELECT count(*) = 0 FROM pg_stat_activity WHERE backend_type = 'logical replication worker'" + "SELECT count(*) = 0 FROM pg_stat_activity WHERE backend_type = 'logical replication apply worker'" ); $node_subscriber->safe_psql( 'postgres', " @@ -434,7 +434,7 @@ is($result, qq(0), 'should be no prepared transactions on subscriber'); $node_subscriber->safe_psql('postgres', "ALTER SUBSCRIPTION tap_sub_copy DISABLE;"); $node_subscriber->poll_query_until('postgres', - "SELECT count(*) = 0 FROM pg_stat_activity WHERE backend_type = 'logical replication worker'" + "SELECT count(*) = 0 FROM pg_stat_activity WHERE backend_type = 'logical replication apply worker'" ); $node_subscriber->safe_psql( 'postgres', " |