BUG #15412: "invalid contrecord length" during WAL replica recovery

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: timur(dot)luchkin(at)gmail(dot)com
Subject: BUG #15412: "invalid contrecord length" during WAL replica recovery
Date: 2018-10-01 08:38:23
Message-ID: 15412-f9a89b026e6774d1@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15412
Logged by: Timur Luchkin
Email address: timur(dot)luchkin(at)gmail(dot)com
PostgreSQL version: 10.4
Operating system: Ubuntu 16.04.4 LTS
Description:

Hello.
Sorry to post it again, but I really need help to recover broken replica.
LOG: invalid contrecord length 861 at 159E/A6FFFC40

We are getting this kind of error in WAL based replica's log after the
master DB was down due to no space left issue.
Disk space was already added and master up'n'running (including its
synchronous streaming based replica), but offsite WAL replica can't start
due to above mentioned error.
We can't recreate it using pg_basebackup due to slow network and huge DB
size.
Are there any fixes possible to continue apply WALs?

More details:
<2018-09-25 08:07:19 UTC--- [app:,pid:19517,00000]>LOG: restored log file
"000000010000159E000000A6" from archive
<2018-09-25 08:07:23 UTC--- [app:,pid:19517,00000]>LOG: restored log file
"000000010000159E000000A7" from archive
<2018-09-25 08:07:23 UTC--- [app:,pid:19517,00000]>LOG: invalid contrecord
length 861 at 159E/A6FFFC40

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2018-10-01 09:06:46 Re: BUG #15412: "invalid contrecord length" during WAL replica recovery
Previous Message Keith Fiske 2018-09-29 16:10:06 Re: BUG #15405: Pgadmin UI not working