[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