Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rx723-006RtW-43 for pgsql-general@arkaria.postgresql.org; Wed, 17 Apr 2024 15:17:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rx721-00CKo6-Ef for pgsql-general@arkaria.postgresql.org; Wed, 17 Apr 2024 15:17:05 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rx721-00CKny-0f for pgsql-general@lists.postgresql.org; Wed, 17 Apr 2024 15:17:05 +0000 Received: from mail-db5eur01on2137.outbound.protection.outlook.com ([40.107.15.137] helo=EUR01-DB5-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rx71x-001ThF-Cx for pgsql-general@lists.postgresql.org; Wed, 17 Apr 2024 15:17:04 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Zh87n42ql3h1ZIPBCvQ6eaassRGQJPk4zIQWWHaTREsfk6jpilvwVUaVGV0SfUNCBLxoZ0IDE/2r6HaX/JIahd0pp9/UzNIE8Pr3WckWVdd4ZVz9hxrRXn9YdPn5ypzc2Y17Py0B9yzW5ZaeAW8tf2j2TtfF+nOQSbfy/WSIJglMR7kDRwimfn5V7A/SEpUnbcoWBLdX6Bs/6KiT8xn4WJww+Izq04ExPkkVndl+olGwuebo0osW9F+LKd2pLzMaGlmbnwEjDW5KQHcY5lahxtsP8XYUZdykEYAtXx/waHiWaDsFE6gmrGuMnGvJ+jzyHeNQc+OIU3NUDP2TQ5zewg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=LhazcQMYD+dG55JJWVCSRC4Uc2gvaRHOHPrTmViOOQ4=; b=Wq/1+t9aqnsIACl+MqU6xN9xn0nn/AXO2kQj1eBzSp9f04pStrySTPHrdPWPcRZhdwxSa77oxD+ChLjtDYw1xsU5pXqwJxgYlIqQz95tByfSGq/g/2mMC1jxV0WTlgaz2p2ZukTWI6cL4jhegQ3NpDE+1feRoTpyNS/rgHl6NrmLzZ05YU44O7O5MKZkvUVUn7b7L1yzMly1V+A/XKktToL6jsK9uRY7VgkKsR7JVe/EHtQJZkz9WvBrBOLvk5VIWQsZhfOrdDAe2Vg+/rFMqs2RqB9796ef0TPqOsw3qt49QKDaVOHm0CfNqgjbQtOCfJwqvLPQpXR4waf603gJlQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=gilat.com; dmarc=pass action=none header.from=gilat.com; dkim=pass header.d=gilat.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gilat.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=LhazcQMYD+dG55JJWVCSRC4Uc2gvaRHOHPrTmViOOQ4=; b=0lUPBWJnQfzWAs3QZ6y6QccXV9w8WQ96F33I96TSNbILhXL+yy2H0s+DbJO2Utmt+bkmTUpu7P5ML+vD//U7WNV7bp6NvSoHFhkX/bOT1QhPubuz+Sn4wRDGmVgR3SmeHvegyEVjsxLl/TMwvjLjVIFIWM8FD/I7boCfzoOG3b0= Received: from DB9PR07MB7180.eurprd07.prod.outlook.com (2603:10a6:10:215::5) by AS1PR07MB8504.eurprd07.prod.outlook.com (2603:10a6:20b:4db::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7472.37; Wed, 17 Apr 2024 15:16:58 +0000 Received: from DB9PR07MB7180.eurprd07.prod.outlook.com ([fe80::2133:1fce:d4ce:454b]) by DB9PR07MB7180.eurprd07.prod.outlook.com ([fe80::2133:1fce:d4ce:454b%7]) with mapi id 15.20.7472.037; Wed, 17 Apr 2024 15:16:58 +0000 From: Avi Weinberg To: pgsql-generallists.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+cdCGGSryxnQAhKS6XcgAApbIw Date: Wed, 17 Apr 2024 15:16:58 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=gilat.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB9PR07MB7180:EE_|AS1PR07MB8504:EE_ x-ms-office365-filtering-correlation-id: a52ddcad-0838-4496-3264-08dc5ef16cc9 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: =?us-ascii?Q?7y5hCTGSWZByB7Ii0RNqjzGQHV6JhX6wFlxCI1yhfUWq1Fhi2A1BVLVDO+5v?= =?us-ascii?Q?Sz0smHg9sUqHprqVIM12rYNsBcehy6kZATE7ezVEoy5KFdeBxuA4ln+5NM9y?= =?us-ascii?Q?X/cXpskG2GsJYsfDCavtOLd4yoPeNl+KCNerILlsgCMmzOhf6S2nMGA/Ibms?= =?us-ascii?Q?yCy1Yja/gDK4o1+n2HjJqEkv7zWL1F738wiFgdhxoEvVcGSKpfj7XxM6hMln?= =?us-ascii?Q?GPweMFAxC3RIVIkWenPT903ar339TC8MtvRwER02mn+wIPxQ6xAIPJH2+Roa?= =?us-ascii?Q?aeExrVrYkWKaGYXP9mgzY82RsPy4H0K9Xr3eNWHX01sNjLCIuLFySbHlwHuH?= =?us-ascii?Q?mP4VdFG2H2U4j/VsdhV2vSRZuiC9ifLWOU2KpXpV4x4lGyi2pLMYgEBTl/Mk?= =?us-ascii?Q?mM5k4/kNRn6PFGzZglW8PqLbUW+X0k9t7Ltv10hLE5xf8hIFHAVphxP9TE+D?= =?us-ascii?Q?Ewp2ELTV4FmmKBTp0Dqu2bZOa5c4FsYLlQL5xNWpNhPCVJ2x58iAkpWtqEdD?= =?us-ascii?Q?YGx6E93u66Gg12o8fh5IegmsAKPCj6rAgeXL5tmdftp2uCqWlLYt5ADSgHYy?= =?us-ascii?Q?8bixXpn+UcLY6j/Q56tSk5KVlLOalfd+SGLNy0ZPWdEw3QZGd6Xd4r2Nkgu/?= =?us-ascii?Q?rJLK/0TYVEQ2nfC5IlNr63jnR7fE7d0eTQM15R32yCqCw2kW5XDs0MUc+q4g?= =?us-ascii?Q?jaC058yB9t0nhgQp3NIgNTJqOQpmm1KnV209esfkY3bvSmMD+vpnktm6U7aR?= =?us-ascii?Q?uC/KdQgwbufTmSem9M2Bu1x2Ps//luYBEGcDEkX4RezkOPssT+2Y1CorP/xh?= =?us-ascii?Q?razxsxQ2GPzJgGQDhFynru0pOxnscS9wy/8vLDKOOIaDShoWgAEbaYOZtceN?= =?us-ascii?Q?zdF4rh1eG4vgrnZOQ0tN7bWQJ5u8knN93mRCj9pgA4Bd2xyA6CKo+afmctYF?= =?us-ascii?Q?tg0rDSwCCuKE5rUddICJziq89fAZIkazIx92wg4R9sW8yt27SQMW5qG2Z652?= =?us-ascii?Q?6dIPtO/ohhcE6MA71HE91N8QUfFHRoAspzBDB+x8eB5D9d59ig5t1pTDaTJS?= =?us-ascii?Q?gvcqjK5PFmSg0E+2RVWSmels7zN9/MPbKI6732/352o+Au93UIya9Yqo7QD1?= =?us-ascii?Q?rsJsnUHvHsrhkTZqe0gtrcJoF7WfCymQNcAqKh1NNkZvQCC54FoYYL9pNSJq?= =?us-ascii?Q?dquGe2c11+Xnu8vizxKXaym1EzmC7feshfWoKoRm+B9TbcE2lL9wCDixWrSN?= =?us-ascii?Q?pKTojrld035vXwwMS00DLoATsXRdyqi5a/SlRYevvh3q5dcrOVgBQqDu9lPk?= =?us-ascii?Q?oU8jWMjF8BwJciLWgoRbGamzbDobUGfF/eCit4eEkSBOCg=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB9PR07MB7180.eurprd07.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(366007)(376005)(1800799015)(38070700009);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?p77qFGH2mY1VELDk158OmB6QraPCCNsuMXcty0qq1ezi1S1ScD+iKaZQ0UDS?= =?us-ascii?Q?fX0yGjZZh4p3EANhFjMcNDzL02Zk78lp2/in94UHLYBJ4gxWg7YszOgBxwW2?= =?us-ascii?Q?h3lDWCPWSm32NwvYnJcrcmk7V+1Coa4ueYWMHzcStpeRaGiOhU6v4c0lCwDP?= =?us-ascii?Q?rlPuJ3o7m/JyDq/m8Yej3kiGFvXXH1GVLlScTLaHnxBUvvTWlZ48kDAtkI33?= =?us-ascii?Q?OzNQB6Y0xgjUfhg/rP3Bh1vvJih0LogIVdXVaS9P/yLpeqwjoJWucH6RM4gt?= =?us-ascii?Q?Mf/C7o4t4O9/8bWJUikrVqVL5Y2J/tcLgtyx4dxWeBE9TXlQY+Go/NzeR9S4?= =?us-ascii?Q?LIwvB/xtLZtKfssNxceCUuLdiSI+rBTy4LO3RskPXPVE+etjI+YBTgcq3e8j?= =?us-ascii?Q?Ier8TuCqwK6G9+n/F4HAjwo98Lq939Urc/ujhr3gUMsZmoejZwEVX0sqHuMa?= =?us-ascii?Q?cOCpLKJ7o/YxRv8FBSiaCUj2RYKreEbaNcx/xgvRSNFZJ2gM1u/7a0u4PLan?= =?us-ascii?Q?IVA+bNLRwfDNab1+rI8ZA4BWyXvdDElBd2Ts/s2hwYlN9pmMucjDUfuf/dam?= =?us-ascii?Q?OAN1MD9d+zFxFmjaOFtnlHreq2q30/X3HY2pCPzqHiSOc8cITbb3BAgQn9eI?= =?us-ascii?Q?y9pvb5Te0kD5QherSon3irxNXAENIssD94fBNfcbe9DBPgfBFiHx8/c0c3tQ?= =?us-ascii?Q?lcOypSsAwKAqEaJueerkacJ+lHDugpY2ykcoXKFCs833tmASKbx24Pkot4lv?= =?us-ascii?Q?jh4ktYnkeV9X8SgDhn0C4KOfxQhLC+hCRu3eVHm9H013EYRSMzsmjjCfCP0F?= =?us-ascii?Q?6RQqzCONsa+YeVabSwkb6hg5XKnoFmn3keJEGgqxbDCaLtTr7ZrBFL8BcF0F?= =?us-ascii?Q?1jpP1MLIqYcmKj3kGkh0CeoilIEDiF4nIFdCUV66020lW1aZ9df0T9n16ZRX?= =?us-ascii?Q?c8+7UPUyXvaTdLd0bRMaQSJEWoDCWDHQLqLay1VMCzBXCLDSUFRm7sZBVzzb?= =?us-ascii?Q?+r/LZA47oYEUUFELq9ceu3y5pw3ad2ap9D7pn2zIksk29LHp77t7PkRMePsw?= =?us-ascii?Q?aSNG90BemJ21k8FFHGBkwFfjCKZnTDHKx3tAo43/fCOltg6P4R/D7df32mW2?= =?us-ascii?Q?MPqjzUgPu6tZjtAteS2kORSelmVQa2xzIAU6HNl+pjM3XSKL0VhVFAEIwj7z?= =?us-ascii?Q?HIWA+KO5p1z6N7+u3S2IhkEKRbTtlxuCqAsnHXEXg2AvolkitotNW1KDwBRF?= =?us-ascii?Q?rsRAJT+He4Pkk10lIF6JC7niyNiUvCa7bUSE6PlSjZ8/rkgWcer5WnKp4fbx?= =?us-ascii?Q?hO5E4pEm75W6Bud5IobUwVlkDzD8oM0PJOx+YycPxt/3p2BaANxw2n0lKb63?= =?us-ascii?Q?z2IOLgrhSJYJA8ls9VVR12oQWKMMq90pwozbPrBP8wfnjzv1Y7PcRSbPOR6w?= =?us-ascii?Q?G1yEbg/OiBlonSYM+AFukQmcEnKh+mazk3IfIiX3gQKEPssHte5LQ6jowC/X?= =?us-ascii?Q?+ivt9W/BqtDshTYTsyNln1wUBnWjHUgb5AcAaMHS2a9efR7vz5sFubgUrkrD?= =?us-ascii?Q?OZqNE4dcC88jgJdIoOQ=3D?= Content-Type: multipart/alternative; boundary="_000_DB9PR07MB718064E2862005880E0F6383CB0F2DB9PR07MB7180eurp_" 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: a52ddcad-0838-4496-3264-08dc5ef16cc9 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Apr 2024 15:16:58.4666 (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: p1I/ouwQ+MfgpiIRMf2LqtH0gR/7GV2ZRBBdxOH3LAv/RDaNet1ze29XXY0mpcpS X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1PR07MB8504 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DB9PR07MB718064E2862005880E0F6383CB0F2DB9PR07MB7180eurp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Fixed a typo... 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 not working even after I = performed the reset. Any ideas what is wrong? From: Avi Weinberg Sent: Wednesday, April 17, 2024 6:01 PM To: pgsql-generallists.postgresql.org Subject: [External] replication slot "pg_1015733_sync_1014718_7358407382484= 881476" does not exist 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. 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_DB9PR07MB718064E2862005880E0F6383CB0F2DB9PR07MB7180eurp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Fixed a typo…

 

Hi Experts,

 

For a second time in the past few months I'm getting the following e= rrors in Postgres log.  Last time it was solved when I reset all Postg= res 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 <AviW@gilat.com>
Sent: Wednesday, April 17, 2024 6:01 PM
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgr= esql.org>
Subject: [External] replication slot "pg_1015733_sync_1014718_7= 358407382484881476" does not exist

 

Hi Experts,

 

For a second time in the past few months I'm getting the following e= rrors in Postgres log.  Last time it was solved when I reset all Postg= res 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_73584073= 82484881476" does not exist

STATEMENT:  DROP_REPLICATION_SLOT pg_1015733_sync_1014718_73584= 07382484881476 WAIT

ERROR:  replication slot "pg_1015733_sync_1014956_73584073= 82484881476" does not exist

STATEMENT:  DROP_REPLICATION_SLOT pg_1015733_sync_1014956_73584= 07382484881476 WAIT

192 ERROR:  replication slot "pg_927671_sync_927281_7358103111= 795036228" does not exist

START_REPLICATION SLOT "pg_927671_sync_927281_73581031117950362= 28" LOGICAL 0/AC888F00 (proto_version '3', publication_names '"aa= a","bbb"')

replication slot "pg_1015733_sync_1015375_7358407382484881476&q= uot; does not exist

DROP_REPLICATION_SLOT pg_1015733_sync_1015375_7358407382484881476 WA= IT

 

 

Thanks

IMPORTANT - This= email and any attachments is intended for the above named addressee(s), an= d may contain information which is confidential or privileged. If you are not the intended recipient, please inform the se= nder immediately and delete this email: you should not copy or use this e-m= ail 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 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. --_000_DB9PR07MB718064E2862005880E0F6383CB0F2DB9PR07MB7180eurp_--