[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