> On Wed, 4 Aug 1999, Bruce Momjian wrote:
>
> > Please send a reproducable sample, with CREATE TABLE, INSERT, etc.
>
> My table is rather large so here's one small sample. This one doesn't
> crash, but it hangs on DELETE using up 100% CPU. This one is tested on
> FreeBSD 3.2-STABLE.
>
> CREATE TABLE Test (
> A INTEGER
> );
Here is a backtrace with gdb:
---------------------------------------------------------------------------
backend> DELETE FROM T1 WHERE Count = 1;
blank
1: ctid (typeid = 27, len = 6, typmod = -1, byval = f)
----
Program received signal SIGSEGV, Segmentation fault.
0x806f640 in heapgettup (relation=0x836d9a8, tuple=0x835756c, dir=1,
buffer=0x8357590, snapshot=0x8357100, nkeys=0, key=0x0) at heapam.c:403
403 if (ItemIdIsUsed(lpp))
(gdb) bt
#0 0x806f640 in heapgettup (relation=0x836d9a8, tuple=0x835756c, dir=1,
buffer=0x8357590, snapshot=0x8357100, nkeys=0, key=0x0) at heapam.c:403
#1 0x8070a6f in heap_getnext (scandesc=0x8357558, backw=0) at heapam.c:903
#2 0x80aca56 in SeqNext (node=0x8357180) at nodeSeqscan.c:100
#3 0x80a7499 in ExecScan (node=0x8357180, accessMtd=0x80ac9c0 <SeqNext>)
at execScan.c:102
#4 0x80acbbb in ExecSeqScan (node=0x8357180) at nodeSeqscan.c:158
#5 0x80a5816 in ExecProcNode (node=0x8357180, parent=0x8357180)
at execProcnode.c:262
#6 0x80a4530 in ExecutePlan (estate=0x8357250, plan=0x8357180,
operation=CMD_DELETE, offsetTuples=0, numberTuples=0,
direction=ForwardScanDirection, destfunc=0x8175f28) at execMain.c:898
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
