Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

#1

Harco de Hilster <Harco.de.Hilster (AT) ATConsultancy (DOT) nl> writes:

Quote:

(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...3/msg00094.php

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2

That did the trick. Thanks.

Kind regards,

Harco

Tom Lane wrote:

Quote:

Harco de Hilster <Harco.de.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...3/msg00094.php

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292 - 03-23-2006 , 09:21 AM

Re: [BUGS] vacuumdb: ERROR: invalid memory alloc request size 4294967292 - 03-23-2006 , 10:04 AM