Here's the full info from 2 different cores:
[EMAIL PROTECTED] coredumps]# cat slru.gdb
f 3
p *shared
p pageno
p slotno
p ok
p xid
quit
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] coredumps]#
Also, here's the trace from a 3rd core:
[EMAIL PROTECTED] 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 [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
