PostgreSQL just quit on me unexpectedly for the first time ever. I have no doubt I did something stupid to cause it,
butI can't find any clues in error logs. Here is a backtrace of the core file, I am wondering if it tells anyone
anything.
I hacked my pltcl.so the other day, but all has been well up to now. I added a few SPI_freetuptable() to keep pltcl
fromhogging all the memory. I wonder if I hacked it a little wrong.
version
-----------------------------------------------------------------
PostgreSQL 7.2.1 on i386--netbsdelf, compiled by GCC egcs-1.1.2
Reading symbols from /usr/pkg/lib/postgresql/ltree.so...
(no debugging symbols found)...done.
#0 0x814955a in pfree ()
(gdb) bt
#0 0x814955a in pfree ()
#1 0x8149390 in MemoryContextDelete ()
#2 0x80c8411 in SPI_freetuptable ()
#3 0x4836c418 in pltclu_call_handler ()
#4 0x4838abb9 in TclInvokeStringCommand ()
#5 0x483a43d9 in TclExecuteByteCode ()
#6 0x4838b590 in Tcl_EvalObjEx ()
#7 0x483c67d7 in TclObjInterpProc ()
#8 0x483bfa24 in EvalObjv ()
#9 0x483c00ba in Tcl_EvalEx ()
#10 0x483c03a2 in Tcl_Eval ()
#11 0x4838caf0 in Tcl_GlobalEval ()
#12 0x4836af88 in pltclu_call_handler ()
#13 0x4836a6af in pltcl_call_handler ()
#14 0x80b6d17 in ExecCallTriggerFunc ()
#15 0x80b71ff in ExecBRUpdateTriggers ()
#16 0x80bdc53 in ExecReplace ()
#17 0x80bd996 in ExecutePlan ()
#18 0x80bcf27 in ExecutorRun ()
#19 0x80c8d3b in _SPI_pquery ()
#20 0x80c8a0b in _SPI_execute ()
#21 0x80c7899 in SPI_exec ()
#22 0x4836c0e2 in pltclu_call_handler ()
---Type <return> to continue, or q <return> to quit---
#23 0x4838abb9 in TclInvokeStringCommand ()
#24 0x483a43d9 in TclExecuteByteCode ()
#25 0x4838b590 in Tcl_EvalObjEx ()
#26 0x483c67d7 in TclObjInterpProc ()
#27 0x483bfa24 in EvalObjv ()
#28 0x483c00ba in Tcl_EvalEx ()
#29 0x483c03a2 in Tcl_Eval ()
#30 0x4838caf0 in Tcl_GlobalEval ()
#31 0x4836a991 in pltclu_call_handler ()
#32 0x4836a6c0 in pltcl_call_handler ()
#33 0x80bf68b in ExecMakeFunctionResult ()
#34 0x80bf72e in ExecEvalFunc ()
#35 0x80bfc41 in ExecEvalExpr ()
#36 0x80bfef5 in ExecTargetList ()
#37 0x80c013d in ExecProject ()
#38 0x80c50dc in ExecResult ()
#39 0x80be72a in ExecProcNode ()
#40 0x80bd9fd in ExecutePlan ()
#41 0x80bcf27 in ExecutorRun ()
#42 0x8105cd6 in ProcessQuery ()
#43 0x81045f9 in pg_exec_query_string ()
#44 0x8105560 in PostgresMain ()
#45 0x80ed60f in DoBackend ()
---Type <return> to continue, or q <return> to quit---
#46 0x80ecfc9 in BackendStartup ()
#47 0x80ec2e0 in ServerLoop ()
#48 0x80ebefe in PostmasterMain ()
#49 0x80cd67f in main ()
#50 0x80673f9 in ___start ()
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
iharding@tpchd.org
WWSD - What Would Scooby Doo?
