Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] My postmaster just crashed !

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: postgresql <pgsql-general(at)postgresql(dot)org>,pgsql-bugs(at)postgresql(dot)org
Subject: Re: [GENERAL] My postmaster just crashed !
Date: 2005-01-27 17:52:37
Message-ID: 20050127175237.GA39702@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
[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/

In response to

Responses

pgsql-bugs by date

Next:From: PFCDate: 2005-01-27 18:24:37
Subject: Re: [GENERAL] My postmaster just crashed !
Previous:From: Michael FuhrDate: 2005-01-27 17:23:36
Subject: Re: 8.0.0 make check fails on Solaris 9 (sparc)

pgsql-general by date

Next:From: Bruno Wolff IIIDate: 2005-01-27 18:00:16
Subject: Re: pg_dump shell script with ~/.pgpass
Previous:From: Andre SchnoorDate: 2005-01-27 17:47:07
Subject: Moving from Sybase to PostgreSQL - Stored Procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group