Tom Lane wrote:
Guy Helmer <ghel...@palisadesys.com> 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