BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.

Started by alex tsaialmost 20 years ago2 messagesbugs
Jump to latest
#1alex tsai
alex_tsai@pisem.net

The following bug has been logged online:

Bug reference: 2510
Logged by: alex tsai
Email address: alex_tsai@pisem.net
PostgreSQL version: 8.1.4
Operating system: FreeBSD 6.1 stable
Description: ERROR: out of memory DETAIL: Failed on request of size
825242672.
Details:

I'm having a trouble trying to insert a tuple.
I'm getting this kind of error "ERROR: out of memory DETAIL: Failed on
request of size 825242672".
What could it be?
the table i'm working with has already 4629138 tuples.
When i terminate my program and start it again everything work fine for
another couple of minutes and then i'm get the same error.

CONTEXT: SQL statement "INSERT INTO billing.calls(id_ats, btime, etime, tt,
ts, indexa, phonea, indexb, phoneb, cc, value, restart) VALUES ( $1 , $2 ,
$3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 )"

Sincerely, Alex Tsai.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: alex tsai (#1)
Re: BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.

"alex tsai" <alex_tsai@pisem.net> writes:

I'm having a trouble trying to insert a tuple.
I'm getting this kind of error "ERROR: out of memory DETAIL: Failed on
request of size 825242672".
What could it be?

You haven't really provided enough info to let anyone help you, but
sometimes this sort of error is a symptom of corrupt data. If you try
to pg_dump the table, does it work?

regards, tom lane