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

Here's the full info from 2 different cores:

[root(at)pg8 coredumps]# cat slru.gdb
f 3
p *shared
p pageno
p slotno
p ok
p xid
quit
[root(at)pg8 coredumps]# gdb -x slru.gdb /usr/bin/postmaster core.25146 |tail -n 13

warning: svr4_current_sos: Can't read pathname for load map: Input/output error

#3 0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=162932, 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_CLEAN, SLRU_PAGE_READ_IN_PROGRESS,
SLRU_PAGE_CLEAN, SLRU_PAGE_CLEAN, SLRU_PAGE_DIRTY, SLRU_PAGE_READ_IN_PROGRESS,
SLRU_PAGE_READ_IN_PROGRESS, SLRU_PAGE_CLEAN}, page_number = {162878, 162877, 163050,
162883, 163270, 162761, 162980, 162797}, page_lru_count = {8, 2, 5, 1, 139, 4, 0, 3},
buffer_locks = {24, 25, 26, 27, 28, 29, 30, 31}, latest_page_number = 163270}
$2 = 162932
$3 = 1
$4 = 1 '\001'
$5 = 0
[root(at)pg8 coredumps]# gdb -x slru.gdb /usr/bin/postmaster core.32555 |tail -n 13

warning: svr4_current_sos: Can't read pathname for load map: Input/output error

#3 0x000000000047365f in SimpleLruReadPage (ctl=0x7d9f40, pageno=164152, 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_READ_IN_PROGRESS, SLRU_PAGE_CLEAN,
SLRU_PAGE_CLEAN, SLRU_PAGE_DIRTY, SLRU_PAGE_CLEAN, SLRU_PAGE_CLEAN, SLRU_PAGE_CLEAN,
SLRU_PAGE_CLEAN}, page_number = {164145, 164146, 164147, 164153, 164148, 164150, 164151,
164149}, page_lru_count = {0, 1, 2, 106, 5, 7, 8, 6}, buffer_locks = {24, 25, 26, 27, 28,
29, 30, 31}, latest_page_number = 164153}
$2 = 164152
$3 = 0
$4 = 1 '\001'
$5 = 0
[root(at)pg8 coredumps]#

Also, here's the trace from a 3rd core:

[root(at)pg8 coredumps]# gdb /usr/bin/postgres core.13897
GNU gdb Red Hat Linux (6.3.0.0-1.63rh)
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu"...Using host libthread_db library "/lib64/tls/libthread_db.so.1".

warning: core file may not match specified executable file.
Core was generated by `gdb -q -fullname /usr/bin/postmaster core.25146'.
Program terminated with signal 11, Segmentation fault.
#0 0x0000003b894688e3 in ?? ()
(gdb) bt
#0 0x0000003b894688e3 in ?? ()
#1 0x00000000004f4f20 in ExecReScanHashJoin ()
#2 0x00000000004b593c in DoCopy (stmt=Variable "stmt" is not available.
) at copy.c:767
#3 0x0000000000447190 in _hash_log2 () at hashutil.c:107
#4 0x0000000000000000 in ?? ()
(gdb)

-rw------- 1 root root 29179904 Oct 28 10:08 core.13897
-rw------- 1 root root 1166159872 Oct 28 07:13 core.25146
-rw------- 1 root root 1167413248 Oct 28 09:05 core.32555
--
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