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 1suQeN-006e2E-VN for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Sep 2024 06:09:52 +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 1suQeM-003Yjp-JJ for pgsql-bugs@arkaria.postgresql.org; Sat, 28 Sep 2024 06:09:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suNsS-001V5U-WA for pgsql-bugs@lists.postgresql.org; Sat, 28 Sep 2024 03:12:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suNsM-001Pmc-HG for pgsql-bugs@lists.postgresql.org; Sat, 28 Sep 2024 03:12:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=5zEbicRYm7glEuPq9o1OfTfPs4dtaJT4KTn0IJmLr0I=; b=esq0keC97geiKI3UWBFQIQ437i 0eBxuz3HJdcw6fnbGjJbioxmS+tSmmgw9neZQzYF+GBxg1eqrTkTNVuxc629+KedG60m0PKAalLwe RSrQczdbvCCk6rfTxifHh0RKwAh6PWDSEormDGbEtnedl8UHR7I0q2DAQeWV/ByF2AtkUi+3dKsaf hpkfsqfP8TtySwFLqEFhiQ4pPPbl+GpejUZ7XuZ2S8Y7g+oob/WIw7IrJvYw6oegX7WmOGYAL97+X SEiiQEk8z0c3T34S2JNSh9KTY+v+2bHnBUkoU0qzOR339sK3gkZsd+KpXTUNdtytPnV7OwjCONIxe 4RgkJ05w==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suNsL-004Plu-3V for pgsql-bugs@lists.postgresql.org; Sat, 28 Sep 2024 03:12:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1suNsJ-007Mzm-E7 for pgsql-bugs@lists.postgresql.org; Sat, 28 Sep 2024 03:12:03 +0000 Content-Type: multipart/mixed; boundary="===============5041587691277041930==" MIME-Version: 1.0 Subject: BUG #18640: Replica Sync Failure After Downtime in Patroni HA Setup Due to Missing WAL Segments To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kotak.nikhil@gmail.com Reply-To: kotak.nikhil@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 28 Sep 2024 03:11:15 +0000 Message-ID: <18640-2a2df650791eab97@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5041587691277041930== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY0MApMb2dnZWQgYnk6ICAgICAgICAgIG5pa2hpbCBrb3RhawpFbWFp bCBhZGRyZXNzOiAgICAgIGtvdGFrLm5pa2hpbEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNC4xMApPcGVyYXRpbmcgc3lzdGVtOiAgIFJlZGhhdCBFbnRlcnByaXNlIExpbnV4IDcuOQpE ZXNjcmlwdGlvbjogICAgICAgIAoKV2UgYXJlIHJ1bm5pbmcgYSBQYXRyb25pIEhBIHNldHVwIHdp dGggUG9zdGdyZVNRTCBpbiBvdXIgZW52aXJvbm1lbnQsIHdoZXJlCndlIGhhdmUgMiBvciBtb3Jl IHJlcGxpY2FzIGRlcGVuZGluZyBvbiB0aGUgYXBwbGljYXRpb24gdGllci4gRHVyaW5nIHJlZ3Vs YXIKbWFpbnRlbmFuY2UgYWN0aXZpdGllcywgc3VjaCBhcyBPUyBwYXRjaGluZyBvciB3ZWVrZW5k IHNlcnZlciBzaHV0ZG93bnMsIHdlCnN0b3AgdGhlIFBhdHJvbmkgc2VydmljZSBvbiB0aGUgcmVw bGljYXMgd2hpbGUgdGhlIG9yaWdpbmFsIGxlYWRlciByZW1haW5zCnVwLg0KDQpUaGVzZSBtYWlu dGVuYW5jZSBhY3Rpdml0aWVzIHR5cGljYWxseSBsYXN0IGFyb3VuZCAyLTMgaG91cnMuIE9uY2Ug dGhlCnNlcnZlcnMgYXJlIHJldHVybmVkIHRvIG9wZXJhdGlvbmFsIHN0YXR1cyBieSBvdXIgVU5J WCBTeXN0ZW0gQWRtaW5pc3RyYXRvciwKd2UgYXR0ZW1wdCB0byByZXN0YXJ0IHRoZSBQYXRyb25p IHNlcnZpY2Ugb24gdGhlIHJlcGxpY2FzLiBIb3dldmVyLCB3ZQpmcmVxdWVudGx5IGVuY291bnRl ciBhbiBpc3N1ZSB3aGVyZSB0aGUgcmVwbGljYXMgcmVtYWluIG91dCBvZiBzeW5jLCBhbmQgdGhl CmZvbGxvd2luZyBlcnJvciBtZXNzYWdlIGFwcGVhcnMgaW4gdGhlIGFsZXJ0IGxvZ3M6DQoNCiJD b3VsZCBub3QgcmVjZWl2ZSBkYXRhIGZyb20gV0FMIHN0cmVhbTogRVJST1I6IHJlcXVlc3RlZCBX QUwgc2VnbWVudCA8MTIzPgpoYXMgYWxyZWFkeSBiZWVuIHJlbW92ZWQiDQoNClVwb24gaW52ZXN0 aWdhdGlvbiwgd2Ugb2JzZXJ2ZSB0aGF0IHRoZSBXQUwgc2VnbWVudCBubyBsb25nZXIgZXhpc3Rz IG9uIHRoZQpyZXBsaWNhICh3aGljaCB3YXMgZG93biksIGJ1dCBpdCBzdGlsbCBleGlzdHMgb24g dGhlIGxlYWRlci4gQWZ0ZXIgbWFudWFsbHkKY29weWluZyB0aGUgbWlzc2luZyBXQUwgc2VnbWVu dCBmcm9tIHRoZSBsZWFkZXIgdG8gdGhlIHJlcGxpY2EsIHRoZSByZXBsaWNhCnN1Y2Nlc3NmdWxs eSByZXN1bWVzIHN5bmNpbmcgb24gaXRzIG93bi4NCg0KSXNzdWU6IFRoZSBwcm9ibGVtIGlzIHRo YXQgdGhlIHJlcGxpY2EgZG9lcyBub3QgYXV0b21hdGljYWxseSBhdHRlbXB0IHRvCmZldGNoIHRo ZSBtaXNzaW5nIFdBTCBzZWdtZW50cyBmcm9tIHRoZSBwcmltYXJ5IG9uY2UgaXQgaXMgYnJvdWdo dCBiYWNrCm9ubGluZS4gV2UgYXJlIGZvcmNlZCB0byBtYW51YWxseSBpbnRlcnZlbmUsIHdoaWNo IGFkZHMgdW5uZWNlc3NhcnkKY29tcGxleGl0eSBhbmQgZGVsYXkgaW4gcmVzdG9yaW5nIEhBIGZ1 bmN0aW9uYWxpdHkgYWZ0ZXIgZG93bnRpbWUuDQoNCkV4cGVjdGVkIEJlaGF2aW9yOiBXZSBleHBl Y3QgdGhlIHJlcGxpY2EgdG8gYXV0b21hdGljYWxseSByZXF1ZXN0IGFuZCBmZXRjaAp0aGUgbWlz c2luZyBXQUwgc2VnbWVudHMgZnJvbSB0aGUgcHJpbWFyeSAobGVhZGVyKSB1cG9uIHN0YXJ0dXAs IGVuc3VyaW5nIGl0CmNhbiBzeW5jIHVwIHdpdGhvdXQgbWFudWFsIGludGVydmVudGlvbi4NCg0K Q291bGQgeW91IHBsZWFzZSBoZWxwIHVzIHVuZGVyc3RhbmQgd2h5IHRoaXMgYmVoYXZpb3Igb2Nj dXJzLCBhbmQgd2hldGhlciBpdApjYW4gYmUgYWRkcmVzc2VkIHdpdGhpbiBQb3N0Z3JlU1FMIG9y IFBhdHJvbmkgdG8gZW5zdXJlIGF1dG9tYXRpYyByZWNvdmVyeQpmb3IgdGhlIHJlcGxpY2FzPwoK --===============5041587691277041930==--