[postgis-tickets] [PostGIS] #2985: server crash when analyzing table with 1 row

PostGIS trac at osgeo.org
Fri Oct 31 16:21:30 PDT 2014


#2985: server crash when analyzing table with 1 row
----------------------------------+-----------------------------------------
 Reporter:  nkiraly               |       Owner:  pramsey           
     Type:  defect                |      Status:  new               
 Priority:  critical              |   Milestone:  PostGIS PostgreSQL
Component:  postgis               |     Version:  2.1.x             
 Keywords:  analyze server crash  |  
----------------------------------+-----------------------------------------
 If analyze or vacuum analyze runs on a table with 1 Geography type row,
 there is shared memory corruption reported and postmaster restarts all
 aspects of the server.

 This ONLY happens when
 a table
 has a column with a PostGIS Geography type
 with just 1 row
 is analyzed by autovacuum process or manually.

 Same failures on FreeBSD 10 amd64 with

 PostgreSQL 9.3.4 + PostGIS 2.1.0
 and
 PostgreSQL 9.3.5 + PostGIS 2.1.5

 built from ports.

 Success and failure scenarios attached as SQL statements.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2985>
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.


More information about the postgis-tickets mailing list