Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
Дата
Msg-id 22255.1371840130@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559  (kapplegate@apsalar.com)
Список pgsql-bugs
kapplegate@apsalar.com writes:
> One of our queries has started failing randomly on our slaves with
> invalid memory alloc request size 18446744073709537559

It's hard to say much with that amount of information.  Is it always the
exact same number?  The root cause is probably either corrupted data
(that is, a trashed length word for some variable-width field) or some
internal logic bug that's causing the server to miscompute how much
memory it needs for some transient allocation.  You could confirm or
refute the corrupt-data hypothesis by seeing if you can pg_dump each of
the tables referenced by the failing procedure.  If pg_dump fails with
the same error then it's corrupt data, else not.  If it's a bug, though,
we'd still be needing more info to track it down.  Don't suppose you'd
want to change that specific ERROR to a PANIC so we could get a stack
trace :-(

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8247: Duplicate database names - pg_dump backup fails
Следующее
От: msandeep27@gmail.com
Дата:
Сообщение: BUG #8246: Delete Cascade causing performance issues