[postgis-tickets] [PostGIS] #2985: server crash when analyzing small tables

[PostGIS]

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

Comment (by robe):

 All right this is pretty annoying.  I have a FreeBSD vm that I installed
 9.5 from ports.

 Compiled PostGIS 2.3 (bah for some reason didn't give me raster though I
 installed GDAL) anyrate ran the:


 {{{
 create table test (a integer not null, g geometry);
 insert into test values (1,
 '0102000020E6100000010000006D1092A47FF33440AD4ECD9B00334A40');

 postgis=# insert into test values (1,
 '0102000020E6100000010000006D1092A47FF33440AD4ECD9B00334A40');
 INSERT 0 1
 postgis=# 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
 VACUUM
 }}}


 The darn thing won't crash for me.
 My


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

 -- returns
 ?column?
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  PostgreSQL 9.5.4 on amd64-portbld-freebsd10.1, compiled by FreeBSD clang
 version 3.4.1 (tags/RELEASE_34/dot1-final 208032) 20140512, 64-bit
 POSTGIS="2.3.0dev r15129" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2,
 08 September 2015" LIBXML="2.9.4" LIBJSON="0.12"
 (1 row)
 }}}

 ofca, did you ever try this on 2.3.0 trunk (and on 9.5, I recall you said
 you tried on 9.5), wondering if maybe the issue doesn't exist in 2.3, or
 it has something to do with the fact I didn't get raster enabled, so I ran
 from scripts. I doubt that is it since the regular postgis-2.3.so
 shouldn't have any gdal in it anyway.

 On production server I have, it has 2.2.2 and PostgreSQL 9.3 installed.

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