Commit0324651

Amit Kapila

committed

Fix the test case introduced by commit8756930.

Before dropping a relation, ensure that it has reached a 'ready' stateafter initial synchronization.Author: Vignesh CReviewed-By: Amit KapilaDiscussion:https://www.postgresql.org/message-id/CALDaNm0gwjY_4HFxvvty01BOT01q_fJLKQ3pWP9=9orqubhjcQ@mail.gmail.com

1 parent8756930 commit0324651Copy full SHA for 0324651

File tree

-1

lines changed

-1

lines changed

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -195,7 +195,13 @@`
`195`	`195`	`"Refresh publication when the publisher has subscribed for the new table, but the subscriber-side wants origin = none"`
`196`	`196`	`);`
`197`	`197`
`198`		`-$node_A->wait_for_subscription_sync($node_B,$subname_AB2);`
	`198`	`+# Ensure that relation has reached 'ready' state before we try to drop it`
	`199`	`+my$synced_query =`
	`200`	`+"SELECT count(1) = 0 FROM pg_subscription_rel WHERE srsubstate NOT IN ('r');";`
	`201`	`+$node_A->poll_query_until('postgres',$synced_query)`
	`202`	`+ordie"Timed out while waiting for subscriber to synchronize data";`
	`203`	`+`
	`204`	`+$node_B->wait_for_catchup($subname_AB2);`
`199`	`205`
`200`	`206`	`# clear the operations done by this test`
`201`	`207`	`$node_A->safe_psql('postgres',"DROP TABLE tab_new");`

Comments

(0)