Thread: pgsql: Avoid bogus "out-of-sequence timeline ID" errors in standby-mode
pgsql: Avoid bogus "out-of-sequence timeline ID" errors in standby-mode
From
Heikki Linnakangas
Date:
Avoid bogus "out-of-sequence timeline ID" errors in standby-mode. When startup process opens a WAL segment after replaying part of it, it validates the first page on the WAL segment, even though the page it's really interested in later in the file. As part of the validation, it checks that the TLI on the page header is >= the TLI it saw on the last page it read. If the segment contains a timeline switch, and we have already replayed it, and then re-open the WAL segment (because of streaming replication got disconnected and reconnected, for example), the TLI check will fail when the first page is validated. Fix that by relaxing the TLI check when re-opening a WAL segment. Backpatch to 9.0. Earlier versions had the same code, but before standby mode was introduced in 9.0, recovery never tried to re-read a segment after partially replaying it. Reported by Amit Kapila, while testing a new feature. Branch ------ REL9_2_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/dda8b87b6a470249e9d4e3701849b7bd830bb96c Modified Files -------------- src/backend/access/transam/xlog.c | 32 +++++++++++++++++++++++--------- 1 files changed, 23 insertions(+), 9 deletions(-)