AllocSetAlloc()

Started by Antonis Antoniouabout 25 years ago4 messagesgeneral
Jump to latest
#1Antonis Antoniou
a.antoniou@albourne.com

Hi,
I would like to know what is causing this error. The machine has 1GB of
memory and I use PostgreSQL 7.1beta4.
The same function on PostgreSQL 7.0.2 works ok. Could someone explain
me what this error means and where to look in order to solve it?

select function_name;
ERROR: Memory exhausted in AllocSetAlloc()

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Antonis Antoniou (#1)
Re: AllocSetAlloc()

Antonis Antoniou <a.antoniou@albourne.com> writes:

I would like to know what is causing this error. The machine has 1GB of
memory and I use PostgreSQL 7.1beta4.
The same function on PostgreSQL 7.0.2 works ok. Could someone explain
me what this error means and where to look in order to solve it?
select function_name;
ERROR: Memory exhausted in AllocSetAlloc()

If it worked in 7.0 and fails now, then that probably means we have a
bug to fix. May we see a complete, reproducible example?

regards, tom lane

#3Karel Zak
zakkr@zf.jcu.cz
In reply to: Tom Lane (#2)
Re: AllocSetAlloc()

On Wed, 21 Feb 2001, Tom Lane wrote:

Antonis Antoniou <a.antoniou@albourne.com> writes:

I would like to know what is causing this error. The machine has 1GB of
memory and I use PostgreSQL 7.1beta4.
The same function on PostgreSQL 7.0.2 works ok. Could someone explain
me what this error means and where to look in order to solve it?
select function_name;
ERROR: Memory exhausted in AllocSetAlloc()

If it worked in 7.0 and fails now, then that probably means we have a
bug to fix. May we see a complete, reproducible example?

This error returns aset.c only if malloc() ruturs NULL. Not is a proble in
OS/libs?

Karel

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Karel Zak (#3)
Re: AllocSetAlloc()

Karel Zak <zakkr@zf.jcu.cz> writes:

On Wed, 21 Feb 2001, Tom Lane wrote:
ERROR: Memory exhausted in AllocSetAlloc()

If it worked in 7.0 and fails now, then that probably means we have a
bug to fix. May we see a complete, reproducible example?

This error returns aset.c only if malloc() ruturs NULL. Not is a proble in
OS/libs?

Not necessarily. Certainly aset.c thinks it's run out of memory, but why?
It could be some bit of our code computing a ridiculous request size,
for example, or a serious memory leak under the right conditions.
That's why I want to see Antonis' example.

regards, tom lane