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

[PostGIS]

#2985: server crash when analyzing table with 1 row
-----------------------+------------------------------------------
  Reporter:  nkiraly   |      Owner:  pramsey
      Type:  defect    |     Status:  reopened
  Priority:  critical  |  Milestone:  PostGIS 2.2.3
 Component:  postgis   |    Version:  2.1.x
Resolution:            |   Keywords:  analyze server crash freebsd
-----------------------+------------------------------------------

Comment (by ofca):

 After further testing I found out that the crash is not dependant on
 amount of rows, but more likely on amount of data.

 You need at least three rows with geom of size from example to prevent
 crashes, and I managed to find some larger multiline geom, and vacuum
 processed without any problems even tough table contained one row.

 {{{
 template1=# create database testdb;
 CREATE DATABASE
 template1=# create extension postgis;
 CREATE EXTENSION
 template1=# create table test (a integer not null, g geometry);
 CREATE TABLE
 template1=# insert into test values (1,
 '0102000020E6100000010000006D1092A47FF33440AD4ECD9B00334A40');
 INSERT 0 1
 template1=# vacuum FULL ANALYZE VERBOSE test;
 INFO:  vacuuming "public.test"
 INFO:  "test": found 0 removable, 1 nonremovable row versions in 1 pages
 DETAIL:  0 dead row versions cannot be removed yet.
 CPU 0.00s/0.00u sec elapsed 0.00 sec.
 INFO:  analyzing "public.test"
 INFO:  "test": scanned 1 of 1 pages, containing 1 live rows and 0 dead
 rows; 1 rows in sample, 1 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: Succeeded.
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2985#comment:22>
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.