postmaster core dump - Mailing list pgsql-hackers

I seem to have an unhappy postgresql:

(gdb) bt
#0  0xbd99871b in kill () from /usr/lib/libc.so.12
#1  0xbda217e7 in abort () from /usr/lib/libc.so.12
#2  0x0820c1fa in ExceptionalCondition (   conditionName=0x8298920 "!(batchno > hashtable->curbatch)",
errorType=0x823919f"FailedAssertion",    fileName=0x82988e0 "/usr/src/local/pgsql/src/backend/executor/nodeHash.c",
lineNumber=675)at /usr/src/local/pgsql/src/backend/utils/error/assert.c:51
 
#3  0x08136c09 in ExecHashTableInsert (hashtable=0x83e9c9c, tuple=0x83e9ce8,    hashvalue=4294941132)   at
/usr/src/local/pgsql/src/backend/executor/nodeHash.c:679
#4  0x081363e1 in MultiExecHash (node=0x83e91b4)   at /usr/src/local/pgsql/src/backend/executor/nodeHash.c:114
#5  0x0812c24f in MultiExecProcNode (node=0x83e91b4)   at /usr/src/local/pgsql/src/backend/executor/execProcnode.c:439
#6  0x0813707a in ExecHashJoin (node=0x83e65ac)   at /usr/src/local/pgsql/src/backend/executor/nodeHashjoin.c:160
#7  0x0812c11a in ExecProcNode (node=0x83e65ac)   at /usr/src/local/pgsql/src/backend/executor/execProcnode.c:358
#8  0x081348f5 in agg_fill_hash_table (aggstate=0x83e62b4)   at
/usr/src/local/pgsql/src/backend/executor/nodeAgg.c:911
#9  0x081345fb in ExecAgg (node=0x83e62b4)   at /usr/src/local/pgsql/src/backend/executor/nodeAgg.c:681
#10 0x0812c152 in ExecProcNode (node=0x83e62b4)   at /usr/src/local/pgsql/src/backend/executor/execProcnode.c:377
#11 0x0812aa2b in ExecutePlan (estate=0x83e601c, planstate=0x83e62b4,    operation=CMD_SELECT, numberTuples=0,
direction=ForwardScanDirection,   dest=0x83d8d8c)   at /usr/src/local/pgsql/src/backend/executor/execMain.c:1110
 
#12 0x08129dc7 in ExecutorRun (queryDesc=0x83db848,    direction=ForwardScanDirection, count=0)   at
/usr/src/local/pgsql/src/backend/executor/execMain.c:231
#13 0x081a89a3 in PortalRunSelect (portal=0x83e401c, forward=1 '\001',    count=2147483647, dest=0x83d8d8c)   at
/usr/src/local/pgsql/src/backend/tcop/pquery.c:797
#14 0x081a8758 in PortalRun (portal=0x83e401c, count=2147483647,    dest=0x83d8d8c, altdest=0x83d8d8c,
completionTag=0xbfbfe1d0"")   at /usr/src/local/pgsql/src/backend/tcop/pquery.c:648
 
#15 0x081a4c2f in exec_simple_query (   query_string=0x834501c "select timesliced, count(stats_id) from trans left j
       /*        * put the tuple into a temp file for later batches        */        Assert(batchno >
hashtable->curbatch);      ExecHashJoinSaveTuple(tuple, hashvalue,
&hashtable->innerBatchFile[batchno]);

(gdb) print batchno
$2 = 2
(gdb) print *hashtable
$3 = {nbuckets = 2063, buckets = 0x83f601c, nbatch = 16, curbatch = 3,  nbatch_original = 16, nbatch_outstart = 16,
growEnabled= 1 '\001',  totalTuples = 25998, innerBatchFile = 0x83f401c, outerBatchFile = 0x83f4068,  hashfunctions =
0x83ea0a4,spaceUsed = 136816, spaceAllowed = 1048576,  hashCxt = 0x835a648, batchCxt = 0x835a6d4}
 

cvs of 1 Sept, nodeHash.c v 1.94

Any thoughts?

Cheers,

Patrick