Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table - Mailing list pgsql-performance

From Tom Lane
Subject Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
Date
Msg-id 13448.1194908062@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table  (Stephane Bailliez <sbailliez@gmail.com>)
Responses Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
List pgsql-performance
Stephane Bailliez <sbailliez@gmail.com> writes:
> ERROR: invalid memory alloc request size 1664639562

This sounds like corrupt data --- specifically, 1664639562 showing
up where a variable-width field's length word ought to be.  It
may or may not be relevant that the ASCII equivalent of that bit
pattern is Jb8c ... do you work with data that contains such
substrings?

> Sometimes I do get:
> ERROR: unexpected end of data

If it's not 100% repeatable I'd start to wonder about flaky hardware.
Have you run memory and disk diagnostics on this machine recently?

            regards, tom lane

pgsql-performance by date:

Previous
From: Stephane Bailliez
Date:
Subject: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table
Next
From: Rafael Martinez
Date:
Subject: Re: Need to run CLUSTER to keep performance