Invalid memory alloc request
От | Guy Helmer |
---|---|
Тема | Invalid memory alloc request |
Дата | |
Msg-id | 4A93EA19.6030304@palisadesys.com обсуждение исходный текст |
Ответы |
Re: Invalid memory alloc request
|
Список | 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
В списке pgsql-general по дате отправления: