BUG #7752: FATAL btree error on PITR - Mailing list pgsql-bugs

From m.sakrejda@gmail.com
Subject BUG #7752: FATAL btree error on PITR
Date
Msg-id E1TibXV-0006fM-H2@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7752: FATAL btree error on PITR
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7752
Logged by:          Maciek Sakrejda
Email address:      m.sakrejda@gmail.com
PostgreSQL version: 9.1.6
Operating system:   Ubuntu 10.04 LTS 64-bit
Description:        =


Ran into the following error in trying to perform a PITR:

FATAL:  btree level 66135134 not found in index "436254"

This happened when the PITR was almost complete (judging by on-disk database
size). I guess this may be related to one of the index corruption issues
fixed in 9.1.7, but if that's the case, would it perhaps make sense to
complete the PITR without the corrupt index(es) and deal with the index
issue separately? Clearly, just a warning is dangerously likely to be
skipped, but maybe a mechanism like backup_label, that prevents normal
startup before the issue is resolved?

pgsql-bugs by date:

Previous
From: ktuszynska@esri.com
Date:
Subject: BUG #7751: libintl.h missing in the include folder
Next
From: Tom Lane
Date:
Subject: Re: init_htab causes SIGFPE (or worse) due to miscalculation for large nbuckets