Is there any reason can't update to a newer version. Like 8.x?
Geoffrey wrote:
> We continue to have segmentation faults of the /usr/bin/postgres process
> as I mentioned in an earlier thread. In all cases, the core file
> always indicates a segmentation fault, but the backtraces don't seem to
> consistently point to any particular problem. Then again, when you go
> stomping around in memory where you don't belong, all bets are probably off.
>
> I'm wondering out loud (here) if anyone thinks it might have something
> to do with the version we're on? 7.4.7. We are planning to upgrade to
> 7.4.13 soon, but were hoping to address this existing issue first.
>
> It's a bit difficult debugging this issue as I must initiate gdb via the
> client. I have yet to reproduce this problem in my test environment,
> but then again, I'm running my single debugging client, whereas in the
> production system, there could well be 150-200 clients running.
>
> I've attached the latest backtrace, in the event anyone sees anything
> glaringly obvious, please slap me in the head...
>
> Thanks in advance.
>
> --
> Until later, Geoffrey
>
> Those who would give up essential Liberty, to purchase a little
> temporary Safety, deserve neither Liberty nor Safety.
> - Benjamin Franklin
>
> --------------020607020903010406060907
> Content-Type: text/plain; charset=utf-8
> Content-Disposition: inline;
> filename="bt1031"
> X-Google-AttachSize: 5397
>
> Using host libthread_db library "/lib/tls/libthread_db.so.1".
> Core was generated by `postgres: chuck sev [local] SELECT '.
> Program terminated with signal 11, Segmentation fault.
> #0 0x0815c973 in cmtreefree (cm=0x9925064, tree=0x0, level=2)
> at regc_color.c:125
> in regc_color.c
> #0 0x0815c973 in cmtreefree (cm=0x9925064, tree=0x0, level=2)
> at regc_color.c:125
> #1 0x0815c9bc in cmtreefree (cm=0x9925064, tree=0x98a1528, level=1)
> at regc_color.c:131
> #2 0x0815c9bc in cmtreefree (cm=0x9925064, tree=0x9925144, level=0)
> at regc_color.c:131
> #3 0x0815c8f1 in freecm (cm=0x9925064) at regc_color.c:97
> #4 0x0815b458 in rfree (re=0x800) at regcomp.c:2105
> #5 0x08162825 in pg_regfree (re=0x9925064) at regfree.c:53
> #6 0x081aa8ad in RE_compile_and_execute (text_re=0x9f171a0,
> dat=0x800 <Address 0x800 out of bounds>, dat_len=170796744, cflags=11,
> nmatch=0, pmatch=0x0) at regexp.c:212
> #7 0x081aafd2 in texticregexne (fcinfo=0xfeffac80) at regexp.c:387
> #8 0x08107634 in ExecMakeFunctionResult (fcache=0x9f54ff0,
> econtext=0x9f548e8, isNull=0xfeffad9b "", isDone=0x0) at execQual.c:907
> #9 0x081091a0 in ExecEvalExpr (expression=0x9f54ff0, econtext=0x9f548e8,
> isNull=0x0, isDone=0x9925064) at execQual.c:2257
> #10 0x08109dbb in ExecQual (qual=0x9f54b10, econtext=0x9f548e8,
> resultForNull=0 '\0') at execQual.c:2859
> #11 0x0810a1e1 in ExecScan (node=0x9f54860, accessMtd=0x8112150 <SeqNext>)
> at execScan.c:129
> #12 0x08112239 in ExecSeqScan (node=0x800) at nodeSeqscan.c:131
> #13 0x081060d6 in ExecProcNode (node=0x9f54860) at execProcnode.c:306
> #14 0x0810e13b in ExecHash (node=0x9f54730) at nodeHash.c:81
> #15 0x081061b5 in ExecProcNode (node=0x9f54730) at execProcnode.c:364
> #16 0x0810ec6c in ExecHashJoin (node=0x942bbc8) at nodeHashjoin.c:128
> #17 0x08106167 in ExecProcNode (node=0x942bbc8) at execProcnode.c:337
> #18 0x0810f03b in ExecHashJoinOuterGetTuple (node=0x800, hjstate=0x942b460)
> at nodeHashjoin.c:510
> #19 0x0810ea94 in ExecHashJoin (node=0x942b460) at nodeHashjoin.c:152
> #20 0x08106167 in ExecProcNode (node=0x942b460) at execProcnode.c:337
> #21 0x0810d288 in agg_fill_hash_table (aggstate=0x942b850) at nodeAgg.c:905
> #22 0x0810cec7 in ExecAgg (node=0x942b850) at nodeAgg.c:654
> #23 0x0810619b in ExecProcNode (node=0x942b850) at execProcnode.c:356
> #24 0x08104a1d in ExecutePlan (estate=0x942b398, planstate=0x942b850,
> operation=CMD_SELECT, numberTuples=10, direction=2048, dest=0x826d134)
> at execMain.c:1100
> #25 0x08103df8 in ExecutorRun (queryDesc=0x9f17848,
> direction=ForwardScanDirection, count=2048) at execMain.c:249
> #26 0x0817b07b in PortalRunSelect (portal=0x9439c98, forward=0 '\0', count=10,
> dest=0x826d134) at pquery.c:590
> #27 0x0817b6d3 in PortalRunFetch (portal=0x9439c98, fdirection=2048,
> count=2048, dest=0x800) at pquery.c:961
> #28 0x08117c67 in _SPI_cursor_operation (portal=0x9439c98, forward=1 '\001',
> count=10, dest=0x826d134) at spi.c:1315
> #29 0x081171eb in SPI_cursor_fetch (portal=0x800, forward=1 '\001', count=2048)
> at spi.c:881
> #30 0x00a0ca39 in exec_stmt_fors (estate=0xfeffb210, stmt=0x950b188)
> at pl_exec.c:1391
> #31 0x00a0c10e in exec_stmt (estate=0xfeffb210, stmt=0x950b188)
> at pl_exec.c:963
> #32 0x00a0c005 in exec_stmts (estate=0xfeffb210, stmts=0x96fc0d8)
> at pl_exec.c:903
> #33 0x00a0be15 in exec_stmt_block (estate=0xfeffb210, block=0x944ba68)
> at pl_exec.c:859
> #34 0x00a0b061 in plpgsql_exec_function (func=0x96069c8, fcinfo=0xfeffb2f0)
> at pl_exec.c:325
> #35 0x00a07ff4 in plpgsql_call_handler (fcinfo=0xfeffb2f0) at pl_handler.c:124
> #36 0x08107634 in ExecMakeFunctionResult (fcache=0x9f689a0,
> econtext=0x9f68928, isNull=0xfeffb41b "", isDone=0x9f68c30)
> at execQual.c:907
> #37 0x0810918a in ExecEvalExpr (expression=0x9f689a0, econtext=0x9f68928,
> isNull=0x0, isDone=0x9925064) at execQual.c:2253
> #38 0x08109ec4 in ExecTargetList (targetlist=0x9f68b08, targettype=0x9f68b20,
> econtext=0x9f68928, values=0x9f68c00, nulls=0x9f68c18 "",
> itemIsDone=0x9f68c30, isDone=0xfeffb46c) at execQual.c:2984
> #39 0x0810a12a in ExecProject (projInfo=0x0, isDone=0x800) at execQual.c:3130
> #40 0x08111f95 in ExecResult (node=0x9f688a0) at nodeResult.c:155
> #41 0x08106089 in ExecProcNode (node=0x9f688a0) at execProcnode.c:295
> #42 0x08104a1d in ExecutePlan (estate=0x9f68790, planstate=0x9f688a0,
> operation=CMD_SELECT, numberTuples=0, direction=2048, dest=0x94364a8)
> at execMain.c:1100
> #43 0x08103df8 in ExecutorRun (queryDesc=0x94578a8,
> direction=ForwardScanDirection, count=2048) at execMain.c:249
> #44 0x0817b07b in PortalRunSelect (portal=0x9439c10, forward=0 '\0', count=0,
> dest=0x94364a8) at pquery.c:590
> #45 0x0817ae53 in PortalRun (portal=0x9439c10, count=2147483647,
> dest=0x94364a8, altdest=0x800, completionTag=0xfeffb630 "") at pquery.c:478
> #46 0x081777e5 in exec_simple_query (
> query_string=0x9435c00 "SELECT custSprtRpt ('09/27/06','09/27/06')")
> at postgres.c:873
> #47 0x08179f09 in PostgresMain (argc=4, argv=0x93e7608,
> username=0x93e7578 "chuck") at postgres.c:2871
> #48 0x08153c90 in BackendFork (port=0x93fa810) at postmaster.c:2564
> #49 0x08153683 in BackendStartup (port=0x93fa810) at postmaster.c:2207
> #50 0x08151be8 in ServerLoop () at postmaster.c:1119
> #51 0x081512ae in PostmasterMain (argc=5, argv=0x93e6688) at postmaster.c:897
> #52 0x08121163 in main (argc=5, argv=0xfeffc6b4) at main.c:214
>
> --------------020607020903010406060907
> Content-Type: text/plain
> Content-Transfer-Encoding: 8bit
> X-Google-AttachSize: 169
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
> --------------020607020903010406060907--