Thread: BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.
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.
Re: BUG #2510: ERROR: out of memory DETAIL: Failed on request of size 825242672.
From
Tom Lane
Date:
"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