more crashes with 7.0.2 from oct 4th-PATCHES

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема more crashes with 7.0.2 from oct 4th-PATCHES
Дата
Msg-id 20001009224256.I272@fw.wintelcom.net
обсуждение исходный текст
Список pgsql-hackers
*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."


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: My new job
Следующее
От: Philip Warner
Дата:
Сообщение: CVS broken?