On Tue, Mar 22, 2005 at 05:21:32PM -0800, Ron Mayer wrote:
> If one of the contrib modules (int_array_aggregate in contrib/intagg) is
> crashing my backend, where's a good place to report a bug or get hints
> where to look further?
Bug reports should go to the pgsql-bugs mailing list (I've cc'd it
on this message). Searching the list archives for similar problems
can be helpful.
If the backend crashed then there might be a core dump somewhere
under the $PGDATA directory. Using a debugger like gdb to get a
stack trace from the core dump can help pinpoint the problem.
> It seems to work fine on small arrays, but crashes on large ones.
> The second query would have put about 500 rows in the aggregate.
I can duplicate the crash in 8.0.1 (REL8_0_STABLE) with the following
(512 works, 513 crashes):
CREATE TABLE foo (id integer, name text);
INSERT INTO foo (id, name)
SELECT x, 'test' FROM generate_series(1, 513) AS g(x);
SELECT name, int_array_aggregate(id) FROM foo GROUP BY name;
Here's a partial stack trace:
#0 0x81e003b in pfree (pointer=0x839f130) at mcxt.c:583
#1 0x810d044 in advance_transition_function (aggstate=0x839d188, peraggstate=0x839d908,
pergroupstate=0x83a1aa0, newVal=513, isNull=0 '\000') at nodeAgg.c:395
#2 0x810d0f4 in advance_aggregates (aggstate=0x839d188, pergroup=0x83a1aa0) at nodeAgg.c:439
#3 0x810d782 in agg_fill_hash_table (aggstate=0x839d188) at nodeAgg.c:935
#4 0x810d448 in ExecAgg (node=0x839d188) at nodeAgg.c:674
Line 583 in mcxt.c is:
(*header->context->methods->free_p) (header->context, pointer);
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-03-23 05:10:20|
|Subject: Re: [GENERAL] contrib module intagg crashing the backend |
|Previous:||From: Michael Fuhr||Date: 2005-03-23 03:07:13|
|Subject: Re: BUG #1547: CREATE TYPE AS error|
pgsql-general by date
|Next:||From: Greg Stark||Date: 2005-03-23 04:23:15|
|Subject: Re: checkpoint_timeout|
|Previous:||From: Tom Lane||Date: 2005-03-23 03:49:49|
|Subject: Re: checkpoint_timeout |