[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