Opened 7 years ago
Last modified 7 years ago
#3759 closed defect
PostgreSQL 10 failure on winnie both raster and geometry — at Initial Version
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | blocker | Milestone: | PostGIS 2.4.0 |
Component: | postgis | Version: | master |
Keywords: | postgresql 10 | Cc: |
Description
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
Note:
See TracTickets
for help on using tickets.