[postgis-tickets] [PostGIS] #3759: PostgreSQL 10 failure on winnie both raster and geometry

Thu May 25 12:22:55 PDT 2017

#3759: PostgreSQL 10 failure on winnie both raster and geometry
---------------------------+---------------------------
 Reporter:  robe           |      Owner:  robe
     Type:  defect         |     Status:  new
 Priority:  blocker        |  Milestone:  PostGIS 2.4.0
Component:  buildbots      |    Version:  trunk
 Keywords:  postgresql 10  |
---------------------------+---------------------------
 This might be a winnie specific issue.  Seem to be getting compile error
 on PostgreSQL 10.

 Not sure what changed.  What's even more annoying is that it doesn't break
 consistently at same spot.  Earlier it was breaking in cunit raster
 compile.

 I haven't tested locally on my windows dev to see if it's a windows issue
 or just an upset stomach winnie issue.  I also haven't switched debbie to
 10 testing so not sure if I'll see something there.

 {{{

 Upgrading core
   /projects/postgis/branches/2.4/regress/00-regress-
 install/share/contrib/postgis/postgis_upgrade.sql
 PostgreSQL 10beta1 on x86_64-w64-mingw32, compiled by
 x86_64-w64-mingw32-gcc.exe (x86_64-win32-seh-rev1, Built by MinGW-W64
 project) 4.8.3, 64-bit
   Postgis 2.4.0dev - r15401 - 2017-05-25 19:11:42
   scripts 2.4.0dev r15401
   GEOS: 3.7.0dev-CAPI-1.11.0 8fe2ce6
   PROJ: Rel. 4.9.1, 04 March 2015
   SFCGAL: 1.3.0

 tickets .. failed (diff expected obtained:
 /projects/postgis/tmp/2.4.0dev_pg10_geos3.7.0dev_gdal2.1.3w64/test_89_diff)
 -----------------------------------------------------------------------------
 --- tickets_expected    2016-09-26 01:59:38 -0400
 +++
 /projects/postgis/tmp/2.4.0dev_pg10_geos3.7.0dev_gdal2.1.3w64/test_89_out
 2017-05-25 15:15:09 -0400
 @@ -285,7 +285,7 @@
  #3375|GEOMETRYCOLLECTION(POINT(0 -7))
  #3399|1|1
  #3399|10|10
 -#3399|100|100
 +#3399|100|99
  #3399|1000|1000
  ERROR:  invalid KML representation
  #3437a|5
 -----------------------------------------------------------------------------

   /var/lib/jenkins/workspace/postgis/branches/2.4/regress/00-regress-
 install/share/contrib/postgis/rtpostgis_proc_set_search_path.sql
 PostgreSQL 10beta1 on x86_64-pc-linux-gnu, compiled by gcc (Debian
 5.2.1-22) 5.2.1 20151010, 64-bit
   Postgis 2.4.0dev - r15401 - 2017-05-25 19:09:34
   scripts 2.4.0dev r15401
   raster scripts 2.4.0dev r15401
   GEOS: 3.7.0dev-CAPI-1.11.0 8fe2ce62
   PROJ: Rel. 4.9.2, 08 September 2015
   GDAL: GDAL 2.3.0dev, released 2017/99/99

 Running tests

  check_gdal .. ok
  load_outdb ... ok
  check_raster_columns .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_3_diff)
 -----------------------------------------------------------------------------
 --- check_raster_columns_expected       2017-02-07 07:21:32.729359370
 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_3_out
 2017-05-25 19:14:07.797733794 +0000
 @@ -1,23 +1,23 @@
  raster_columns
  t
 -test_raster_columns|rast|0|1|1|2|2|t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
 +test_raster_columns|rast|0|1|1|||t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
  t
  test_raster_columns|rast|0|||||f|f||||
  t
 -test_raster_columns|rast|0|||2|2|f|f||||POLYGON((-2 -2,-2 4,4 4,4 -2,-2
 -2))
 +test_raster_columns|rast|0|||||f|f||||POLYGON((-2 -2,-2 4,4 4,4 -2,-2
 -2))
  t
 -test_raster_columns|rast|0|||2|2|f|f||||POLYGON((-2 -2,-2 4,4 4,4 -2,-2
 -2))
 +test_raster_columns|rast|0|||||f|f||||POLYGON((-2 -2,-2 4,4 4,4 -2,-2
 -2))
  t
 -test_raster_columns|rast|0|1|1|2|2|t|f|1||{0}|POLYGON((-2 -2,-2 4,4 4,4
 -2,-2 -2))
 +test_raster_columns|rast|0|1|1|||t|f|1||{0}|POLYGON((-2 -2,-2 4,4 4,4
 -2,-2 -2))
  t
 -test_raster_columns|rast|0|||2|2|t|f|1||{0}|POLYGON((-2 -2,-2 4,4 4,4
 -2,-2 -2))
 +test_raster_columns|rast|0|||||t|f|1||{0}|POLYGON((-2 -2,-2 4,4 4,4 -2,-2
 -2))
  t
  t
  t
 -test_raster_columns|rast|0|1|1|3|3|t|t|1|{8BUI}|{0}|POLYGON((0 0,0 6,6
 6,6 0,0 0))
 +test_raster_columns|rast|0|1|1|||t|t|1|{8BUI}|{0}|POLYGON((0 0,0 6,6 6,6
 0,0 0))
  ERROR:  conflicting key value violates exclusion constraint
 "enforce_spatially_unique_test_raster_columns_rast"
  ERROR:  new row for relation "test_raster_columns" violates check
 constraint "enforce_coverage_tile_rast"
  t
 -test_raster_columns|rast|0|1|1|3|3|t|f|1|{8BUI}|{0}|POLYGON((0 0,0 6,6
 6,6 0,0 0))
 +test_raster_columns|rast|0|1|1|||t|f|1|{8BUI}|{0}|POLYGON((0 0,0 6,6 6,6
 0,0 0))
  t
  t
 -----------------------------------------------------------------------------
  check_raster_overviews .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_4_diff)
 -----------------------------------------------------------------------------
 --- check_raster_overviews_expected     2017-02-07 07:21:33.465359381
 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_4_out
 2017-05-25 19:14:08.401733804 +0000
 @@ -2,14 +2,14 @@
  test_raster_columns|rast|0|||||f|f||||
  test_raster_overviews|rast|0|||||f|f||||
  t
 -test_raster_columns|rast|0|1|1|2|2|t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
 +test_raster_columns|rast|0|1|1|||t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
  test_raster_overviews|rast|0|||||f|f||||
  t
 -test_raster_columns|rast|0|1|1|2|2|t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
 +test_raster_columns|rast|0|1|1|||t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
  test_raster_overviews|rast|0|||||f|f||||
  test_raster_overviews|rast|test_raster_columns|rast|1
  t
 -test_raster_columns|rast|0|1|1|2|2|t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
 +test_raster_columns|rast|0|1|1|||t|f|1|{8BUI}|{0}|POLYGON((-2 -2,-2 4,4
 4,4 -2,-2 -2))
  test_raster_overviews|rast|0|||||f|f||||
  t
  test_raster_columns|rast|0|||||f|f||||
 -----------------------------------------------------------------------------
  rt_io .. ok
  rt_bytea .. ok
  box3d .. ok
  rt_addband .. ok
  rt_band .. ok
  rt_tile .. ok
  rt_dimensions .. ok
  rt_scale .. ok
  rt_pixelsize .. ok
  rt_upperleft .. ok
  rt_rotation .. ok
  rt_georeference .. ok
  rt_set_properties .. ok
  rt_isempty .. ok
  rt_hasnoband .. ok
  rt_metadata .. ok
  rt_rastertoworldcoord .. ok
  rt_worldtorastercoord .. ok
  rt_convexhull .. ok
  rt_envelope .. ok
  rt_band_properties .. ok
  rt_set_band_properties .. ok
  rt_pixelaspolygons .. ok
  rt_pixelaspoints .. ok
  rt_pixelascentroids .. ok
  rt_setvalues_array .. ok
  rt_summarystats .. ok
  rt_count .. ok
  rt_histogram .. ok
  rt_quantile .. ok
  rt_valuecount .. ok
  rt_valuepercent .. ok
  rt_bandmetadata .. ok
  rt_pixelvalue .. ok
  rt_neighborhood .. ok
  rt_nearestvalue .. ok
  rt_pixelofvalue .. ok
  rt_polygon .. ok
  rt_utility .. ok
  rt_fromgdalraster .. ok
  rt_asgdalraster .. ok
  rt_astiff .. ok
  rt_asjpeg .. ok
  rt_aspng .. ok
  rt_reclass .. ok
  rt_gdalwarp .. ok
  rt_asraster .. ok
  rt_dumpvalues .. ok
  rt_createoverview .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_53_diff)
 -----------------------------------------------------------------------------
 --- rt_createoverview_expected  2017-02-07 07:21:33.461359381 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_53_out
 2017-05-25 19:14:20.769734015 +0000
 @@ -1,29 +1,23 @@
  t
 -t
 -t
 -t
 -t
 -res1|r|0|1|-1|10|10|t|t|t|t|t|t
 -o_2_res1|r|0|2|-2|10|10|t|t|t|t|t|t
 -o_4_res1|r|0|4|-4|10|10|t|t|t|t|t|t
 -o_8_res1|r|0|8|-8|10|10|t|t|t|t|t|t
 -o_16_res1|r|0|16|-16|10|10|t|t|t|t|t|t
 -o_2_res1|r|res1|r|2
 -o_4_res1|r|res1|r|4
 -o_8_res1|r|res1|r|8
 -o_16_res1|r|res1|r|16
 -count|544|136|36|10|3
 -t
 -t
 -t
 -t
 -t
 -oschm|res1|r|0|1|-1|10|10|t|t|t|t|t|t
 -oschm|o_4_res1|r|0|4|-4|10|10|t|t|t|t|t|t
 -oschm|o_8_res1|r|0|8|-8|10|10|t|t|t|t|t|t
 -public|res1|r|0|1|-1|10|10|t|f|f|f|t|f
 -public|o_4_res1|r|0|4|-4|10|10|t|f|f|f|t|f
 -public|o_8_res1|r|0|8|-8|10|10|t|f|f|f|t|f
 -oschm|o_4_res1|r|oschm|res1|r|4
 -oschm|o_8_res1|r|oschm|res1|r|8
 -count|324|25|9
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +res1|r|0|1|-1|||t|t|t|t|t|t
 +ERROR:  relation "o_2_res1" does not exist at character 74
 +ERROR:  table "o_16_res1" does not exist
 +ERROR:  table "o_8_res1" does not exist
 +ERROR:  table "o_4_res1" does not exist
 +ERROR:  table "o_2_res1" does not exist
 +t
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('oschm.res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('oschm.res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +ERROR:  cannot create overview without tilesize constraint, try select
 AddRasterConstraints('res1', 'r');
 +oschm|res1|r|0|1|-1|||t|t|t|t|t|t
 +public|res1|r|0|1|-1|||t|f|f|f|t|f
 +ERROR:  relation "oschm.o_4_res1" does not exist at character 80
 +ERROR:  table "o_8_res1" does not exist
 +ERROR:  table "o_4_res1" does not exist
 +ERROR:  table "o_8_res1" does not exist
 +ERROR:  table "o_4_res1" does not exist
 -----------------------------------------------------------------------------
  rt_mapalgebraexpr .. ok
  rt_mapalgebrafct .. ok
  rt_mapalgebraexpr_2raster .. ok
  rt_mapalgebrafct_2raster .. ok
  rt_mapalgebrafctngb .. ok
  rt_mapalgebrafctngb_userfunc .. ok
  rt_intersection .. ok
  rt_clip .. ok
  rt_mapalgebra .. ok
  rt_mapalgebra_expr .. ok
  rt_mapalgebra_mask .. ok
  rt_union .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_65_diff)
 -----------------------------------------------------------------------------
 --- rt_union_expected   2017-02-07 07:21:33.425359382 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_65_out
 2017-05-25 19:14:24.161734073 +0000
 @@ -53,9 +53,6 @@
  SUM|2|3|2
  SUM|3|3|2
  NOTICE:  No pixels found for band 1
 -NOTICE:  No pixels found for band 1
 -NOTICE:  No pixels found for band 1
 -NOTICE:  No pixels found for band 1
  COUNT|1|1|1
  COUNT|2|1|1
  COUNT|3|1|1
 -----------------------------------------------------------------------------
  rt_invdistweight4ma .. ok
  rt_4ma .. ok
  rt_setvalues_geomval .. ok
  rt_elevation_functions .. ok
  rt_colormap .. ok
  rt_gist_relationships .. ok
  rt_intersects .. ok
  rt_samealignment .. ok
  rt_geos_relationships .. ok
  rt_iscoveragetile .. ok
  bug_test_car5 .. ok
  permitted_gdal_drivers .. ok
  tickets .. ok
  loader/Basic .... failed (testdiff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_79_diff)
 -----------------------------------------------------------------------------
 --- loader/Basic.select.expected        2017-02-07 07:21:32.889359372
 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_79_out
 2017-05-25 19:14:28.081734140 +0000
 @@ -1,4 +1,4 @@
 -0|1.0000000000|-1.0000000000|90|50|t|f|3|{8BUI,8BUI,8BUI}|{NULL,NULL,NULL}|{f,f,f}|POLYGON((0
 -50,0 0,90 0,90 -50,0 -50))
 +0|1.0000000000|-1.0000000000|||t|f|3|{8BUI,8BUI,8BUI}|{NULL,NULL,NULL}|{f,f,f}|POLYGON((0
 -50,0 0,90 0,90 -50,0 -50))
  POLYGON((0 0,1 0,1 -1,0 -1,0 0))|255
  POLYGON((89 -49,90 -49,90 -50,89 -50,89 -49))|0
  POLYGON((44 -24,45 -24,45 -25,44 -25,44 -24))|0
 -----------------------------------------------------------------------------
  loader/Projected .... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  failed (Errors while running sql script loader/Projected-post.sql:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/test_80_tmp)
 -----------------------------------------------------------------------------
 TRUNCATE TABLE
 ERROR:  table "o_2_loadedrast" does not exist
 -----------------------------------------------------------------------------
  ... but cleanup sql failed! loader/BasicCopy ... failed ( test: running
 raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  loader/BasicFilename ... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  loader/BasicOutDB ... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  loader/Tiled10x10 ... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  loader/Tiled10x10Copy ... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  loader/Tiled8x8 ... failed ( test: running raster2pgsql output:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.err)
 -----------------------------------------------------------------------------
 BEGIN
 psql:/var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/loader.out:2:
 ERROR:  relation "loadedrast" already exists
 -----------------------------------------------------------------------------
  clean .. ok
  uninstall .  /var/lib/jenkins/workspace/postgis/branches/2.4/regress/00
 -regress-install/share/contrib/postgis/uninstall_rtpostgis.sql
  failed (Error encountered loading
 /var/lib/jenkins/workspace/postgis/branches/2.4/regress/00-regress-
 install/share/contrib/postgis/uninstall_rtpostgis.sql:
 /var/lib/jenkins/workspace/postgis/tmp/2_4_pg10.0w64/regress_log)
 -----------------------------------------------------------------------------
 sh: 1: createlang: not found
 }}}

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