Re: vacuum full failing in 7.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuum full failing in 7.3
Date
Msg-id 6659.1064539240@sss.pgh.pa.us
Whole thread Raw
In response to vacuum full failing in 7.3  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> I am getting a weird failure, trying to vacuum a table in 7.3 - it says
> "ERROR:  Index pg_toast_89407_index is not a btree".

That says the first page of the index was corrupted (version number
field didn't contain the right thing).

> Does it ring a bell to anyone? Any ideas what's wrong? Is it my database
> screwed up? I just created it today...
> I tried dropping and recreating it... and it seems to be working now.

Sounds like you just destroyed all the evidence :-(.  I'd wonder about
hardware flakiness for one thing ...

            regards, tom lane

pgsql-general by date:

Previous
From: Martin Marques
Date:
Subject: Re: MySQL-to-PostgreSQL
Next
From: Dennis Gearon
Date:
Subject: non local access to database