Re: pg_rewind success even though getting error 'record with incorrect prev-link'

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Abdullah Al Maruf <maruf(dot)2hin(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_rewind success even though getting error 'record with incorrect prev-link'
Date: 2019-01-30 01:44:08
Message-ID: 20190130014408.GM3121@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 29, 2019 at 07:13:11PM +0600, Abdullah Al Maruf wrote:
> When I try to attach an old master with 'archiving set to on` as a new
> standby, `pg_rewind` doesn't throw any error, But, when the database
> starts, The following error appears:
>
> ```
> LOG: invalid record length at 0/B000098: wanted 24, got 0
> LOG: started streaming WAL from primary at 0/B000000 on timeline 2
> LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
> FATAL: terminating walreceiver process due to administrator command

This is pointing out to the end of WAL for the current timeline. You
may face it after reading a WAL segment in an area which has been used
in the past for a recycled segment.
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wells Oliver 2019-01-30 02:49:38 Querying w/ join slow for large/many child tables
Previous Message pabloa98 2019-01-30 00:47:46 Re: postgresql v11.1 Segmentation fault: signal 11: by running SELECT... JIT Issue?