Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid memory alloc request size <a_big_number_here>

From: Matteo Beccati <php(at)beccati(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ERROR: invalid memory alloc request size <a_big_number_here>
Date: 2005-10-27 13:25:18
Message-ID: 4360D53E.8030703@beccati.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Martijn van Oosterhout wrote:
> Belay that, you should be able to put a breakpoint on errstart or elog
> or perhaps errmsg. Much easier...

After several tries, I finally found a way to produce a reliable 
backtrace :)


Breakpoint 4, errfinish (dummy=0) at elog.c:346
346                     ImmediateInterruptOK = false;
(gdb) bt
#0  errfinish (dummy=0) at elog.c:346
#1  0x08265896 in elog_finish (elevel=20, fmt=0x831858c "invalid memory 
alloc request size %lu") at elog.c:930
#2  0x0827b5cf in MemoryContextAlloc (context=0x85b2238, 
size=4279476584) at mcxt.c:505
#3  0x080b6a16 in GetMultiXactIdMembers (multi=301994, xids=0xbfbfaba4) 
at multixact.c:935
#4  0x080b6271 in MultiXactIdIsRunning (multi=301994) at multixact.c:373
#5  0x0828347d in HeapTupleSatisfiesUpdate (tuple=0x28ccbb40, curcid=13, 
buffer=756) at tqual.c:620
#6  0x0808f724 in heap_lock_tuple (relation=0x8402988, tuple=0xbfbfad10, 
buffer=0xbfbfad0c, ctid=0xbfbfacf0, update_xmax=0xbfbfacec, cid=13,
     mode=LockTupleShared, nowait=0 '\0') at heapam.c:2055
#7  0x0814153d in ExecutePlan (estate=0x8574018, planstate=0x8574198, 
operation=CMD_SELECT, numberTuples=1, direction=ForwardScanDirection, 
dest=0x831b978)
     at execMain.c:1188
#8  0x081404fb in ExecutorRun (queryDesc=0x8571088, 
direction=ForwardScanDirection, count=1) at execMain.c:230
#9  0x0815ad7e in _SPI_pquery (queryDesc=0x8571088, tcount=1) at spi.c:1558
#10 0x0815ab98 in _SPI_execute_plan (plan=0x8546c18, Values=0xbfbfaf70, 
Nulls=0xbfbfaf30 " ", snapshot=0x0, crosscheck_snapshot=0x0, read_only=0 
'\0',
     tcount=1) at spi.c:1460
#11 0x08158b3c in SPI_execute_snapshot (plan=0x8546c18, 
Values=0xbfbfaf70, Nulls=0xbfbfaf30 " ", snapshot=0x0, 
crosscheck_snapshot=0x0, read_only=0 '\0',
     tcount=1) at spi.c:379
#12 0x08248cd7 in ri_PerformCheck (qkey=0xbfbfcb80, qplan=0x8546c18, 
fk_rel=0x84bdab0, pk_rel=0x8402988, old_tuple=0x0, new_tuple=0xbfbfcef0,
     detectNewRows=0 '\0', expect_OK=5, constrname=0x8547448 "$2") at 
ri_triggers.c:3141
#13 0x08244576 in RI_FKey_check (fcinfo=0xbfbfcc90) at ri_triggers.c:424
#14 0x082445e5 in RI_FKey_check_ins (fcinfo=0xbfbfcc90) at ri_triggers.c:449
#15 0x0812d2a5 in ExecCallTriggerFunc (trigdata=0xbfbfcf30, tgindx=2, 
finfo=0x85475d8, instr=0x0, per_tuple_context=0x85b2568) at trigger.c:1288
#16 0x0812e349 in AfterTriggerExecute (event=0x84284e0, rel=0x84bdab0, 
trigdesc=0x85470e8, finfo=0x85475a8, instr=0x0, per_tuple_context=0x85b2568)
     at trigger.c:2134
#17 0x0812e6f7 in afterTriggerInvokeEvents (events=0x8428118, 
firing_id=2, estate=0x8547018, delete_ok=1 '\001') at trigger.c:2376
#18 0x0812e993 in AfterTriggerEndQuery (estate=0x8547018) at trigger.c:2551
#19 0x0815adf9 in _SPI_pquery (queryDesc=0x8541088, tcount=0) at spi.c:1570
#20 0x0815ab98 in _SPI_execute_plan (plan=0x8531818, Values=0x85234a0, 
Nulls=0x8523490 " Ï\024", snapshot=0x0, crosscheck_snapshot=0x0, 
read_only=0 '\0',
     tcount=0) at spi.c:1460
#21 0x08158a82 in SPI_execute_plan (plan=0x8531818, Values=0x85234a0, 
Nulls=0x8523490 " Ï\024", read_only=0 '\0', tcount=0) at spi.c:336
#22 0x2dc470a6 in exec_stmt_execsql (estate=0xbfbfd330, stmt=0x85287c8) 
at pl_exec.c:2280
#23 0x2dc45312 in exec_stmt (estate=0xbfbfd330, stmt=0x85287c8) at 
pl_exec.c:1076
#24 0x2dc45115 in exec_stmts (estate=0xbfbfd330, stmts=0x8528738) at 
pl_exec.c:991
#25 0x2dc455d5 in exec_stmt_if (estate=0xbfbfd330, stmt=0x852d828) at 
pl_exec.c:1210
#26 0x2dc45218 in exec_stmt (estate=0xbfbfd330, stmt=0x852d828) at 
pl_exec.c:1036
#27 0x2dc45115 in exec_stmts (estate=0xbfbfd330, stmts=0x852d860) at 
pl_exec.c:991
#28 0x2dc44fbb in exec_stmt_block (estate=0xbfbfd330, block=0x852d8a0) 
at pl_exec.c:936
#29 0x2dc446e1 in plpgsql_exec_trigger (func=0x8527018, 
trigdata=0xbfbfd690) at pl_exec.c:562
#30 0x2dc3fcdf in plpgsql_call_handler (fcinfo=0xbfbfd3f0) at 
pl_handler.c:120
#31 0x0812d2a5 in ExecCallTriggerFunc (trigdata=0xbfbfd690, tgindx=3, 
finfo=0x84794d0, instr=0x0, per_tuple_context=0x854fa68) at trigger.c:1288
#32 0x0812e349 in AfterTriggerExecute (event=0x84283a8, rel=0x84969b0, 
trigdesc=0x84790e8, finfo=0x8479488, instr=0x0, per_tuple_context=0x854fa68)
     at trigger.c:2134
#33 0x0812e6f7 in afterTriggerInvokeEvents (events=0x8428110, 
firing_id=0, estate=0x8479018, delete_ok=1 '\001') at trigger.c:2376
#34 0x0812e993 in AfterTriggerEndQuery (estate=0x8479018) at trigger.c:2551
#35 0x0815adf9 in _SPI_pquery (queryDesc=0x84640c8, tcount=0) at spi.c:1570
#36 0x0815ab98 in _SPI_execute_plan (plan=0x8467418, Values=0x843c248, 
Nulls=0x843c238 "  \024", snapshot=0x0, crosscheck_snapshot=0x0, 
read_only=0 '\0',
     tcount=0) at spi.c:1460
#37 0x08158a82 in SPI_execute_plan (plan=0x8467418, Values=0x843c248, 
Nulls=0x843c238 "  \024", read_only=0 '\0', tcount=0) at spi.c:336
#38 0x2dc470a6 in exec_stmt_execsql (estate=0xbfbfda40, stmt=0x8449088) 
at pl_exec.c:2280
#39 0x2dc45312 in exec_stmt (estate=0xbfbfda40, stmt=0x8449088) at 
pl_exec.c:1076
#40 0x2dc45115 in exec_stmts (estate=0xbfbfda40, stmts=0x8448e50) at 
pl_exec.c:991
#41 0x2dc44fbb in exec_stmt_block (estate=0xbfbfda40, block=0x84492b0) 
at pl_exec.c:936
#42 0x2dc43cda in plpgsql_exec_function (func=0x8448018, 
fcinfo=0xbfbfdb30) at pl_exec.c:286
#43 0x2dc3fcf5 in plpgsql_call_handler (fcinfo=0xbfbfdb30) at 
pl_handler.c:123
#44 0x081447e2 in ExecMakeFunctionResult (fcache=0x8436238, 
econtext=0x84361b0, isNull=0x84367e8 "", isDone=0x8436840) at 
execQual.c:1096
#45 0x08145060 in ExecEvalFunc (fcache=0x8436238, econtext=0x84361b0, 
isNull=0x84367e8 "", isDone=0x8436840) at execQual.c:1498
#46 0x0814888a in ExecTargetList (targetlist=0x84366b8, 
econtext=0x84361b0, values=0x84367d8, isnull=0x84367e8 "", 
itemIsDone=0x8436840, isDone=0xbfbfde14)
     at execQual.c:3670
---Type <return> to continue, or q <return> to quit---
#47 0x08148c7c in ExecProject (projInfo=0x84367f8, isDone=0xbfbfde14) at 
execQual.c:3871
#48 0x081544cc in ExecResult (node=0x8436128) at nodeResult.c:157
#49 0x08142c9d in ExecProcNode (node=0x8436128) at execProcnode.c:306
#50 0x08141331 in ExecutePlan (estate=0x8436018, planstate=0x8436128, 
operation=CMD_SELECT, numberTuples=0, direction=ForwardScanDirection, 
dest=0x83d38e0)
     at execMain.c:1102
#51 0x081404fb in ExecutorRun (queryDesc=0x8466c40, 
direction=ForwardScanDirection, count=0) at execMain.c:230
#52 0x081de829 in PortalRunSelect (portal=0x842a018, forward=1 '\001', 
count=0, dest=0x83d38e0) at pquery.c:794
#53 0x081de519 in PortalRun (portal=0x842a018, count=2147483647, 
dest=0x83d38e0, altdest=0x83d38e0, completionTag=0xbfbfe080 "") at 
pquery.c:611
#54 0x081da2a5 in exec_simple_query (query_string=0x83d3120 "SELECT 
gw_queue_ok('1363827', 'OK 3000')") at postgres.c:1014
#55 0x081dd220 in PostgresMain (argc=4, argv=0x83643d0, 
username=0x83643a0 "multilevel") at postgres.c:3168
#56 0x081b01ea in BackendRun (port=0x8361200) at postmaster.c:2855
#57 0x081af7d3 in BackendStartup (port=0x8361200) at postmaster.c:2498
#58 0x081ad86b in ServerLoop () at postmaster.c:1231
#59 0x081ad0eb in PostmasterMain (argc=3, argv=0xbfbfed3c) at 
postmaster.c:943
#60 0x08163962 in main (argc=3, argv=0xbfbfed3c) at main.c:256


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2005-10-27 13:29:54
Subject: Re: localhost in pgpass file?
Previous:From: Martijn van OosterhoutDate: 2005-10-27 13:18:41
Subject: Re: ERROR: invalid memory alloc request size <a_big_number_here>

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group