[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum
From:       The Hermit Hacker <scrappy () hub ! org>
Date:       1999-03-26 3:35:51
[Download RAW message or body]

On Thu, 25 Mar 1999, Jay W. Summet wrote:

> When I try to vacuum, or vacuum analyze my database, I get the 
> following error:
> FATAL 1:btree: BTP_CHAIN flag was expected
> 
> I've tried the following two commands:
> /usr/local/pgsql/bin/psql -c "vacuum analyze;" billing
> and
> /usr/local/pgsql/bin/psql -c "vacuum;" billing
> 
> The top command used to work (for the last few years), so I assume 
> that something has changed with my data. Otherwise, the database 
> appears to be working ok.
> 
> Any pointers? I'm thinking about dumping all the data and 
> re-inserting it...

Try just drop'ng and rebuilding your indices...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 

[prev in list] [next in list] [prev in thread] [next in thread]