public inbox for [email protected]
help / color / mirror / Atom feedFrom: Avi Weinberg <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Tables get stuck at srsubstate = f
Date: Thu, 6 Jun 2024 16:38:39 +0000
Message-ID: <DB9PR07MB71805B7673176FA26D81ABC2CBFA2@DB9PR07MB7180.eurprd07.prod.outlook.com> (raw)
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!
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Tables get stuck at srsubstate = f
In-Reply-To: <DB9PR07MB71805B7673176FA26D81ABC2CBFA2@DB9PR07MB7180.eurprd07.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox