Re: invalid memory alloc request size 1765277700 Error Question - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid memory alloc request size 1765277700 Error Question
Date
Msg-id 23548.1330108996@sss.pgh.pa.us
Whole thread Raw
In response to Re: invalid memory alloc request size 1765277700 Error Question  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Fri, Feb 24, 2012 at 10:09 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Naoko Reeves <naokoreeves@gmail.com> writes:
>>> [ inconsistent behavior with a corrupted table ]

>> I think most likely some of these queries are using a corrupted index
>> and some are not --- have you looked at the EXPLAIN for each one?
>> It might be a good idea to turn off enable_indexscan and
>> enable_bitmapscan while poking at the table.

> Could it also be a corrupted toast table?

The toast table might well be corrupted, but that wouldn't explain the
variation in behavior when fetching the "same" row.  I'm inclined to
think that Naoko has got more than one apparently-live row with the
same id value, as a result of corruption of xmin/xmax values or commit
hint bits.  Not sure how to explain all the symptoms though.

            regards, tom lane

pgsql-general by date:

Previous
From: Willem Buitendyk
Date:
Subject: Re: Upgrade to 9.1 causing function problem
Next
From: Prashant Bharucha
Date:
Subject: Maxium Share Memory in Debian 64bit