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

Поиск
Список
Период
Сортировка
От Warren Vanichuk
Тема vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Дата
Msg-id Pine.LNX.4.21.0103061545400.25271-100000@urd.street-light.com
обсуждение исходный текст
Ответы Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language
Список 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 по дате отправления:

Предыдущее
От: Warren Vanichuk
Дата:
Сообщение: Re: Inserting values into a SERIAL field
Следующее
От: Jean-Christophe Boggio
Дата:
Сообщение: Request regarding logs