Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: "Jay W(dot) Summet" <jay(at)summet(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] FATAL 1:btree: BTP_CHAIN flag was expected (vacuum command)
Date: 1999-03-26 03:35:51
Message-ID: Pine.BSF.4.05.9903252335330.389-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-general
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(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


In response to

pgsql-general by date

Next:From: The Hermit HackerDate: 1999-03-26 03:37:06
Subject: RE: [GENERAL] info on people running postgre
Previous:From: Jim JennisDate: 1999-03-25 22:48:36
Subject: Re: [GENERAL] Re: [SQL] sql 92 support in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group