replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist - Mailing list pgsql-general

From Avi Weinberg
Subject replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
Date
Msg-id DB9PR07MB7180909CEAA22BF40F04FF60CB0F2@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
Responses replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist
List pgsql-general

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.

pgsql-general by date:

Previous
From: Madalin Ignisca
Date:
Subject: Re: constant crashing hardware issue and thank you TAKE AWAY
Next
From: Avi Weinberg
Date:
Subject: replication slot "pg_1015733_sync_1014718_7358407382484881476" does not exist