[postgis-tickets] [PostGIS] #2267: Server crash from analyze table

[PostGIS]

#2267: Server crash from analyze table
-------------------------------------------+--------------------------------
 Reporter:  peters                         |       Owner:  pramsey
     Type:  defect                         |      Status:  new    
 Priority:  medium                         |   Milestone:         
Component:  postgis                        |     Version:  2.0.x  
 Keywords:  geography point analyze crash  |  
-------------------------------------------+--------------------------------
 Below is simple test case which replicates problem on (2) different
 PostGIS systems running same version. It seems have to have something to
 do with a table containing a geographical point in which x values are
 different but y values are same. May be specific to certain value ranges.

 SELECT version() || ' ' || postgis_full_version();
                                                               PostgreSQL
 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704
 (Red Hat 4.1.2-54), 64-bit POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8"
 PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08"
 LIBXML="2.6.26" LIBJSON="UNKNOWN" RASTER
 (1 row)

 create table foo(g geography(point,4326));

 insert into foo values(st_setsrid(st_makepoint(1.2, 19.8), 4326));

 insert into foo values(st_setsrid(st_makepoint(1.3, 19.8), 4326));

 analyze verbose foo;

 INFO:  analyzing "public.foo"
 INFO:  "foo": scanned 1 of 1 pages, containing 2 live rows and 0 dead
 rows; 2 rows in sample, 2 estimated total rows

 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.
 !> \q

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2267>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.