*Sigh*, still not having much fun over here:

# gdb /usr/local/pgsql/bin/postgres postgres.36561.core 
#0  0x8063b0f in nocachegetattr (tuple=0xbfbfe928, attnum=2, 
    tupleDesc=0x84ca368, isnull=0xbfbfe7af "") at heaptuple.c:494
494                             off = att_addlength(off, att[j]->attlen, tp + off);
(gdb) list
489                              */
490                             off = att_align(off, att[j]->attlen, att[j]->attalign);
491     
492                             att[j]->attcacheoff = off;
493     
494                             off = att_addlength(off, att[j]->attlen, tp + off);
495                     }
496     
497                     return (Datum) fetchatt(&(att[attnum]), tp + att[attnum]->attcacheoff);
498             }
(gdb) bt
#0  0x8063b0f in nocachegetattr (tuple=0xbfbfe928, attnum=2, 
    tupleDesc=0x84ca368, isnull=0xbfbfe7af "") at heaptuple.c:494
#1  0x8075851 in GetIndexValue (tuple=0xbfbfe928, hTupDesc=0x84ca368, 
    attOff=2, attrNums=0x84e9768, fInfo=0x0, attNull=0xbfbfe7af "")
    at indexam.c:445
#2  0x80903be in FormIndexDatum (numberOfAttributes=4, 
    attributeNumber=0x84e9768, heapTuple=0xbfbfe928, heapDescriptor=0x84ca368, 
    datum=0x84e9518, nullv=0x84ba170 "    ", fInfo=0x0) at index.c:1256
#3  0x80a05e6 in vc_repair_frag (vacrelstats=0x84ba290, onerel=0x84c6788, 
    vacuum_pages=0xbfbfe9d0, fraged_pages=0xbfbfe9c0, nindices=1, 
    Irel=0x84ba118) at vacuum.c:1634
#4  0x809e3b9 in vc_vacone (relid=1315147913, analyze=0, va_cols=0x0)
    at vacuum.c:640
#5  0x809d9ac in vc_vacuum (VacRelP=0xbfbfea60, analyze=0 '\000', va_cols=0x0)
    at vacuum.c:299
#6  0x809d934 in vacuum (vacrel=0x84ba0e8 "\030", verbose=1, analyze=0 '\000', 
    va_spec=0x0) at vacuum.c:223
#7  0x810ca8c in ProcessUtility (parsetree=0x84ba110, dest=Remote)
    at utility.c:694
#8  0x810a44e in pg_exec_query_dest (
    query_string=0x81cd370 "VACUUM verbose webhit_details_formatted;", 
    dest=Remote, aclOverride=0) at postgres.c:617
#9  0x810a3a9 in pg_exec_query (
    query_string=0x81cd370 "VACUUM verbose webhit_details_formatted;")
    at postgres.c:562
#10 0x810b336 in PostgresMain (argc=9, argv=0xbfbff0e0, real_argc=10, 
    real_argv=0xbfbffb40) at postgres.c:1588
#11 0x80f0742 in DoBackend (port=0x8464000) at postmaster.c:2009
#12 0x80f02d5 in BackendStartup (port=0x8464000) at postmaster.c:1776
#13 0x80ef4f9 in ServerLoop () at postmaster.c:1037
#14 0x80eeede in PostmasterMain (argc=10, argv=0xbfbffb40) at postmaster.c:725
#15 0x80bf3eb in main (argc=10, argv=0xbfbffb40) at main.c:93
#16 0x8063495 in _start ()
(gdb) 

Isn't there something someone can offer to help track down why this
is happening?  It only seems to happen when we enable a particular
database script, and it always seems to happen while a pg_dump is
going on in the background while performing other updates, or a
vacuum.

All my crashes seem to happen in this file in 'nocachegetattr()',
is there anything I can do to provide more comprehensive error
reporting or something?

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

Mon, 9 Oct 2000 22:42:56 -0700
Alfred Perlstein <bright@wintelcom.net>
more crashes with 7.0.2 from oct 4th-PATCHES