[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:  blocker                                     |   Milestone:  PostGIS 2.0.4
Component:  postgis                                     |     Version:  2.0.x        
 Keywords:  centos rhel5 geography point analyze crash  |  
--------------------------------------------------------+-------------------
Changes (by robe):

  * keywords:  geography point analyze crash => centos rhel5 geography
               point analyze crash


Comment:

 FWIW:

 I have PostGIS compiled under mingw64 using GCC 4.5.4 but deployed on VC++
 compiled PostgreSQL.

 I tried on my 9.2.2 Windows 7

 {{{
 SELECT version() || ' ' || postgis_full_version();

 PostgreSQL 9.2.2, compiled by Visual C++ build 1600, 64-bit POSTGIS="2.0.3
 r11132" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0, 6 March 2012"
 GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8" LIBJSON="UNKNOWN"
 RASTER
 }}}


 and my windows 2008 64-bit

 {{{
 PostgreSQL 9.2.4, compiled by Visual C++ build 1600, 64-bit
 POSTGIS="2.0.2SVN r10643" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0,
 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
 LIBJSON="UNKNOWN" (core procs from "2.0.1 r9979" need upgrade) RASTER
 (raster procs from "2.0.1 r9979" need upgrade)
 }}}

 and doesn't seem to crash on either of them even after running multiple
 times.  So might be specific to Centos or Redhat I guess.


 Tried my 2.1 build on windows 7 64-bit and didn't see any crashes.

 Bborie,
 You've got every VM under the sun :) You wouldn't happen to have a CentOS
 5 64-bit one too would you?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2267#comment:11>
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.