]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix stale COPY progress during logical replication table sync
authorFujii Masao <fujii@postgresql.org>
Wed, 13 May 2026 02:44:31 +0000 (11:44 +0900)
committerFujii Masao <fujii@postgresql.org>
Wed, 13 May 2026 02:46:21 +0000 (11:46 +0900)
commitb5f7e7569c09ca31c0da94ead44985550cf68b30
tree0b0e5366baf2d21a25a6728ec48cc203b6ef9ae2
parentd8d46710cdbb0b0cfb9a8d614b7e8937297aff58
Fix stale COPY progress during logical replication table sync

Previously, pg_stat_progress_copy in the subscriber could continue to show
the initial COPY operation for logical replication table synchronization as
active even after the data copy had finished. The stale progress entry
remained visible until synchronization caught up with the publisher.

This happened because the table synchronization code called BeginCopyFrom()
and CopyFrom(), but failed to call EndCopyFrom() afterward.

This commit fixes the issue by adding the missing EndCopyFrom() call so that
the COPY progress state in the subscriber is cleared as soon as the initial
data copy completes.

Backpatch to all supported branches.

Author: Shinya Kato <shinya11.kato@gmail.com>
Reviewed-by: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: ChangAo Chen <cca5507@qq.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/CAOzEurQKuy3RiPkd=25PEwEzaqHuGvEOf=X7vaVzhgNjaukYzA@mail.gmail.com
Backpatch-through: 14
src/backend/replication/logical/tablesync.c