[postgis-tickets] [PostGIS] #4175: debbie failures on postgis

[PostGIS]

#4175: debbie failures on postgis
------------------------+---------------------------
  Reporter:  robe       |      Owner:  robe
      Type:  defect     |     Status:  new
  Priority:  blocker    |  Milestone:  PostGIS 2.5.0
 Component:  buildbots  |    Version:  trunk
Resolution:             |   Keywords:
------------------------+---------------------------
Description changed by robe:

Old description:

> I think debbie's failures in raster, crashing might be due to some
> upstream postgresql changes recently done to all the branches.
>
> I reverted to tagged 10_5 and the dev run passed.
>
> Here 2.5 is also failing similarly crashing so need to fix before we
> release 2.5 to see if its something we need to change or need to report
> upstream.

New description:

 I think debbie's failures in raster, crashing might be due to some
 upstream postgresql changes recently done to all the branches.

 I reverted to tagged 10_5 and the dev run passed.

 Here 2.5 is also failing similarly crashing so need to fix before we
 release 2.5 to see if its something we need to change or need to report
 upstream.


 {{{
   /var/lib/jenkins/workspace/postgis/branches/3.0/regress/00-regress-
 install/share/contrib/postgis/rtpostgis_proc_set_search_path.sql
 PostgreSQL 10.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.2.0-5)
 8.2.0, 64-bit
   Postgis 3.0.0dev - r16729 - 2018-09-11 06:20:39
   scripts 3.0.0dev r16729
   raster scripts 3.0.0dev r16729
   GEOS: 3.7.0rc1-CAPI-1.11.0 49f66217
   PROJ: Rel. 5.1.0, June 1st, 2018
   GDAL: GDAL 2.3.1, released 2018/06/22

 Running tests

  check_gdal .. ok
  load_outdb ... ok
  check_raster_columns .. ok
  check_raster_overviews .. ok
  rt_io .. ok
  rt_bytea .. ok
  rt_wkb .. ok
  box3d .. ok
  rt_addband .. ok
  rt_band .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg10w64/test_10_diff)
 -----------------------------------------------------------------------------
 --- rt_band_expected    2018-09-11 06:20:16.310293357 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg10w64/test_10_out
 2018-09-11 06:25:52.143617183 +0000
 @@ -12,18 +12,7 @@
  9876.54321
  987.654321
  1234.5678
 -1234.5678
 -1234.5678
 -1234.5678
 -4
 -3
 -2
 -1
 -1
 -1
 -NOTICE:  Invalid band index (must use 1-based). Returning original raster
 -3
 -NOTICE:  Invalid band index (must use 1-based). Returning original raster

 -6|(1,{{7}})

 +psql: FATAL:  the database system is in recovery mode
 -----------------------------------------------------------------------------
  rt_valuepercent .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg10w64/test_37_diff)
 -----------------------------------------------------------------------------
 --- rt_valuepercent_expected    2018-09-11 06:20:16.906295708 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg10w64/test_37_out
 2018-09-11 06:25:52.435618333 +0000
 @@ -1,35 +1 @@
 --10.000|0.500
 -3.142|0.500
 --10.000|0.500
 -3.142|0.500
 --10.000|0.010
 -0.000|0.980
 -3.142|0.010
 --10.000|0.500
 -3.100|0.500
 -3.100|0.500
 --10.000|0.500
 --10.000|0.500
 --10.000|0.500
 -3.000|0.000
 -0.500
 -0.010
 -0.500
 -0.500
 -0.500
 -0.500
 -BEGIN
 --10.000|0.010
 -0.000|0.980
 -3.142|0.010
 --10.000|0.500
 -1.000|0.000
 --10.000|0.500
 -3.100|0.500
 --1.000|0.000
 -3.100|0.500
 -0.500
 -0.000
 -0.500
 -0.000
 -COMMIT
 +psql: FATAL:  the database system is in recovery mode
 -----------------------------------------------------------------------------
  rt_bandmetadata .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg10w64/test_38_diff)
 }}}

--

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