postmaster core dump - Mailing list pgsql-hackers
From | Patrick Welche |
---|---|
Subject | postmaster core dump |
Date | |
Msg-id | 20050919171254.GD11141@quartz.itdept.newn.cam.ac.uk Whole thread Raw |
Responses |
Re: postmaster core dump
Re: postmaster core dump |
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
pgsql-hackers by date: