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

Here's another core... (pid 805 for reference)

#0  0x0000003b8942e37d in raise () from /lib64/tls/libc.so.6
#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=0x325 <Address 0x325 out of bounds>,   errorType=0x325
<Address0x325 out of bounds>,   fileName=0x325 <Address 0x325 out of bounds>, lineNumber=-1) at assert.c:51
 
#3  0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=169039, xid=0) at slru.c:307
#4  0x0000000000473863 in SlruSelectLRUPage (ctl=0x7d9f40, pageno=169162) at slru.c:753
#5  0x0000000000473439 in SimpleLruReadPage (ctl=0x7d9f40, pageno=169162, xid=346445732)   at slru.c:254
#6  0x0000000000473eeb in SubTransGetParent (xid=346445732) at subtrans.c:116
#7  0x0000000000473f61 in SubTransGetTopmostTransaction (xid=Variable "xid" is not available.
) at subtrans.c:153
#8  0x00000000005efa38 in HeapTupleSatisfiesSnapshot (tuple=0x2ac4b87dd0, snapshot=0x877908,   buffer=90248) at
tqual.c:967
#9  0x0000000000447d7a in heapgettup (relation=0x2add20fd98, dir=1, tuple=0x8e7210,   buffer=0x8e7230,
snapshot=0x877908,nkeys=0, key=0x0, pages=435) at heapam.c:305
 
#10 0x0000000000448b53 in heap_getnext (scan=0x8e71e8, 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=0x8b7c38, accessMtd=0x4f7f20 <SeqNext>)   at execScan.c:98
#13 0x00000000004e9c9d in ExecProcNode (node=0x8b7c38) at execProcnode.c:303
#14 0x00000000004f7431 in ExecNestLoop (node=0x8b64b0) at nodeNestloop.c:135
#15 0x00000000004e9c4d in ExecProcNode (node=0x8b64b0) at execProcnode.c:326
#16 0x00000000004f89f9 in ExecSort (node=0x8b6398) at nodeSort.c:102
#17 0x00000000004e9c0a in ExecProcNode (node=0x8b6398) at execProcnode.c:345
#18 0x00000000004f9048 in ExecLimit (node=0x8b6150) at nodeLimit.c:87
#19 0x00000000004e9bb4 in ExecProcNode (node=0x8b6150) at execProcnode.c:369
#20 0x00000000004e8ccd in ExecutorRun (queryDesc=Variable "queryDesc" is not available.
) at execMain.c:1060
#21 0x000000000056968e in PortalRunSelect (portal=0x8ad5a8, forward=Variable "forward" is not available.
) at pquery.c:746
#22 0x0000000000569caf in PortalRun (portal=0x8ad5a8, count=9223372036854775807,   dest=0x8e1870, altdest=0x8e1870,
completionTag=0x7fbfffdfd0"") at pquery.c:561
 
#23 0x0000000000565f12 in exec_simple_query (   query_string=0x89f168 ' ' <repeats 71 times>, "SELECT
a.index,a.jobtype,a.machineindex,a.pid,a.data,a.status,a.starttime,a.ranby,a.clientindex,a.parentindex,a.output_data,a.per"...)
 at postgres.c:933
 
#24 0x0000000000567b33 in PostgresMain (argc=4, argv=0x846368, username=0x846328 "iacm")   at postgres.c:3007
#25 0x000000000053ac70 in ServerLoop () at postmaster.c:2836
#26 0x000000000053c374 in PostmasterMain (argc=5, argv=0x843500) at postmaster.c:918
#27 0x0000000000507fef in main (argc=5, argv=0x843500) at main.c:268

#3  0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=169039, xid=0) at slru.c:307
307                     Assert(shared->page_number[slotno] == pageno &&

$1 = {ControlLock = SubtransControlLock, page_buffer = {0x2a98298380 "", 0x2a9829a380 "",   0x2a9829c380 "",
0x2a9829e380"", 0x2a982a0380 "", 0x2a982a2380 "", 0x2a982a4380 "",   0x2a982a6380 ""}, page_status = {SLRU_PAGE_DIRTY,
SLRU_PAGE_CLEAN,  SLRU_PAGE_READ_IN_PROGRESS, SLRU_PAGE_CLEAN, SLRU_PAGE_CLEAN, SLRU_PAGE_READ_IN_PROGRESS,
SLRU_PAGE_CLEAN,SLRU_PAGE_CLEAN}, page_number = {169452, 169351, 169163, 169238, 169236,   169328, 169233, 169239},
page_lru_count= {17108, 4, 1, 3, 5, 0, 6, 2}, buffer_locks = {   24, 25, 26, 27, 28, 29, 30, 31}, latest_page_number =
169452}
$2 = 169039
$3 = 2
$4 = 1 '\001'
$5 = 0

- 
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-946