DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1

From: "Kumar, Devesh" <devesh(dot)kumar(at)cmegroup(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
Date: 2024-04-26 19:06:56
Message-ID: CACMEH=4R1_oYrmE4qh2v38ZqWthLt3Q3UKOQN4=B2+RaBsCGTA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

Currently we are working on setting up replication and testing failover
scenarios and failback. During our testing, failover is getting successful.
During Failback, when we are reverting the original primary instance as the
new standby, we are getting pg_rewind errors. Kindly can someone check and
let us know.

DETAIL: pg_rewind command is "/opt/postgresql/pg/bin/pg_rewind -D
'/pgresdata101/data' --source-server='host=10.29.97.241 port=5432
user=repmgr dbname=repmgr connect_timeout=2'"
DEBUG: executing:
/opt/postgresql/pg/bin/pg_rewind -D '/pgresdata101/data'
--source-server='host=10.29.97.241 port=5432 user=repmgr dbname=repmgr
connect_timeout=2' 2>/tmp/repmgr_command.wgVGPS
DEBUG: result of command was 1 (256)
DEBUG: local_command(): output returned was:
pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1
pg_rewind: error: could not open file
"/pgresdata101/data/pg_wal/000000010000000000000008": No such file or
directory
pg_rewind: error: could not find previous WAL record at 0/802B668

___________________________

*DEVESH KUMAR*

Database Admin I – India

M: +91 6366843695

devesh(dot)kumar(at)cmegroup(dot)com <firstname(dot)lastname(at)cmegroup(dot)com>

[image: CC24_EC010-Great-Place-to-Work-India-email-sign-260x100px_v2 (1)
(1).jpg]

Address: Tridib Building Block B 5th Floor

Bagmane Tech Park CV Raman Nagar,

Bengaluru, 560093, IN
www.cmegroup.com

--

NOTICE: This message, and any attachments, are for the intended
recipient(s) only, may contain information that is privileged, confidential
and/or proprietary and subject to important terms and conditions available
at 
https://www.cmegroup.com/tools-information/communications/e-communication-disclaimer.html
<https://www.cmegroup.com/tools-information/communications/e-communication-disclaimer.html
If you are not the intended recipient, please delete this message. CME
Group and its subsidiaries reserve the right to monitor all email
communications that occur on CME Group information systems.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marek Läll 2024-04-26 19:27:49 Re: BUG #18445: date_part / extract range for hours do not match documentation
Previous Message David G. Johnston 2024-04-26 13:06:30 Re: BUG #18445: date_part / extract range for hours do not match documentation