From: Avi Weinberg <AviW@gilat.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: replication slot "pg_1015733_sync_1014718_7358407382484881476" does
 not exist
Thread-Topic: replication slot "pg_1015733_sync_1014718_7358407382484881476"
 does not exist
Thread-Index: AdqQ17K0Ay+cdCGGSryxnQAhKS6Xcg==
Date: Wed, 17 Apr 2024 15:01:19 +0000
Message-ID:
 <DB9PR07MB7180909CEAA22BF40F04FF60CB0F2@DB9PR07MB7180.eurprd07.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?jLF4vE+hbyTTBVqtSUgtDgBz6K4I5Vk7Pg/7FjmOZheZ+q6/jYzGe0Vg96xc?=
 =?us-ascii?Q?hjU/7vGoAUrqFd8Jyr3iv+szbkYpNQ8bVLUMyyUNz7/8HJLEgNdteNAfCuUq?=
 =?us-ascii?Q?FozEtDFHd3Lw2Fje4nuyeHYnNe7kTZ+VJz9P1kNiQ91PkLXc//jblplpThtW?=
 =?us-ascii?Q?ZABZsgmWit+DgL9q3Z75Y7rhlfGfYs7EJOHzj8ZQsAG224t+SwgPpLd8TUWG?=
 =?us-ascii?Q?HpQZBjW9By+pKioJCJvePJjeVma+48oQPADJakGsTsvSo47EKKDOLk7gaMzy?=
 =?us-ascii?Q?+6HzunnLHvRgh/pHBf4nGW/WRPMsndN6UCNwB1TW9/RyHQ4Y74bbLIV4+1oS?=
 =?us-ascii?Q?93uO6A9sx2LHHEI1S2i7vCyYGUDNjOkx1raUvRQpWzN9dab0GFo2K09fCyFu?=
 =?us-ascii?Q?AP9HjRWeWHr/VLuOt4lNhSh9b55U+8HS7Ld6u4A+RiGk9xdiUdMXGPffTsZx?=
 =?us-ascii?Q?gYnx7klwm58leFbAlJK21zqKPe3lZMmOnQLSTNmKn7nM70Y0l1/iOA08vKn8?=
 =?us-ascii?Q?8xP7FcvZio5muQznVneRlne+PqI7ULnTw50Onp7m/A/igODHYCmBFU0aOc7H?=
 =?us-ascii?Q?CYAh7V9i3D1BoU9wqDFt6GvLdpduICnOocj895ATPMfc6dQ7YnkyTn/HWJGp?=
 =?us-ascii?Q?z7G8FeVpc5EUP5gHD5zX1Tv2ZNlcwdw+13cepUvxF5HkonNMnAdJi5Oxl/Ve?=
 =?us-ascii?Q?jRhOE/1/pZggu7A/2Km7+mpnpQBEFrsobzaqCdIDNX/TeRnFSwfLVcLoov0J?=
 =?us-ascii?Q?Xoqksh6NEQxKFWTfUCB3m1HeNIIWz4pqzvsecvBom6xEqgP500PKa/cyrTDL?=
 =?us-ascii?Q?DB1bwFCo/9rB9UyJEtonwOf8EYuZCixMd6z8k14sJmr0gMnQtB5K9+DR1Noj?=
 =?us-ascii?Q?VvxUKrUOLgmpuUKLBOcUNPeHh9FBYY3oexk0O+Y2t5tt05MkzIuP3kDke65s?=
 =?us-ascii?Q?1Wf2Vr7e2nZPkHdxPZVeeyqHZNk2iprubsjYYuZT6S7cLljpitoHPMWYHrfj?=
 =?us-ascii?Q?LzHOwnxLq9Hffpwa1jxw49PL/jbIQKMwLMTYi/ZttmTny1+UQH1J0/XwvAAg?=
 =?us-ascii?Q?2KOKjycwL0ydQeaYWVJDi9k4bGgbW0vIzn3AJO4dWw8uDtYRMShU1+zobr8D?=
 =?us-ascii?Q?1grbyqbyATfwnA9KmYJzid+H2gL7Tb+GH6TxSJxJHsXDL9gr6nQN6MehqRWH?=
 =?us-ascii?Q?eIST0RBW4RUSdAuVAZPkEr5AHFz+VWPHZmk4G4/R7SL32V70wfhfJkvF3QTN?=
 =?us-ascii?Q?dZOI/BVD3c6NmC7vlhf+w1jUH46y6Ze/EerLO8KgDqzJPaUKH0eS+b2smHSk?=
 =?us-ascii?Q?rYDG0Wpn+dgXPKw+6cwYA/HKbj0ReP+O4RHVup5dAASdwkcW8kX3SG+5tain?=
 =?us-ascii?Q?7xUsyPV9Kqk+cL9cHNrK3L69+6Sm0xmr4/AOBjfXy0BRFjviX8ix8X05D5Df?=
 =?us-ascii?Q?WIzTa38d12hPUC+BNA589SZA8KfKib82hjxPMC4QSDfXiVgbfDrI3p6ND0IE?=
 =?us-ascii?Q?GMSePa0IDDVfh04YbTZpkEUqFjOAmzAtcS/Byu5aME2ZHqfPiuaWTEwoOtTZ?=
 =?us-ascii?Q?rxTm+jU5FyXo/33iLm0=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DB9PR07MB7180909CEAA22BF40F04FF60CB0F2DB9PR07MB7180eurp_"
MIME-Version: 1.0
X-OriginatorOrg: gilat.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB9PR07MB7180.eurprd07.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 282c00f8-34a5-43be-1dcf-08dc5eef3ce7
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Apr 2024 15:01:19.1395
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7300b1a3-573a-4010-92a6-1c65cd85e927
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: CR2OBpWYohquYv9ntjQXPI1MnZdosJBKjarxa6eaEI2NzeePC+svuTTyL7rr8EqW
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM9PR07MB7859
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/DB9PR07MB7180909CEAA22BF40F04FF60CB0F2%40DB9PR07MB7180.eurprd07.prod.outlook.com>
Precedence: bulk

--_000_DB9PR07MB7180909CEAA22BF40F04FF60CB0F2DB9PR07MB7180eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Experts,

For a second time in the past few months I'm getting the following errors i=
n Postgres log.  Last time it was solved when I reset all Postgres pods.  N=
ow 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_73584073824848814=
76 WAIT
ERROR:  replication slot "pg_1015733_sync_1014956_7358407382484881476" does=
 not exist
STATEMENT:  DROP_REPLICATION_SLOT pg_1015733_sync_1014956_73584073824848814=
76 WAIT
192 ERROR:  replication slot "pg_927671_sync_927281_7358103111795036228" do=
es 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 exi=
st
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 privileg=
ed. If you are not the intended recipient, please inform the sender immedia=
tely and delete this email: you should not copy or use this e-mail for any =
purpose nor disclose its contents to any person.

--_000_DB9PR07MB7180909CEAA22BF40F04FF60CB0F2DB9PR07MB7180eurp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	text-align:right;
	direction:rtl;
	unicode-bidi:embed;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">Hi Experts,<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">For a second time in the past few months I'm getting the following e=
rrors in Postgres log.&nbsp; Last time it was solved when I reset all Postg=
res pods.&nbsp; Now reset no longer helps.&nbsp; Logical
 replication is now working even after I performed the reset.<o:p></o:p></p=
>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">Any ideas what is wrong?<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">ERROR:&nbsp; replication slot &quot;pg_1015733_sync_1014718_73584073=
82484881476&quot; does not exist<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">STATEMENT:&nbsp; DROP_REPLICATION_SLOT pg_1015733_sync_1014718_73584=
07382484881476 WAIT<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">ERROR:&nbsp; replication slot &quot;pg_1015733_sync_1014956_73584073=
82484881476&quot; does not exist<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">STATEMENT:&nbsp; DROP_REPLICATION_SLOT pg_1015733_sync_1014956_73584=
07382484881476 WAIT<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span dir=3D"RTL"></span><span dir=3D"RTL"></span><span lang=3D"HE" =
dir=3D"RTL" style=3D"font-family:&quot;Arial&quot;,sans-serif"><span dir=3D=
"RTL"></span><span dir=3D"RTL"></span>192
</span>ERROR:&nbsp; replication slot &quot;pg_927671_sync_927281_7358103111=
795036228&quot; does not exist<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">START_REPLICATION SLOT &quot;pg_927671_sync_927281_73581031117950362=
28&quot; LOGICAL 0/AC888F00 (proto_version '3', publication_names '&quot;aa=
a&quot;,&quot;bbb&quot;')<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">replication slot &quot;pg_1015733_sync_1015375_7358407382484881476&q=
uot; does not exist<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">DROP_REPLICATION_SLOT pg_1015733_sync_1015375_7358407382484881476 WA=
IT<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">Thanks<o:p></o:p></p>
</div>
IMPORTANT - This email and any attachments is intended for the above named =
addressee(s), and may contain information which is confidential or privileg=
ed. If you are not the intended recipient, please inform the sender immedia=
tely and delete this email: you
 should not copy or use this e-mail for any purpose nor disclose its conten=
ts to any person.
</body>
</html>

--_000_DB9PR07MB7180909CEAA22BF40F04FF60CB0F2DB9PR07MB7180eurp_--