[postgis-tickets] [PostGIS] #3395: PostGIS 2.2.0 upgrade issue

[PostGIS]

#3395: PostGIS 2.2.0 upgrade issue
---------------------+---------------------------
 Reporter:  peters   |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.2.1
Component:  postgis  |    Version:  2.2.x
 Keywords:           |
---------------------+---------------------------
 I am currently running PostGIS 2.1.8:

 POSTGIS="2.1.8 r13780" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6
 March 2012" GDAL="GDAL 1.11.2, released 2015/02/10" LIBXML="2.9.1"
 LIBJSON="UNKNOWN" TO
 POLOGY RASTER

 On Postgres 9.4.5:
 PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
 20120313 (Red Hat 4.4.7-16), 64-bit

 On CENTOS:
 Linux hsi 2.6.32-504.16.2.el6.x86_64 #1 SMP Wed Apr 22 06:48:29 UTC 2015
 x86_64 x86_64 x86_64 GNU/Linux

 I recently built and installed geos 3.5 (was running 3.4.2), and built and
 installed PostGIS 2.2.0 (OS level) without apparent issue.

 I then attempted to upgrade the database by running “ALTER EXTENSION
 postgis UPDATE”. I get a single error message, and a back end that spins
 at 100% CPU:

 WARNING:  'postgis.backend' is already set and cannot be changed until you
 reconnect

 No other apparent disk or database activity. Pg_stat_activity just shows
 the “alter extension” command. I had to kill the back end.

 Note that this database does have a full tiger data set loaded; not sure
 if that matters here. I don’t really want to reload everything (over 1
 TB).

 Any suggestions?

 Thanks,
 Peter Sylvester
 MITRE Corp.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3395>
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.