Re: My postmaster just crashed !

[I've Cc'ed pgsql-bugs and set the Reply-To header to that list.]

On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
>
>     It seems that contrib/intagg crashes my server :
> -------------------------------------------------------------------------
> select int_agg_final_array(1);
> server closed the connection unexpectedly

I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on Solaris 9
and FreeBSD 4.11.  Here's part of the backtrace from the core dump on
FreeBSD:

(gdb) bt
#0  0x285077f4 in ShrinkPGArray (p=0x1) at int_aggregate.c:130
#1  0x28507929 in int_agg_final_array (fcinfo=0xbfbfeb90) at int_aggregate.c:177
#2  0x8106db8 in ExecMakeFunctionResult (fcache=0x83410a0, econtext=0x83411e8,
    isNull=0xbfbfecef "\b0í¿¿¯K\024\b¸z3\bï\003", isDone=0x0) at execQual.c:1042
#3  0x8107583 in ExecEvalFunc (fcache=0x83410a0, econtext=0x83411e8,
    isNull=0xbfbfecef "\b0í¿¿¯K\024\b¸z3\bï\003", isDone=0x0) at execQual.c:1459
#4  0x8108beb in ExecEvalExprSwitchContext (expression=0x83410a0, econtext=0x83411e8,
    isNull=0xbfbfecef "\b0í¿¿¯K\024\b¸z3\bï\003", isDone=0x0) at execQual.c:2781
#5  0x8145353 in evaluate_expr (expr=0x8337ab8, result_type=1007) at clauses.c:2399

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/