[postgis-users] postgres server crash caused by postgis collect() function

[Christian Sengstock]

Hi,
i've got a problem with a signal 11 termination of my postgres database. the
error occurs then querying my geo tables with the collect() function of
postgis. anyone knows what the signal 11 error means? i read something about
linking problems, but i can't see why the query is working with some tables
and with others not. following i wrote some details about the problem:

if i use the collect() function on some multistringtables of my database
postgres throws the following error message...

LOG:  server process (PID 1234) was terminated by signal 11
LOG:  terminating any other active server processes
FATAL:  the database system is in recovery mode
LOG:  all server processes terminated; reinitializing
...
following by a postgres recovery start.


the causing queries look like these:
SELECT collect(geom)
FROM streets
GROUP BY name;

however, if i omit the 'group by' statement the query works fine:
SELECT collect(geom) FROM streets;

i have another street table named "roads".  there the above error message
occurs even if i do a
SELECT collect(geom) FROM roads;


my versions and a description of my tables:

Postgis_version: 1.0
USE_GEOS: 1
USE_PROJ: 1
USE_STATS: 1
geos_version: 2.1.1
postgres_version: PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3.5 (Debian 1:3.3.5-13)


*** Table "public.roads"
 Column |       Type        |                       Modifiers
--------+-------------------+--------------------------------------------------------
 gid    | integer           | not null default nextval('public.roads_gid_seq
'::text)
 name   | character varying |
 type   | integer           |
 geom   | geometry          |
 kat    | character varying |
Indexes:
    "roads_pkey" PRIMARY KEY, btree (gid)
    "road_geom_gist" gist (geom)
Check constraints:
    "enforce_geotype_geom" CHECK (geometrytype(geom) =
'MULTILINESTRING'::text OR geom IS NULL)
    "enforce_dims_geom" CHECK (ndims(geom) = 2)
    "enforce_srid_geom" CHECK (srid(geom) = 31467)


*** Table "public.streets2"
   Column   |       Type        |                         Modifiers
------------+-------------------+-----------------------------------------------------------
 gid        | integer           | not null default nextval('
public.streets2_gid_seq'::text)
 name       | character varying |
 st_id      | bigint            |
 oneway     | character varying |
 schall1    | bigint            |
 rauch1     | bigint            |
 car        | character varying |
 ped        | character varying |
 wheel      | character varying |
 cycle      | character varying |
 std_id_old | bigint            |
 stype      | bigint            |
 geom       | geometry          |
Indexes:
    "streets2_pkey" PRIMARY KEY, btree (gid)
    "gist_geom_ops" gist (geom)
Check constraints:
    "enforce_geotype_geom" CHECK (geometrytype(geom) =
'MULTILINESTRING'::text OR geom IS NULL)
    "enforce_dims_geom" CHECK (ndims(geom) = 2)
    "enforce_srid_geom" CHECK (srid(geom) = 31467)



anyone can help?
thanx a lot,
chris




--
Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060119/7ab9d22b/attachment.html>