Re: pg_rewind success even though getting error 'record withincorrect prev-link'
| От | Abdullah Al Maruf |
|---|---|
| Тема | Re: pg_rewind success even though getting error 'record withincorrect prev-link' |
| Дата | |
| Msg-id | CANzStTBiqbj0tK0L3cbET1yr=JV9wB0y2rUvfpB3rqNGr_ZkoQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_rewind success even though getting error 'record withincorrect prev-link' (Michael Paquier <michael@paquier.xyz>) |
| Ответы |
Re: pg_rewind success even though getting error 'record withincorrect prev-link'
(Ron <ronljohnsonjr@gmail.com>)
|
| Список | pgsql-general |
> may face it after reading a WAL segment in an area which has been used
> in the past for a recycled segment.
2nd & 3rd node). When I make the 3rd node as master (by trigger file) and
restarts 0th node as a replica, It shows no problem.
But when both nodes are offline and our leader selection chooses the 0th node
as a master, and tries to reattach the 3rd node as Replica, It throws an
error similar to:
```
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
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
LOG: record with incorrect prev-link 10000/21B0000 at 0/B000098
```
If I disable archive_mode, I never faced this error with the same script. It
only appears when archive is on, and also not all the times it happens but
most of the time it does.
The error message appears after every 5 seconds.
Scenario In details:
I have two folders for scripts.
├── primary
│ ├── postgresql.conf
│ ├── restore.sh
│ ├── run.sh
│ └── start.sh
└── replica
├── recovery.conf
└── run.sh
I have a system that will choose the leader. If the current pod is the leader,
it will run `primary/run.sh`, and If it is a replica, it will run
`replica/run.sh`.
The files can be found here.
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
В списке pgsql-general по дате отправления: