Thread: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)

psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)

From
Ari Kahn
Date:
I'm doing a query that really should be too taxing. But when I
execute it I get the following error(s):

psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
psql(18967) malloc: *** error: can't allocate region
psql(18967) malloc: *** set a breakpoint in szone_error to debug

EXPLAIN ANALYZE SELECT a1.qname, a1.symbol, a1.num, a1.ge, a1.start,
a1.stop, a1.cr, a1.str, a1.ex
FROM singlehits a1, singlehit_ge a2
WHERE a2.cnt>1 AND a2.symbol=a2.symbol;
                                                              QUERY PLAN
------------------------------------------------------------------------
------------------------------------------------------
Nested Loop  (cost=89.36..6086.42 rows=273312 width=88) (actual
time=0.113..24456.508 rows=54952794 loops=1)
    ->  Seq Scan on singlehits a1  (cost=0.00..530.82 rows=17082
width=88) (actual time=0.043..71.127 rows=17082 loops=1)
    ->  Materialize  (cost=89.36..89.52 rows=16 width=0) (actual
time=0.000..0.418 rows=3217 loops=17082)
          ->  Seq Scan on singlehit_ge a2  (cost=0.00..89.34 rows=16
width=0) (actual time=0.049..5.167 rows=3217 loops=1)
                Filter: ((cnt > 1) AND ((symbol)::text =
(symbol)::text))
Total runtime: 30024.664 ms
(6 rows)

Given this post http://xy1.org/pgsql-general@postgresql.org/
msg01154.html
I tried both VACUUM FULL and ANALYZE on the DB to no avail.
Thanks,
Ari

Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)

From
"Qingqing Zhou"
Date:
"Ari Kahn" <akahn1@gmu.edu> wrote
> I'm doing a query that really should be too taxing. But when I  execute it
> I get the following error(s):
>
> psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
>
> Nested Loop  (cost=89.36..6086.42 rows=273312 width=88) (actual
> time=0.113..24456.508 rows=54952794 loops=1)

Maybe 54952794 rows is too much for your client machine? Try add more memory
slots or increase your vm file size.

Regards,
Qingqing



> "Ari Kahn" <akahn1 ( at ) gmu ( dot ) edu> wrote
> > I'm doing a query that really should be too taxing. But when I
> execute it
> > I get the following error(s):
> >
> > psql(18967) malloc: *** vm_allocate(size=8421376) failed (error
> code=3)
> >
> > Nested Loop  (cost=89.36..6086.42 rows=273312 width=88) (actual
> > time=0.113..24456.508 rows=54952794 loops=1)
>
> Maybe 54952794 rows is too much for your client machine? Try add
> more memory
> slots or increase your vm file size.
>
> Regards,
> Qingqin

I have LOTS of memory (5GB).
What is the appropriate way to add more memory slots?
Or increase my VM file size?

Something in the postgresql.conf?

Thanks,
Ari


Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

From
Qingqing Zhou
Date:

On Wed, 11 Jan 2006, Ari Kahn wrote:

>
> I have LOTS of memory (5GB).
> What is the appropriate way to add more memory slots?
> Or increase my VM file size?
>

Hmm ... What OS are you using?

Regards,
Qingqing

Mac OSX 10.4

On Jan 11, 2006, at 7:09 PM, Qingqing Zhou wrote:

>
>
> On Wed, 11 Jan 2006, Ari Kahn wrote:
>
>>
>> I have LOTS of memory (5GB).
>> What is the appropriate way to add more memory slots?
>> Or increase my VM file size?
>>
>
> Hmm ... What OS are you using?
>
> Regards,
> Qingqing

Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

From
Qingqing Zhou
Date:

On Wed, 11 Jan 2006, Ari Kahn wrote:

> Mac OSX 10.4
>

Seems this is a known problem of Mac. Try to google "vm_allocate failed".

Regards,
Qingqing

Could you be more specific. It seems that lots of people get this
error message on many platforms.
Ari

On Jan 11, 2006, at 7:21 PM, Qingqing Zhou wrote:

>
>
> On Wed, 11 Jan 2006, Ari Kahn wrote:
>
>> Mac OSX 10.4
>>
>
> Seems this is a known problem of Mac. Try to google "vm_allocate
> failed".
>
> Regards,
> Qingqing

Re: psql(18967) malloc: *** vm_allocate(size=8421376) failed (error

From
Qingqing Zhou
Date:

On Wed, 11 Jan 2006, Ari Kahn wrote:

> Could you be more specific. It seems that lots of people get this
> error message on many platforms.

http://groups.google.ca/groups?hl=en&q=vm_allocate%20failed&sa=N&tab=wg

I checked the first several pages. You will most of them point to Mac or
NeXT.

Regards,
Qingqing

Re: psql(18967) malloc: *** vm_allocate(size=8421376)

From
"Brian A. Seklecki"
Date:
What about upping ulimt(3) via ulimit(1) in builtin(1)  -- assuming you're
running Bash.

~BAS

On Mon, 9 Jan 2006, Ari Kahn wrote:

> I'm doing a query that really should be too taxing. But when I execute it I
> get the following error(s):
>
> psql(18967) malloc: *** vm_allocate(size=8421376) failed (error code=3)
> psql(18967) malloc: *** error: can't allocate region
> psql(18967) malloc: *** set a breakpoint in szone_error to debug
>
> EXPLAIN ANALYZE SELECT a1.qname, a1.symbol, a1.num, a1.ge, a1.start, a1.stop,
> a1.cr, a1.str, a1.ex
> FROM singlehits a1, singlehit_ge a2
> WHERE a2.cnt>1 AND a2.symbol=a2.symbol;
>                                                            QUERY PLAN
>
------------------------------------------------------------------------------------------------------------------------------
> Nested Loop  (cost=89.36..6086.42 rows=273312 width=88) (actual
> time=0.113..24456.508 rows=54952794 loops=1)
>  ->  Seq Scan on singlehits a1  (cost=0.00..530.82 rows=17082 width=88)
> (actual time=0.043..71.127 rows=17082 loops=1)
>  ->  Materialize  (cost=89.36..89.52 rows=16 width=0) (actual
> time=0.000..0.418 rows=3217 loops=17082)
>        ->  Seq Scan on singlehit_ge a2  (cost=0.00..89.34 rows=16 width=0)
> (actual time=0.049..5.167 rows=3217 loops=1)
>              Filter: ((cnt > 1) AND ((symbol)::text = (symbol)::text))
> Total runtime: 30024.664 ms
> (6 rows)
>
> Given this post http://xy1.org/pgsql-general@postgresql.org/msg01154.html
> I tried both VACUUM FULL and ANALYZE on the DB to no avail.
> Thanks,
> Ari
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

l8*
     -lava

x.25 - minix - bitnet - plan9 - 110 bps - ASR 33 - base8