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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461