public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mendbayar Alzakhgui <[email protected]>
To: [email protected] <[email protected]>
Subject: Postgresql replication failed in Patroni
Date: Fri, 7 Feb 2025 06:04:10 +0000
Message-ID: <SEZPR01MB574850C01356D4ABD2F5BB0AEAF12@SEZPR01MB5748.apcprd01.prod.exchangelabs.com> (raw)

Hello everybody,
I need a urgent help on my Patroni managed postgres cluster,

the main patroni managed leader postgres crushed and down, when we try to start the Postgresql it's showing us this error log

2025-02-07 12:31:18 +08 [2354332]: [4-1] user=,db=,app=,client=LOG:  listening on IPv4 address "ip_address", port 5432
2025-02-07 12:31:18 +08 [2354332]: [5-1] user=,db=,app=,client=LOG:  listening on Unix socket "./.s.PGSQL.5432"
2025-02-07 12:31:18 +08 [2354337]: [1-1] user=,db=,app=,client=LOG:  database system was shut down in recovery at 2025-02-07 11:56:50 +08
2025-02-07 12:31:18 +08 [2354337]: [2-1] user=,db=,app=,client=LOG:  entering standby mode
2025-02-07 12:31:18 +08 [2354337]: [3-1] user=,db=,app=,client=FATAL:  requested timeline 20 is not a child of this server's history
2025-02-07 12:31:18 +08 [2354337]: [4-1] user=,db=,app=,client=DETAIL:  Latest checkpoint is at 71/4D8BB8C0 on timeline 19, but in the history of the requested timeline, the server forked off from that timeline at 71/4D793220.
2025-02-07 12:31:18 +08 [2354332]: [6-1] user=,db=,app=,client=LOG:  startup process (PID 2354337) exited with exit code 1
2025-02-07 12:31:18 +08 [2354332]: [7-1] user=,db=,app=,client=LOG:  aborting startup due to startup process failure
2025-02-07 12:31:18 +08 [2354332]: [8-1] user=,db=,app=,client=LOG:  database system is shut down

what should we check?, and is this because the leader node already deleted the wal it's needed to start? And we were connected debezium to this node when we recover it will the debezium start automatically from the disconnected sessions? Please help me.

Sincerely,

Mendbayar A. | Database Administrator
Information technology department

+976 8611-2165
[email protected]<mailto:[email protected]>
Central Tower, 11th floor
www.unitel.mn<http://www.unitel.mn/;

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: Postgresql replication failed in Patroni
  In-Reply-To: <SEZPR01MB574850C01356D4ABD2F5BB0AEAF12@SEZPR01MB5748.apcprd01.prod.exchangelabs.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