vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
*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
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
freehost=# vacuum analyze;
NOTICE: Rel pg_language: TID 0/1: OID IS INVALID. TUPGONE 1.
ERROR: Index pg_language_oid_index is not a btreeYeek. 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.)
Thank you, I found 'reindex' and followed the instructions and everything
appears to be fairly happy again. :)
Sincerely, Warren