Обсуждение: Tables get stuck at srsubstate = f
Hi all,
I'm using logical replication with Postgres 15.2.
When creating logical replication on multiple tables, sometimes the initial sync get stuck for few tables at state srsubstate = f. If I recreate the logical replication again, it may get stuck at srsubstate = f for other tables, so it does not seems to be table specific. If course, in the majority of cases, building the logical replication succeed and all tables are showing srsubstate = r.
What might be the reason that logical replication get stuck during initial sync at srsubstate =f?
We use this view pg_stat_progress_copy to monitor initial sync. Is it possible that calling this frequently during initial sync causes some lock not to be released?
Is it a Postgres bug?
Thanks!