Tables get stuck at srsubstate = f
От | Avi Weinberg |
---|---|
Тема | Tables get stuck at srsubstate = f |
Дата | |
Msg-id | DB9PR07MB71805B7673176FA26D81ABC2CBFA2@DB9PR07MB7180.eurprd07.prod.outlook.com обсуждение исходный текст |
Список | pgsql-general |
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!
В списке pgsql-general по дате отправления: