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

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15412: "invalid contrecord length" during WAL replica recovery
Дата
Msg-id 15412-f9a89b026e6774d1@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15412: "invalid contrecord length" during WAL replicarecovery  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15412
Logged by:          Timur Luchkin
Email address:      timur.luchkin@gmail.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


В списке pgsql-bugs по дате отправления:

Предыдущее
От: Keith Fiske
Дата:
Сообщение: Re: BUG #15405: Pgadmin UI not working
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15412: "invalid contrecord length" during WAL replicarecovery