vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language - Mailing list pgsql-general

From Warren Vanichuk
Subject vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Date
Msg-id Pine.LNX.4.21.0103061545400.25271-100000@urd.street-light.com
Whole thread Raw
Responses Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
List pgsql-general
*sigh*  I will learn to use my mail client soon to change subjects.  My
apologies. :(

Original Message :
------------------

Greetings.

I just received the following error attempting to do a vacuum on my
database:

freehost=# vacuum analyze;
NOTICE:  Rel pg_language: TID 0/1: OID IS INVALID. TUPGONE 1.
ERROR:  Index pg_language_oid_index is not a btree

And I see several errors in the logs regarding invalid function calls.  When
I attempt to call any user-defined function I receive :

freehost=# select add_pageview( 1 );
ERROR:  Index pg_language_oid_index is not a btree

The only oddity during this time was the postgres process handling the
vacuum shot up to 685MB worth of RAM usage (638 shared) during the vacuum.

This is a Debian 2.2 system running PostgreSQL 7.0.3...

Help? :)

Sincerely, Warren



pgsql-general by date:

Previous
From: Warren Vanichuk
Date:
Subject: Re: Inserting values into a SERIAL field
Next
From: Jean-Christophe Boggio
Date:
Subject: Request regarding logs