Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Date
Msg-id 8371.983937895@sss.pgh.pa.us
Whole thread Raw
In response to vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language  (Warren Vanichuk <pyber@street-light.com>)
Responses Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language  (Warren Vanichuk <pyber@street-light.com>)
List pgsql-general
Tree view 
Warren Vanichuk <pyber@street-light.com> writes:
> 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

Yeek.  Something's pretty hosed with pg_language_oid_index.  Try
reindexing it.  (The procedure to reindex a system index is a bit
arcane, and I have to admit I've never done it myself, but it's in
the documentation.)

            regards, tom lane

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: Temporary sorting space
Next
From: Tom Lane
Date:
Subject: Re: Temporary sorting space