Re: index corruption? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: index corruption?
Date
Msg-id 4646.1045203370@sss.pgh.pa.us
Whole thread Raw
In response to index corruption?  (Laurette Cisneros <laurette@nextbus.com>)
List pgsql-hackers
Laurette Cisneros <laurette@nextbus.com> writes:
> This is the error in the pgsql log:
> 2003-02-13 16:21:42 [8843]   ERROR:  Index external_signstops_pkey is not a
> btree

This says that one of two fields that should never change, in fixed
positions in the first block of a btree index, didn't have the right
values.  I am not aware of any PG bugs that could overwrite those
fields.  I think the most likely bet is that you've got hardware
issues ... have you run memory and disk diagnostics lately?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Offering tuned config files
Next
From: Oliver Elphick
Date:
Subject: Re: location of the configuration files