pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

add additional sync finish condition check to fix infinite catchup status

Open woonhak opened this issue 1 year ago • 0 comments

If sync process synced very closely to the their remote, there is a possibility that no commit since the starting LSN point. If that is the case, apply worker is infinitely waiting for sync worker finished, but sync worker also is waiting for new commit to finish catching up state even if sync worker synced all of the log record from remote. This randomly happened while running add_table test when alter_subscription_resynchronize_table() called and wait for complete sync. To address that issue, we can evaluate sync finish condition while pulling log records.

woonhak avatar Nov 22 '23 00:11 woonhak