Re: Invalid memory alloc request

[Guy Helmer <ghelmer@xxxxxxxxxxxxxxx>]

Title: Email Signature

Tom Lane wrote:

Guy Helmer <ghelmer@xxxxxxxxxxxxxxx> writes:
  

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;
    

Normally I'd say "data corruption", but it is odd if you got the
identical message from two different machines.  Can you reproduce
it with a debugger attached?  If so, a backtrace from the call of
errfinish might be useful.

			regards, tom lane
  

Yes, here is the backtrace.

Thanks for any help!

#0  errfinish (dummy=0) at elog.c:322
#1  0x000000000070e605 in elog_finish (elevel=20,
    fmt=0x80f120 "invalid memory alloc request size %lu") at elog.c:971
#2  0x000000000072e9a6 in MemoryContextAlloc (context=0x802d2e250, size=1376006425)
    at mcxt.c:510                                                              
#3  0x00000000006bbbf4 in byteaout (fcinfo=0x7fffffffdaf0) at varlena.c:197    
#4  0x0000000000714692 in FunctionCall1 (flinfo=0x802ccff18, arg1=34395645151) at fmgr.c:1254
#5  0x0000000000715c45 in OutputFunctionCall (flinfo=0x802ccff18, val=34395645151)
    at fmgr.c:1887                                                             
#6  0x000000000051301c in CopyOneRowTo (cstate=0x802c4bc80, tupleOid=0, values=0x802c4bfb0,
    nulls=0x802cbf880 "") at copy.c:1488                                       
#7  0x0000000000512deb in CopyTo (cstate=0x802c4bc80) at copy.c:1402           
#8  0x0000000000512959 in DoCopyTo (cstate=0x802c4bc80) at copy.c:1252         
#9  0x0000000000512489 in DoCopy (stmt=0x801bfec28,                            
    queryString=0x801bfe030 "COPY public.tablename (ts, caid, casn, fn, data, textdata) TO stdout;") at copy.c:1148                                            
#10 0x0000000000633fa3 in ProcessUtility (parsetree=0x801bfec28,
    queryString=0x801bfe030 "COPY public.tablename (ts, caid, casn, fn, data, textdata) TO stdout;", params=0x0, isTopLevel=1 '\001', dest=0x801bfe850,
    completionTag=0x7fffffffe540 "") at utility.c:712
#11 0x000000000063267e in PortalRunUtility (portal=0x802c61030, utilityStmt=0x801bfec28,
    isTopLevel=1 '\001', dest=0x801bfe850, completionTag=0x7fffffffe540 "") at pquery.c:1173
---Type <return> to continue, or q <return> to quit---
#12 0x00000000006327e3 in PortalRunMulti (portal=0x802c61030, isTopLevel=1 '\001',
    dest=0x801bfe850, altdest=0x801bfe850, completionTag=0x7fffffffe540 "") at pquery.c:1266
#13 0x0000000000631e70 in PortalRun (portal=0x802c61030, count=9223372036854775807,
    isTopLevel=1 '\001', dest=0x801bfe850, altdest=0x801bfe850,
    completionTag=0x7fffffffe540 "") at pquery.c:813
#14 0x000000000062c2ff in exec_simple_query (
    query_string=0x801bfe030 "COPY public.tablename (ts, caid, casn, fn, data, textdata) TO stdout;") at postgres.c:1004
#15 0x000000000063025a in PostgresMain (argc=4, argv=0x801b3a780,
    username=0x801b3a750 "pgsql") at postgres.c:3631
#16 0x00000000005f739f in BackendRun (port=0x801b0a000) at postmaster.c:3207
#17 0x00000000005f691a in BackendStartup (port=0x801b0a000) at postmaster.c:2830
#18 0x00000000005f4526 in ServerLoop () at postmaster.c:1274
#19 0x00000000005f3f5c in PostmasterMain (argc=4, argv=0x7fffffffeb58) at postmaster.c:1029
#20 0x000000000058f34a in main (argc=4, argv=0x7fffffffeb58) at main.c:188