Skip site navigation (1) Skip section navigation (2)

Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Date: 2006-03-23 15:19:37
Message-ID: 9171.1143127177@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Harco de Hilster <Harco(dot)de(dot)Hilster(at)ATConsultancy(dot)nl> writes:
> (gdb) bt
> #0  MemoryContextAlloc (context=0x8b3a10, size=4294967292) at mcxt.c:505
> #1  0x00000000004e06f9 in lazy_vacuum_rel (onerel=0x2a955ecbd8,
>     vacstmt=0x8bf390) at vacuumlazy.c:963

What do you have maintenance_work_mem set to?  If it's larger than 1Gb
you need to back it off, or apply this patch:
http://archives.postgresql.org/pgsql-committers/2006-03/msg00094.php

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Harco de HilsterDate: 2006-03-23 16:02:37
Subject: Re: vacuumdb: ERROR: invalid memory alloc request size 4294967292
Previous:From: Davidson, RobertDate: 2006-03-23 13:30:28
Subject: Re: [SQL] Function Parameters in GROUP BY clause cause errors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group