contrib module intagg crashing the backend

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: contrib module intagg crashing the backend
Date: 2005-03-23 01:21:32
Message-ID: Pine.LNX.4.58.0503221717390.13920@greenie.cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

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?

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.

Thanks,
Ron

% psql fli fli
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.
[...]

fli=# select str_name,int_array_aggregate(tlid) from tlid_streetnames
where str_name='civic center' and tigerfile=6001 group by str_name;
str_name | int_array_aggregate
--------------+-------------------------------------------
civic center | {125030363,125030026,125030039,125050707}
(1 row)

fli=# select str_name,int_array_aggregate(tlid) from tlid_streetnames
where str_name='main' group by str_name;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David B. 2005-03-23 01:59:27 can install pg - it's unbelievable
Previous Message Cade Cairns 2005-03-22 19:13:41 BUG #1558: memory leak in libpq connectDBStart()

Browse pgsql-general by date

  From Date Subject
Next Message Randy Samberg 2005-03-23 01:51:06 postgres oracle emulation question
Previous Message Vernon 2005-03-23 01:05:16 Command prompt window (8.0)