Re: TRAP: FailedAssertion("!((itemid)->lp_flags & 0x01)",

On Fri, Oct 28, 2005 at 03:04:02PM -0400, Tom Lane wrote:
> BTW, what's the stack trace in those two core files?

From 25146:
#0  0x0000003b8942e37d in raise () from /lib64/tls/libc.so.6
#1  0x0000003b8942faae in abort () from /lib64/tls/libc.so.6
#2  0x00000000005d36f8 in ExceptionalCondition (   conditionName=0x623a <Address 0x623a out of bounds>,
errorType=0x623a<Address 0x623a out of bounds>,   fileName=0x623a <Address 0x623a out of bounds>, lineNumber=-1) at
assert.c:51
#3  0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=162932, xid=0) at slru.c:307
#4  0x0000000000473863 in SlruSelectLRUPage (ctl=0x7d9f40, pageno=163131) at slru.c:753
#5  0x0000000000473439 in SimpleLruReadPage (ctl=0x7d9f40, pageno=163131, xid=334094300)   at slru.c:254
#6  0x0000000000473eeb in SubTransGetParent (xid=334094300) at subtrans.c:116
#7  0x0000000000473f61 in SubTransGetTopmostTransaction (xid=Variable "xid" is not available.
) at subtrans.c:153
#8  0x00000000005efa38 in HeapTupleSatisfiesSnapshot (tuple=0x2ac2fb04b0, snapshot=0x88ab98,   buffer=86685) at
tqual.c:967
#9  0x0000000000447d7a in heapgettup (relation=0x2add22b960, dir=1, tuple=0x8c4a90,   buffer=0x8c4ab0,
snapshot=0x88ab98,nkeys=0, key=0x0, pages=597) at heapam.c:305
 
#10 0x0000000000448b53 in heap_getnext (scan=0x8c4a68, direction=Variable "direction" is not available.
) at heapam.c:832
#11 0x00000000004f7f86 in SeqNext (node=Variable "node" is not available.
) at nodeSeqscan.c:102
#12 0x00000000004eec2e in ExecScan (node=0x8c3b68, accessMtd=0x4f7f20 <SeqNext>)   at execScan.c:98
#13 0x00000000004e9c9d in ExecProcNode (node=0x8c3b68) at execProcnode.c:303
#14 0x00000000004f2a75 in ExecAgg (node=0x8c3610) at nodeAgg.c:783
#15 0x00000000004e9bea in ExecProcNode (node=0x8c3610) at execProcnode.c:353
#16 0x00000000004e8ccd in ExecutorRun (queryDesc=Variable "queryDesc" is not available.
) at execMain.c:1060
#17 0x000000000056968e in PortalRunSelect (portal=0x8acb38, forward=Variable "forward" is not available.
) at pquery.c:746
#18 0x0000000000569caf in PortalRun (portal=0x8acb38, count=9223372036854775807,   dest=0x8bbae0, altdest=0x8bbae0,
completionTag=0x7fbfffdfd0"") at pquery.c:561
 
#19 0x0000000000565f12 in exec_simple_query (   query_string=0x89e0b8 "SELECT count(*) as cnt FROM queue where
machineindex= '32'")   at postgres.c:933
 
#20 0x0000000000567b33 in PostgresMain (argc=4, argv=0x846368, username=0x846328 "iacm")   at postgres.c:3007
#21 0x000000000053ac70 in ServerLoop () at postmaster.c:2836
#22 0x000000000053c374 in PostmasterMain (argc=5, argv=0x843500) at postmaster.c:918
#23 0x0000000000507fef in main (argc=5, argv=0x843500) at main.c:268

And 32555:
#0  0x0000003b8942e37d in raise () from /lib64/tls/libc.so.6
(gdb) bt
#0  0x0000003b8942e37d in raise () from /lib64/tls/libc.so.6
#1  0x0000003b8942faae in abort () from /lib64/tls/libc.so.6
#2  0x00000000005d36f8 in ExceptionalCondition (   conditionName=0x7f2b <Address 0x7f2b out of bounds>,
errorType=0x7f2b<Address 0x7f2b out of bounds>,   fileName=0x7f2b <Address 0x7f2b out of bounds>, lineNumber=-1) at
assert.c:51
#3  0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=164152, xid=0) at slru.c:307
#4  0x0000000000473863 in SlruSelectLRUPage (ctl=0x7d9f40, pageno=164037) at slru.c:753
#5  0x0000000000473439 in SimpleLruReadPage (ctl=0x7d9f40, pageno=164037, xid=335949336)   at slru.c:254
#6  0x0000000000473eeb in SubTransGetParent (xid=335949336) at subtrans.c:116
#7  0x0000000000473f61 in SubTransGetTopmostTransaction (xid=Variable "xid" is not available.
) at subtrans.c:153
#8  0x00000000005ef963 in HeapTupleSatisfiesSnapshot (tuple=0x2abc81e0b8, snapshot=0x8788d8,   buffer=73427) at
tqual.c:905
#9  0x0000000000448dc6 in heap_release_fetch (relation=0x2add227130, snapshot=0x8788d8,   tuple=0x8d2460,
userbuf=0x8d2480,keep_buf=1 '\001', pgstat_info=0x8d24b8) at heapam.c:979
 
#10 0x0000000000450c8f in index_getnext (scan=0x8d2418, direction=ForwardScanDirection)   at indexam.c:528
#11 0x00000000004f5012 in IndexNext (node=0x8d18c0) at nodeIndexscan.c:316
#12 0x00000000004eec2e in ExecScan (node=0x8d18c0, accessMtd=0x4f4f20 <IndexNext>)   at execScan.c:98
#13 0x00000000004e9c8d in ExecProcNode (node=0x8d18c0) at execProcnode.c:307
#14 0x00000000004e8ccd in ExecutorRun (queryDesc=Variable "queryDesc" is not available.
) at execMain.c:1060
#15 0x000000000056968e in PortalRunSelect (portal=0x8add58, forward=Variable "forward" is not available.
) at pquery.c:746
#16 0x0000000000569caf in PortalRun (portal=0x8add58, count=9223372036854775807,   dest=0x8e5c48, altdest=0x8e5c48,
completionTag=0x7fbfffdfd0"") at pquery.c:561
 
#17 0x0000000000565f12 in exec_simple_query (   query_string=0x89f2d8 "select index from daily_reports where
accountindex= '3034' and date = '1130040000'") at postgres.c:933
 
#18 0x0000000000567b33 in PostgresMain (argc=4, argv=0x846368, username=0x846328 "iacm")   at postgres.c:3007
#19 0x000000000053ac70 in ServerLoop () at postmaster.c:2836
#20 0x000000000053c374 in PostmasterMain (argc=5, argv=0x843500) at postmaster.c:918
#21 0x0000000000507fef in main (argc=5, argv=0x843500) at main.c:268

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461