[postgis-devel] [PostGIS] #241: ST_LineCrossingDirection Server Crash (Segfault)
PostGIS
trac at osgeo.org
Tue Aug 18 10:03:39 PDT 2009
#241: ST_LineCrossingDirection Server Crash (Segfault)
----------------------+-----------------------------------------------------
Reporter: batzee | Owner: pramsey
Type: defect | Status: new
Priority: critical | Milestone: postgis 1.4.1
Component: postgis | Version: 1.4.X
Keywords: segfault |
----------------------+-----------------------------------------------------
Table definition:
{{{
Spalte | Typ |
Attribute
-------------+------------------------+----------------------------------------------------------------
timeline_id | integer | not null default
nextval('timeline_timeline_id_seq'::regclass)
name | character varying(64) | not null
shortname | character varying(16) | not null
theline | geometry |
visible | boolean | not null default false
country_id | integer |
comment | character varying(256) |
Indexe:
»timeline_pkey« PRIMARY KEY, btree (timeline_id)
»unq_name« UNIQUE, btree (name)
»unq_shortname« UNIQUE, btree (shortname)
Check-Constraints:
»enforce_dims_theline« CHECK (ndims(theline) = 2)
»enforce_geotype_theline« CHECK (geometrytype(theline) =
'LINESTRING'::text OR theline IS NULL)
»enforce_srid_theline« CHECK (srid(theline) = (-1))
Fremdschlüssel-Constraints:
»timeline_country_id_fkey« FOREIGN KEY (country_id) REFERENCES
country(country_id)
}}}
Query:
{{{
select name,st_linecrossingdirection(theline, GeomFromText('LINESTRING(2
53.54,20 53.54)')) from mytable;
}}}
Output in PSQL client:
{{{
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Lost connection to server. Trying to Reset: Failed.
!>
}}}
Output in server logfile (sorry for German..):
{{{
2009-08-18 18:30:58 CEST ANWEISUNG: select * from timeline where
st_linecrossingdirection(theline, GeomFromText('LINESTRING(8 53.54,11
53.54)'));
2009-08-18 18:31:42 CEST LOG: Serverprozess (PID 16539) wurde von Signal
11 beendet: Segmentation fault
2009-08-18 18:31:42 CEST LOG: aktive Serverprozesse werden abgebrochen
2009-08-18 18:31:42 CEST FATAL: das Datenbanksystem ist im
Wiederherstellungsmodus
2009-08-18 18:31:42 CEST LOG: alle Serverprozesse beendet; initialisiere
neu
}}}
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/241>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS
More information about the postgis-devel
mailing list