Re: pg_dump failes due to invalid memory request

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump failes due to invalid memory request
Дата
Msg-id 10354.1125634687@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump failes due to invalid memory request  ("Morgan Kita" <mkita@verseon.com>)
Список pgsql-novice
"Morgan Kita" <mkita@verseon.com> writes:
> I just tried to call pg_dump for my database this evening, and it fails on one of my tables.
> The error it gives in the log is:
> ERROR:  invalid memory alloc request size 3221230573

This looks like a pretty standard data-corruption situation: you've got
a variable-width field somewhere with a ridiculous value in its length
word.  If you trawl the PG mail list archives you'll find plenty of
examples and discussions about how to triangulate on the bad row(s) and
get rid of them.

> Now the only thing I can think of is that this particular table has 2
> custom data types that are both toastable.

[ raised eyebrow... ]  Then it could also be a symptom of a garden
variety bug in your custom datatype code.  Have you tried getting
a stack trace from errfinish() to see exactly where the complaint
is being raised?

            regards, tom lane

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

Предыдущее
От: "Morgan Kita"
Дата:
Сообщение: pg_dump failes due to invalid memory request
Следующее
От: Peter Ludikovsky
Дата:
Сообщение: Trigger Programming on Windows XP