Re: AllocSetAlloc() error message

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: AllocSetAlloc() error message
Date: 2003-02-07 03:00:50
Message-ID: 23292.1044586850@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> writes:
> Can someone shed some light on this error message for me (please).
> This is a 7.2.3 debug level 2 output, and my config is

> 2003-02-06 16:15:44 [645] ERROR: Memory exhausted in
> AllocSetAlloc(1073741820)

I think this is a corrupt-data problem: you've probably got a
variable-length datum whose length word is munged to look like a
ridicuously large value. You should be scanning the table to see
where the bad data is.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-07 03:01:52 Re: How many joins is too many joins....
Previous Message Tom Lane 2003-02-07 02:58:09 Re: Dealing with complex queries