Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#4860 closed defect (fixed)

Fails to build with PROJ 8.0.0

Reported by: Bas Couwenberg Owned by: strk
Priority: high Milestone: PostGIS 3.1.2
Component: build Version: 3.1.x
Keywords: Cc:

Description

postgis fails to build with PROJ 8.0.0: 

checking for PROJ... yes
checking proj_api.h usability... no
checking proj_api.h presence... no
checking for proj_api.h... no
checking proj.h usability... yes
checking proj.h presence... yes
checking for proj.h... yes
checking for proj.h... (cached) yes
checking for pj_get_release in -lproj... no
configure: error: could not find libproj - you may need to specify the directory of a PROJ installation using --with-projdir

Attachments (1)

proj8.patch​ (646 bytes ) - added by Bas Couwenberg 3 years ago.

Download all attachments as: .zip

Change History (9)

by Bas Couwenberg, 3 years ago

Attachment: proj8.patch​ added

comment:1 by Bas Couwenberg, 3 years ago

The attached patch fixes the issue for me, it uses AC_CHECK_LIB with proj_info (which is available in proj.h) as a second opinion when AC_CHECK_LIB with pj_get_release (which was in proj_api.h) fails.

comment:2 by Bas Couwenberg, 3 years ago

There are some test failures however: 

make[3]: Entering directory '/build/postgis-3.1.1+dfsg/topology/test'
cpp -P -traditional-cpp predicates.sql.in | sed -e 's:@COLUMN@:feature:g;s:@SCHEMA@:topology.:g' > topo_predicates.sql
cpp -P -traditional-cpp load_topology.sql.in | sed -e 's:@SRID@:-1:g' > load_topology.sql
cpp -P -traditional-cpp load_topology.sql.in | sed -e 's:@SRID@:4326:g' > load_topology-4326.sql
make[3]: Leaving directory '/build/postgis-3.1.1+dfsg/topology/test'
PATH is /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Checking for shp2pgsql ... found
Checking for pgsql2shp ... found
Checking for raster2pgsql ... found
TMPDIR is /tmp/pgis_reg
Creating database 'postgis_reg' 
Loading unpackaged components from /build/postgis-3.1.1+dfsg/regress/00-regress-install/share/contrib/postgis
Loading PostGIS into 'postgis_reg' 
Loading Topology into 'postgis_reg'
Loading Raster into 'postgis_reg'
Loading SFCGAL into 'postgis_reg'
PostgreSQL 13.2 (Debian 13.2-1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
  Postgis 3.1.1 - (aaf4c79) - 2021-01-29 05:27:33
  scripts 3.1.1 aaf4c79
  raster scripts 3.1.1 aaf4c79
  GEOS: 3.9.0-CAPI-1.16.2
  PROJ: 8.0.0
  SFCGAL: 1.3.8
  GDAL: GDAL 3.2.1, released 2020/12/29

Running tests

 ./regress/core/affine .. ok in 128 ms
 ./regress/core/bestsrid .. ok in 108 ms
 ./regress/core/binary .. ok in 314 ms
 ./regress/core/boundary .. ok in 117 ms
 ./regress/core/chaikin .. ok in 118 ms
 ./regress/core/filterm .. ok in 117 ms
 ./regress/core/cluster .. ok in 114 ms
 ./regress/core/concave_hull .. ok in 253 ms
 ./regress/core/ctors .. ok in 117 ms
 ./regress/core/curvetoline .. ok in 134 ms
 ./regress/core/dump .. ok in 135 ms
 ./regress/core/dumppoints .. ok in 106 ms
 ./regress/core/empty .. ok in 141 ms
 ./regress/core/estimatedextent .. ok in 165 ms
 ./regress/core/forcecurve .. ok in 94 ms
 ./regress/core/geography .. ok in 450 ms
 ./regress/core/geometric_median .. ok in 109 ms
 ./regress/core/hausdorff .. ok in 120 ms
 ./regress/core/in_geohash .. ok in 133 ms
 ./regress/core/in_gml .. ok in 343 ms
 ./regress/core/in_kml .. ok in 173 ms
 ./regress/core/in_encodedpolyline .. ok in 108 ms
 ./regress/core/iscollection .. ok in 129 ms
 ./regress/core/legacy .. ok in 377 ms
 ./regress/core/long_xact .. ok in 119 ms
 ./regress/core/lwgeom_regress .. ok in 166 ms
 ./regress/core/measures .. ok in 126 ms
 ./regress/core/minimum_bounding_circle .. ok in 111 ms
 ./regress/core/normalize .. ok in 129 ms
 ./regress/core/operators .. ok in 124 ms
 ./regress/core/orientation .. ok in 121 ms
 ./regress/core/out_geometry .. ok in 151 ms
 ./regress/core/out_geography .. ok in 121 ms
 ./regress/core/polygonize .. ok in 117 ms
 ./regress/core/polyhedralsurface .. ok in 111 ms
 ./regress/core/postgis_type_name .. ok in 179 ms
 ./regress/core/quantize_coordinates .. ok in 117 ms
 ./regress/core/regress .. ok in 348 ms
 ./regress/core/regress_bdpoly .. ok in 122 ms
 ./regress/core/regress_buffer_params .. ok in 117 ms
 ./regress/core/regress_gist_index_nd .. ok in 1308 ms
 ./regress/core/regress_index .. ok in 2524 ms
 ./regress/core/regress_index_nulls .. ok in 224 ms
 ./regress/core/regress_management .. ok in 133 ms
 ./regress/core/regress_selectivity .. ok in 142 ms
 ./regress/core/regress_lrs .. ok in 127 ms
 ./regress/core/regress_ogc .. ok in 147 ms
 ./regress/core/regress_ogc_cover .. ok in 115 ms
 ./regress/core/regress_ogc_prep .. ok in 148 ms
 ./regress/core/regress_proj .. ok in 2651 ms
 ./regress/core/relate .. ok in 205 ms
 ./regress/core/remove_repeated_points .. ok in 113 ms
 ./regress/core/removepoint .. ok in 121 ms
 ./regress/core/reverse .. ok in 114 ms
 ./regress/core/setpoint .. ok in 118 ms
 ./regress/core/simplify .. ok in 119 ms
 ./regress/core/simplifyvw .. ok in 127 ms
 ./regress/core/size .. ok in 116 ms
 ./regress/core/snaptogrid .. ok in 119 ms
 ./regress/core/split .. ok in 144 ms
 ./regress/core/sql-mm-serialize .. ok in 125 ms
 ./regress/core/sql-mm-circularstring .. ok in 109 ms
 ./regress/core/sql-mm-compoundcurve .. ok in 166 ms
 ./regress/core/sql-mm-curvepoly .. ok in 126 ms
 ./regress/core/sql-mm-general .. ok in 99 ms
 ./regress/core/sql-mm-multicurve .. ok in 161 ms
 ./regress/core/sql-mm-multisurface .. ok in 141 ms
 ./regress/core/swapordinates .. ok in 94 ms
 ./regress/core/summary .. ok in 130 ms
 ./regress/core/temporal .. ok in 89 ms
 ./regress/core/temporal_knn .. ok in 494 ms
 ./regress/core/tickets .. failed (diff expected obtained: /tmp/pgis_reg/test_72_diff)
-----------------------------------------------------------------------------
--- ./regress/core/tickets_expected     2021-01-28 19:10:32.000000000 +0000
+++ /tmp/pgis_reg/test_72_out   2021-02-22 19:30:06.306690640 +0000
@@ -195,7 +195,7 @@
 #1543|MULTILINESTRING((0 0,10 0,10 10,0 0),(0 0))|POLYGON((0 0,10 10,10 0,0 0))
 #1578|f|f
 #1580.1|Point[S]
-ERROR:  transform: latitude or longitude exceeded limits (-14)
+ERROR:  transform: Invalid coordinate (2049)
 #1580.3|Point[S]
 #1596.1|public.road_pg.roads_geom SRID:3395 TYPE:POINT DIMS:2 
 ERROR:  invalid SRID: 330000 not found in spatial_ref_sys
-----------------------------------------------------------------------------
 ./regress/core/twkb .. ok in 106 ms
 ./regress/core/typmod .. ok in 4478 ms
 ./regress/core/wkb .. ok in 109 ms
 ./regress/core/wkt .. ok in 109 ms
 ./regress/core/wmsservers .. ok in 249 ms
 ./regress/core/offsetcurve .. ok in 94 ms
 ./regress/core/relatematch .. ok in 98 ms
 ./regress/core/isvaliddetail .. ok in 88 ms
 ./regress/core/sharedpaths .. ok in 122 ms
 ./regress/core/snap .. ok in 89 ms
 ./regress/core/node .. ok in 102 ms
 ./regress/core/unaryunion .. ok in 143 ms
 ./regress/core/clean .. ok in 209 ms
 ./regress/core/relate_bnr .. ok in 271 ms
 ./regress/core/delaunaytriangles .. ok in 170 ms
 ./regress/core/clipbybox2d .. ok in 92 ms
 ./regress/core/subdivide .. ok in 6438 ms
 ./regress/core/voronoi .. ok in 91 ms
 ./regress/core/regress_brin_index .. ok in 596 ms
 ./regress/core/regress_brin_index_3d .. ok in 689 ms
 ./regress/core/regress_brin_index_geography .. ok in 322 ms
 ./regress/core/minimum_clearance .. ok in 140 ms
 ./regress/core/oriented_envelope .. ok in 137 ms
 ./regress/core/point_coordinates .. ok in 134 ms
 ./regress/core/out_geojson .. ok in 100 ms
 ./regress/core/computed_columns .. ok in 2028 ms
 ./regress/core/frechet .. ok in 126 ms
 ./regress/core/geos38 .. ok in 90 ms
 ./regress/core/geos39 .. ok in 111 ms
 ./regress/core/fixedoverlay .. ok in 149 ms
 ./regress/core/in_geojson .. ok in 165 ms
 ./regress/core/regress_spgist_index_2d .. ok in 1985 ms
 ./regress/core/regress_spgist_index_3d .. ok in 1628 ms
 ./regress/core/regress_spgist_index_nd .. ok in 1416 ms
 ./regress/core/mvt .. ok in 161 ms
 ./regress/core/mvt_jsonb .. ok in 86 ms
 ./regress/core/geobuf .. ok in 87 ms
 ./regress/loader/Point .............. ok in 1145 ms
 ./regress/loader/PointM .............. ok in 1248 ms
 ./regress/loader/PointZ .............. ok in 1251 ms
 ./regress/loader/MultiPoint .............. ok in 1269 ms
 ./regress/loader/MultiPointM .............. ok in 1242 ms
 ./regress/loader/MultiPointZ .............. ok in 1295 ms
 ./regress/loader/Arc .............. ok in 1267 ms
 ./regress/loader/ArcM .............. ok in 1380 ms
 ./regress/loader/ArcZ .............. ok in 1219 ms
 ./regress/loader/Polygon .............. ok in 1252 ms
 ./regress/loader/PolygonM .............. ok in 1254 ms
 ./regress/loader/PolygonZ .............. ok in 1212 ms
 ./regress/loader/TSTPolygon ......... ok in 1231 ms
 ./regress/loader/TSIPolygon ......... ok in 1217 ms
 ./regress/loader/TSTIPolygon ......... ok in 1197 ms
 ./regress/loader/PointWithSchema ..... ok in 869 ms
 ./regress/loader/NoTransPoint ......... ok in 1238 ms
 ./regress/loader/NotReallyMultiPoint ......... ok in 927 ms
 ./regress/loader/MultiToSinglePoint ......... ok in 1281 ms
 ./regress/loader/ReprojectPts ........ ok in 1225 ms
 ./regress/loader/ReprojectPtsD ..... ok in 908 ms
 ./regress/loader/ReprojectPtsGeog ........ ok in 1283 ms
 ./regress/loader/ReprojectPtsGeogD ........ ok in 1166 ms
 ./regress/loader/Latin1 .... ok in 879 ms
 ./regress/loader/Latin1-implicit .... ok in 544 ms
 ./regress/loader/mfile .... ok in 851 ms
 ./regress/dumper/mfiledmp ..... ok in 74 ms
 ./regress/dumper/literalsrid ....... ok in 69 ms
 ./regress/dumper/realtable ....... ok in 68 ms
 ./regress/dumper/nullsintable ....... ok in 72 ms
 ./regress/dumper/null3d ..... ok in 77 ms
 ./sfcgal/regress/regress_sfcgal .. ok in 127 ms
 ./sfcgal/regress/approximatemedialaxis .. ok in 136 ms
 ./topology/test/regress/addedge .. ok in 202 ms
 ./topology/test/regress/addface2.5d .. ok in 164 ms
 ./topology/test/regress/addface .. ok in 495 ms
 ./topology/test/regress/addnode .. ok in 213 ms
 ./topology/test/regress/addtopogeometrycolumn .. ok in 196 ms
 ./topology/test/regress/copytopology .. ok in 353 ms
 ./topology/test/regress/createtopogeom .. ok in 220 ms
 ./topology/test/regress/createtopology .. ok in 224 ms
 ./topology/test/regress/droptopogeometrycolumn .. ok in 205 ms
 ./topology/test/regress/droptopology .. ok in 195 ms
 ./topology/test/regress/getedgebypoint .. ok in 165 ms
 ./topology/test/regress/getfacebypoint .. ok in 227 ms
 ./topology/test/regress/getnodebypoint .. ok in 179 ms
 ./topology/test/regress/getringedges .. ok in 177 ms
 ./topology/test/regress/gettopogeomelements .. ok in 220 ms
 ./topology/test/regress/gml .. ok in 1090 ms
 ./topology/test/regress/layertrigger .. ok in 197 ms
 ./topology/test/regress/legacy_invalid .. ok in 209 ms
 ./topology/test/regress/legacy_predicate .. ok in 702 ms
 ./topology/test/regress/legacy_query .. ok in 282 ms
 ./topology/test/regress/legacy_validate .. ok in 196 ms
 ./topology/test/regress/polygonize .. ok in 166 ms
 ./topology/test/regress/sqlmm .. ok in 162 ms
 ./topology/test/regress/st_addedgemodface .. ok in 292 ms
 ./topology/test/regress/st_addedgenewfaces .. ok in 284 ms
 ./topology/test/regress/st_addisoedge .. ok in 151 ms
 ./topology/test/regress/st_addisonode .. ok in 207 ms
 ./topology/test/regress/st_changeedgegeom .. ok in 201 ms
 ./topology/test/regress/st_createtopogeo .. ok in 949 ms
 ./topology/test/regress/st_getfaceedges .. ok in 231 ms
 ./topology/test/regress/st_getfacegeometry .. ok in 164 ms
 ./topology/test/regress/st_modedgeheal .. ok in 350 ms
 ./topology/test/regress/st_modedgesplit .. ok in 896 ms
 ./topology/test/regress/st_newedgeheal .. ok in 349 ms
 ./topology/test/regress/st_newedgessplit .. ok in 827 ms
 ./topology/test/regress/st_remedgemodface .. ok in 439 ms
 ./topology/test/regress/st_remedgenewface .. ok in 452 ms
 ./topology/test/regress/st_simplify .. ok in 192 ms
 ./topology/test/regress/topo2.5d .. ok in 192 ms
 ./topology/test/regress/topoelementarray_agg .. ok in 96 ms
 ./topology/test/regress/topoelement .. ok in 107 ms
 ./topology/test/regress/topogeo_addlinestring .. ok in 855 ms
 ./topology/test/regress/topogeo_addpoint .. ok in 222 ms
 ./topology/test/regress/topogeo_addpolygon .. ok in 343 ms
 ./topology/test/regress/topogeom_edit .. ok in 174 ms
 ./topology/test/regress/topogeometry_type .. ok in 245 ms
 ./topology/test/regress/topojson .. ok in 362 ms
 ./topology/test/regress/topologysummary .. ok in 141 ms
 ./topology/test/regress/totopogeom .. ok in 477 ms
 ./topology/test/regress/validatetopology .. ok in 171 ms
 ./raster/test/regress/check_gdal .. ok in 323 ms
 ./raster/test/regress/load_outdb ... ok in 214 ms
 ./raster/test/regress/check_raster_columns .. ok in 465 ms
 ./raster/test/regress/check_raster_overviews .. ok in 353 ms
 ./raster/test/regress/rt_io .. ok in 230 ms
 ./raster/test/regress/rt_bytea .. ok in 220 ms
 ./raster/test/regress/rt_wkb .. ok in 272 ms
 ./raster/test/regress/box3d .. ok in 249 ms
 ./raster/test/regress/rt_addband .. ok in 263 ms
 ./raster/test/regress/rt_band .. ok in 302 ms
 ./raster/test/regress/rt_tile .. ok in 1098 ms
 ./raster/test/regress/rt_dimensions .. ok in 229 ms
 ./raster/test/regress/rt_scale .. ok in 231 ms
 ./raster/test/regress/rt_pixelsize .. ok in 219 ms
 ./raster/test/regress/rt_upperleft .. ok in 217 ms
 ./raster/test/regress/rt_rotation .. ok in 225 ms
 ./raster/test/regress/rt_georeference .. ok in 258 ms
 ./raster/test/regress/rt_set_properties .. ok in 211 ms
 ./raster/test/regress/rt_isempty .. ok in 192 ms
 ./raster/test/regress/rt_hasnoband .. ok in 215 ms
 ./raster/test/regress/rt_metadata .. ok in 205 ms
 ./raster/test/regress/rt_rastertoworldcoord .. ok in 270 ms
 ./raster/test/regress/rt_worldtorastercoord .. ok in 230 ms
 ./raster/test/regress/rt_convexhull .. ok in 224 ms
 ./raster/test/regress/rt_envelope .. ok in 229 ms
 ./raster/test/regress/rt_band_properties .. ok in 258 ms
 ./raster/test/regress/rt_set_band_properties .. ok in 232 ms
 ./raster/test/regress/rt_pixelaspolygons .. ok in 569 ms
 ./raster/test/regress/rt_pixelaspoints .. ok in 593 ms
 ./raster/test/regress/rt_pixelascentroids .. ok in 559 ms
 ./raster/test/regress/rt_setvalues_array .. ok in 386 ms
 ./raster/test/regress/rt_summarystats .. ok in 253 ms
 ./raster/test/regress/rt_count .. ok in 231 ms
 ./raster/test/regress/rt_histogram .. ok in 223 ms
 ./raster/test/regress/rt_quantile .. ok in 218 ms
 ./raster/test/regress/rt_valuecount .. ok in 231 ms
 ./raster/test/regress/rt_valuepercent .. ok in 253 ms
 ./raster/test/regress/rt_bandmetadata .. ok in 219 ms
 ./raster/test/regress/rt_pixelvalue .. ok in 225 ms
 ./raster/test/regress/rt_neighborhood .. ok in 233 ms
 ./raster/test/regress/rt_nearestvalue .. ok in 234 ms
 ./raster/test/regress/rt_pixelofvalue .. ok in 216 ms
 ./raster/test/regress/rt_polygon .. ok in 208 ms
 ./raster/test/regress/rt_setbandpath .. ok in 241 ms
 ./raster/test/regress/rt_utility .. ok in 226 ms
 ./raster/test/regress/rt_fromgdalraster .. ok in 272 ms
 ./raster/test/regress/rt_asgdalraster .. ok in 306 ms
 ./raster/test/regress/rt_astiff .. ok in 284 ms
 ./raster/test/regress/rt_asjpeg .. ok in 251 ms
 ./raster/test/regress/rt_aspng .. ok in 244 ms
 ./raster/test/regress/rt_reclass .. ok in 229 ms
 ./raster/test/regress/rt_gdalwarp .. ok in 1450 ms
 ./raster/test/regress/rt_asraster .. ok in 1842 ms
 ./raster/test/regress/rt_dumpvalues .. ok in 463 ms
 ./raster/test/regress/rt_makeemptycoverage .. ok in 241 ms
 ./raster/test/regress/rt_createoverview .. ok in 4161 ms
 ./raster/test/regress/rt_mapalgebraexpr .. ok in 236 ms
 ./raster/test/regress/rt_mapalgebrafct .. ok in 251 ms
 ./raster/test/regress/rt_mapalgebraexpr_2raster .. ok in 261 ms
 ./raster/test/regress/rt_mapalgebrafct_2raster .. ok in 273 ms
 ./raster/test/regress/rt_mapalgebrafctngb .. ok in 225 ms
 ./raster/test/regress/rt_mapalgebrafctngb_userfunc .. ok in 257 ms
 ./raster/test/regress/rt_intersection .. ok in 496 ms
 ./raster/test/regress/rt_clip .. ok in 400 ms
 ./raster/test/regress/rt_mapalgebra .. ok in 267 ms
 ./raster/test/regress/rt_mapalgebra_expr .. ok in 257 ms
 ./raster/test/regress/rt_mapalgebra_mask .. ok in 447 ms
 ./raster/test/regress/rt_union .. ok in 1048 ms
 ./raster/test/regress/rt_invdistweight4ma .. ok in 132 ms
 ./raster/test/regress/rt_4ma .. ok in 156 ms
 ./raster/test/regress/rt_setvalues_geomval .. ok in 616 ms
 ./raster/test/regress/rt_elevation_functions .. ok in 1138 ms
 ./raster/test/regress/rt_colormap .. ok in 372 ms
 ./raster/test/regress/rt_grayscale .. ok in 358 ms
 ./raster/test/regress/rt_gist_relationships .. ok in 257 ms
 ./raster/test/regress/rt_intersects .. ok in 388 ms
 ./raster/test/regress/rt_samealignment .. ok in 214 ms
 ./raster/test/regress/rt_geos_relationships .. ok in 1075 ms
 ./raster/test/regress/rt_iscoveragetile .. ok in 1427 ms
 ./raster/test/regress/bug_test_car5 .. ok in 209 ms
 ./raster/test/regress/permitted_gdal_drivers .. ok in 295 ms
 ./raster/test/regress/tickets .. ok in 306 ms
 ./raster/test/regress/loader/Basic .... ok in 685 ms
 ./raster/test/regress/loader/Projected ..... ok in 703 ms
 ./raster/test/regress/loader/BasicCopy .... ok in 677 ms
 ./raster/test/regress/loader/BasicFilename .... ok in 643 ms
 ./raster/test/regress/loader/BasicOutDB .... ok in 702 ms
 ./raster/test/regress/loader/Tiled10x10 .... ok in 692 ms
 ./raster/test/regress/loader/Tiled10x10Copy .... ok in 675 ms
 ./raster/test/regress/loader/Tiled8x8 .... ok in 699 ms
 ./raster/test/regress/loader/TiledAuto .... ok in 15393 ms
 ./raster/test/regress/loader/TiledAutoSkipNoData .... ok in 2360 ms
 ./raster/test/regress/clean .. ok in 125 ms
 uninstall .. ok (4831)

Run tests: 286
Failed: 1
make[2]: *** [regress/runtest.mk:10: check-regress] Error 1
make[2]: Leaving directory '/build/postgis-3.1.1+dfsg'
*** /var/log/postgresql/postgresql-13-main.log (last 100 lines) ***
*** /var/log/postgresql/postgresql-13-regress.log (last 100 lines) ***
        ORDER BY rid
        LIMIT 1;
2021-02-22 19:32:26.090 UTC [21467] postgres@postgis_reg ERROR:  Band at index '2' not found for raster '2'
2021-02-22 19:32:26.090 UTC [21467] postgres@postgis_reg CONTEXT:  PL/pgSQL function st_grayscale(rastbandarg[],text) line 41 at RAISE
        PL/pgSQL function st_grayscale(raster,integer,integer,integer,text) line 5 at RETURN
2021-02-22 19:32:26.090 UTC [21467] postgres@postgis_reg STATEMENT:  SELECT
                ST_Grayscale(rast)
        FROM raster_grayscale_in
        ORDER BY rid
        LIMIT 1;
2021-02-22 19:32:26.091 UTC [21467] postgres@postgis_reg ERROR:  Band at index '2' not found for raster '2'
2021-02-22 19:32:26.091 UTC [21467] postgres@postgis_reg CONTEXT:  PL/pgSQL function st_grayscale(rastbandarg[],text) line 41 at RAISE
2021-02-22 19:32:26.091 UTC [21467] postgres@postgis_reg STATEMENT:  SELECT
                ST_Grayscale(
                        ARRAY[
                                ROW(rast, 1)::rastbandarg,
                                ROW(rast, 2)::rastbandarg,
                                ROW(rast, 1)::rastbandarg
                        ]::rastbandarg[]
                )
        FROM raster_grayscale_in
        ORDER BY rid
        LIMIT 1;
2021-02-22 19:32:28.845 UTC [21638] postgres@postgis_reg ERROR:  Tolerance cannot be less than zero

2021-02-22 19:32:28.845 UTC [21638] postgres@postgis_reg STATEMENT:  SELECT
                '2.2',
                r1.rid,
                r2.rid,
                -1 AS distance,
                ST_DWithin(r1.rast, NULL, r2.rast, NULL, -1)
        FROM raster_geos_rast r1
        CROSS JOIN raster_geos_rast r2
        WHERE r1.rid = 0;
2021-02-22 19:32:28.853 UTC [21638] postgres@postgis_reg ERROR:  Tolerance cannot be less than zero

2021-02-22 19:32:28.853 UTC [21638] postgres@postgis_reg STATEMENT:  SELECT
                '2.4',
                r1.rid,
                r2.rid,
                -1 AS distance,
                ST_DFullyWithin(r1.rast, NULL, r2.rast, NULL, -1)
        FROM raster_geos_rast r1
        CROSS JOIN raster_geos_rast r2
        WHERE r1.rid = 0;
ERROR 4: `/vsimem/in.dat' not recognized as a supported file format.
2021-02-22 19:32:31.397 UTC [21774] postgres@postgis_reg ERROR:  RASTER_fromGDALRaster: Could not open bytea with GDAL. Check that the bytea is of a GDAL supported format
2021-02-22 19:32:31.397 UTC [21774] postgres@postgis_reg STATEMENT:  SELECT convert_from(ST_AsGDALRaster(ST_FromGDALRaster('<VRTDataset rasterXSize="1000"
        rasterYSize="1"><VRTRasterBand band="1"
        subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>'::bytea),
        'EHDR')::bytea, 'LATIN1');
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>: No such file or directory
2021-02-22 19:32:31.400 UTC [21774] postgres@postgis_reg ERROR:  rt_band_load_offline_data: Cannot open offline raster: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-02-22 19:32:31.400 UTC [21774] postgres@postgis_reg STATEMENT:  SELECT count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>: No such file or directory
2021-02-22 19:32:31.401 UTC [21774] postgres@postgis_reg ERROR:  rt_band_load_offline_data: Cannot open offline raster: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-02-22 19:32:31.401 UTC [21774] postgres@postgis_reg STATEMENT:  SELECT count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>: No such file or directory
2021-02-22 19:32:31.411 UTC [21774] postgres@postgis_reg ERROR:  rt_band_load_offline_data: Cannot open offline raster: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-02-22 19:32:31.411 UTC [21774] postgres@postgis_reg STATEMENT:  SELECT count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from raster_test where lbl = 'passwd';
ERROR 4: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>: No such file or directory
2021-02-22 19:32:31.411 UTC [21774] postgres@postgis_reg ERROR:  rt_band_load_offline_data: Cannot open offline raster: <VRTDataset rasterXSize="1000" rasterYSize="1"><VRTRasterBand band="1" subClass="VRTRawRasterBand"><SourceFilename>/etc/passwd</SourceFilename></VRTRasterBand></VRTDataset>
2021-02-22 19:32:31.411 UTC [21774] postgres@postgis_reg STATEMENT:  SELECT count(convert_from(ST_AsGDALRaster(r, 'EHDR')::bytea, 'LATIN1')) as passwd from raster_test where lbl = 'passwd';
2021-02-22 19:32:31.877 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'scale_x'.  Skipping
2021-02-22 19:32:31.877 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
2021-02-22 19:32:31.882 UTC [21816] postgres@postgis_reg ERROR:  new row for relation "test_raster_scale_regular" violates check constraint "enforce_scaley_rast"
2021-02-22 19:32:31.882 UTC [21816] postgres@postgis_reg DETAIL:  Failing row contains (3, 01000001006ABC74931804F03FCB1A50CAFFFFEF3F0000000000000000000000...).
2021-02-22 19:32:31.882 UTC [21816] postgres@postgis_reg CONTEXT:  SQL statement "INSERT INTO test_raster_scale_regular VALUES ('3', '01000001006ABC74931804F03FCB1A50CAFFFFEF3F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double precision) line 16 at EXECUTE
2021-02-22 19:32:31.882 UTC [21816] postgres@postgis_reg STATEMENT:  SELECT make_test_raster('regular', 3, 1.001, 0.9999999);
2021-02-22 19:32:31.887 UTC [21816] postgres@postgis_reg ERROR:  new row for relation "test_raster_scale_big" violates check constraint "enforce_scalex_rast"
2021-02-22 19:32:31.887 UTC [21816] postgres@postgis_reg DETAIL:  Failing row contains (1, 0100000100E1639D31956AE5C3000000000000F03F0000000000000000000000...).
2021-02-22 19:32:31.887 UTC [21816] postgres@postgis_reg CONTEXT:  SQL statement "INSERT INTO test_raster_scale_big VALUES ('1', '0100000100E1639D31956AE5C3000000000000F03F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double precision) line 16 at EXECUTE
2021-02-22 19:32:31.887 UTC [21816] postgres@postgis_reg STATEMENT:  SELECT make_test_raster('big', 1, -12345678901234567890.0);
2021-02-22 19:32:31.889 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'scale_x'.  Skipping
2021-02-22 19:32:31.889 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
2021-02-22 19:32:31.892 UTC [21816] postgres@postgis_reg ERROR:  new row for relation "test_raster_scale_small" violates check constraint "enforce_scaley_rast"
2021-02-22 19:32:31.892 UTC [21816] postgres@postgis_reg DETAIL:  Failing row contains (3, 0100000100F168E388B5F8E43E72C45A7C0A00F03F0000000000000000000000...).
2021-02-22 19:32:31.892 UTC [21816] postgres@postgis_reg CONTEXT:  SQL statement "INSERT INTO test_raster_scale_small VALUES ('3', '0100000100F168E388B5F8E43E72C45A7C0A00F03F00000000000000000000000000000000000000000000000000000000000000000000000002000200440001010101')"
        PL/pgSQL function make_test_raster(text,integer,double precision,double precision) line 16 at EXECUTE
2021-02-22 19:32:31.892 UTC [21816] postgres@postgis_reg STATEMENT:  SELECT make_test_raster('small', 3, 0.00001, 1.00001);
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'blocksize_x'.  Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'blocksize_y'.  Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'pixel_types'.  Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'nodata_values'.  Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'out_db'.  Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg WARNING:  Unable to add constraint: 'extent'.  Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres@postgis_reg CONTEXT:  PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE
        PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN
Dropping cluster 13/regress ...

comment:4 by Bas Couwenberg, 3 years ago

That just leaves the test failures then.

comment:5 by Paul Ramsey <pramsey@…>, 3 years ago

In fc2a3ab/git:

Address differing error messages from Proj 8 and <8. References #4860

comment:6 by Paul Ramsey <pramsey@…>, 3 years ago

In 0091177e/git:

Address differing error messages from Proj 8 and <8. References #4860

comment:7 by pramsey, 3 years ago

Resolution: → fixed
Status: new → closed

Tests should work and build work from 3.0 onwards.

comment:8 by Paul Ramsey <pramsey@…>, 3 years ago

In 24c1ede/git:

Address differing error messages from Proj 8 and <8. References #4860

Note: See TracTickets for help on using tickets.