public inbox for [email protected]
help / color / mirror / Atom feedFrom: Avi Weinberg <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
Date: Wed, 17 Apr 2024 15:16:58 +0000
Message-ID: <DB9PR07MB718064E2862005880E0F6383CB0F2@DB9PR07MB7180.eurprd07.prod.outlook.com> (raw)
In-Reply-To: <DB9PR07MB7180909CEAA22BF40F04FF60CB0F2@DB9PR07MB7180.eurprd07.prod.outlook.com>
References: <DB9PR07MB7180909CEAA22BF40F04FF60CB0F2@DB9PR07MB7180.eurprd07.prod.outlook.com>
Fixed a typo...
Hi Experts,
For a second time in the past few months I'm getting the following errors in Postgres log. Last time it was solved when I reset all Postgres pods. Now reset no longer helps. Logical replication is not working even after I performed the reset.
Any ideas what is wrong?
From: Avi Weinberg <[email protected]>
Sent: Wednesday, April 17, 2024 6:01 PM
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: [External] replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
Hi Experts,
For a second time in the past few months I'm getting the following errors in Postgres log. Last time it was solved when I reset all Postgres pods. Now reset no longer helps. Logical replication is now working even after I performed the reset.
Any ideas what is wrong?
ERROR: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
STATEMENT: DROP_REPLICATION_SLOT pg_1015733_sync_1014718_7358407382484881476 WAIT
ERROR: replication slot "pg_1015733_sync_1014956_7358407382484881476" does not exist
STATEMENT: DROP_REPLICATION_SLOT pg_1015733_sync_1014956_7358407382484881476 WAIT
192 ERROR: replication slot "pg_927671_sync_927281_7358103111795036228" does not exist
START_REPLICATION SLOT "pg_927671_sync_927281_7358103111795036228" LOGICAL 0/AC888F00 (proto_version '3', publication_names '"aaa","bbb"')
replication slot "pg_1015733_sync_1015375_7358407382484881476" does not exist
DROP_REPLICATION_SLOT pg_1015733_sync_1015375_7358407382484881476 WAIT
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.
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.
view thread (3+ messages) latest in thread
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: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
In-Reply-To: <DB9PR07MB718064E2862005880E0F6383CB0F2@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