vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language

From: Warren Vanichuk <pyber(at)street-light(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Date: 2001-03-06 23:46:48
Message-ID: Pine.LNX.4.21.0103061545400.25271-100000@urd.street-light.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mathijs Brands 2001-03-07 00:09:46 Re: [SQL] Re: Re: MySQLs Describe emulator!
Previous Message Boulat Khakimov 2001-03-06 23:44:31 Undefined symbol