Re: AllocSetAlloc() error message

Поиск
Список
Период
Сортировка
От Medi Montaseri
Тема Re: AllocSetAlloc() error message
Дата
Msg-id 3E4344B0.4010307@intransa.com
обсуждение исходный текст
Ответ на AllocSetAlloc() error message  (Medi Montaseri <medi.montaseri@intransa.com>)
Ответы Re: AllocSetAlloc() error message
Список pgsql-general
Should I be looking for an exsessively large table or column ?
Most (99%) of my tables are text fields, but small values (less than
1024 bytes)....
Perhaps I should dump the data and go after it with a perl script....

Also this happend around a VACUUM-ing job....is there any relation there ?
Also should I drop my other work and chase this or this is more of
 warning than an error....

Thanks

Tom Lane wrote:

>Medi Montaseri <medi.montaseri@intransa.com> writes:
>
>
>>Can someone shed some light on this error message for me (please).
>>This is a 7.2.3 debug level 2 output, and my config is
>>
>>
>
>
>
>>2003-02-06 16:15:44 [645]    ERROR:  Memory exhausted in
>>AllocSetAlloc(1073741820)
>>
>>
>
>I think this is a corrupt-data problem: you've probably got a
>variable-length datum whose length word is munged to look like a
>ridicuously large value.  You should be scanning the table to see
>where the bad data is.
>
>            regards, tom lane
>
>




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

Предыдущее
От: John Smith
Дата:
Сообщение: selects with large offset really slow
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Pg_dumpall problem[2]