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

PostGIS trac at osgeo.org
Fri Sep 23 00:02:08 PDT 2016


#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):

 Is it possible that we have fixed this issue?

 I just tried with PostGIS 2.2 branch:


 {{{
 ?column?
 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="2.2.3dev r15130" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2,
 08 September 2015" LIBXML="2.9.4" LIBJSON="0.12" 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
 (1 row)
 }}}


 Using ofca's simple:


 {{{
 create table test (a integer not null, g geometry);
 CREATE TABLE
  insert into test values (1,
 '0102000020E6100000010000006D1092A47FF33440AD4ECD9B00334A40');
 vacuum FULL ANALYZE VERBOSE test;
 }}}

 As well as the more extensive  pg93_postgis21_sig10_test.sql​ provided by
 nkiraly

 and I can't get my FreeBSD to crash with either.

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