Обсуждение: AllocSetAlloc()

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()

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

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

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