Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559
Date
Msg-id 22255.1371840130@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8245: Urgent:Query on slave failing with invalid memory alloc request size 18446744073709537559  (kapplegate@apsalar.com)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #8247: Duplicate database names - pg_dump backup fails
Next
From: msandeep27@gmail.com
Date:
Subject: BUG #8246: Delete Cascade causing performance issues