Re: Autovacuum Error Message out of memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum Error Message out of memory
Дата
Msg-id 898.1298657527@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Autovacuum Error Message out of memory  (Reto Wittwer <reto.wittwer@exsila.com>)
Список pgsql-general
Reto Wittwer <reto.wittwer@exsila.com> writes:
> Hello everyone
> I have the following error in my postgres-log:
> 2011-02-18 16:33:46.262 CET [2068:1] @ FEHLER: Speicher aufgebraucht
> 2011-02-18 16:33:46.262 CET [2068:2] @ DETAIL: Fehler bei Anfrage mit Gr��e 893716290.

Right offhand this looks like a corrupt-data problem, ie, trashed length
word in some variable-length value.  Autovacuum isn't particularly at
fault, it just happens to be trying to examine a value that you haven't
read lately in regular use of the database.  I'd suggest seeing whether
pg_dump doesn't find the problem too; if so you'll need to start doing
data recovery.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: slow building index and reference after Sybase to Pg
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Covert database from ASCII to UTF-8