Invalid memory alloc request

From: Guy Helmer <ghelmer(at)palisadesys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Invalid memory alloc request
Date: 2009-08-25 13:41:45
Message-ID: 4A93EA19.6030304@palisadesys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On systems running Postgresql 8.3.6, I have a nightly backup using
pg_dump that failed on two machines overnight with this error:

pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: invalid memory alloc request size 1376006425
pg_dump: The command was: COPY public.tablename (ts, fn, data, textdata) TO stdout;

The two machines where this occurred have similar, but not identical,
data in this table. Both machines are running FreeBSD 7.1 amd64. I ran
a query "SELECT SUM(LENGTH(data)), SUM(LENGTH(textdata)) FROM tablename"
to sum the length of the data and textdata columns (both of type bytea)
in this table, and the results were around 140MB for the data column and
500MB for the textdata.

I have seen reports of "invalid memory alloc request" errors in the mail
list archives, but those were considered likely to be file corruption or
memory errors. Since this happened simultaneously on two separate
machines, I would not expect these issues to be likely causes.

Any suggestions?

Thanks,
Guy Helmer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Comeau 2009-08-25 14:08:35 Re: New database or New Schema?
Previous Message Devrim GÜNDÜZ 2009-08-25 12:54:49 Re: ETL software and training