[postgis-tickets] [PostGIS] #4860: Fails to build with PROJ 8.0.0
PostGIS
trac at osgeo.org
Mon Feb 22 11:37:54 PST 2021
#4860: Fails to build with PROJ 8.0.0
------------------------------------+---------------------------
Reporter: Bas Couwenberg | Owner: strk
Type: defect | Status: new
Priority: high | Milestone: PostGIS 3.1.2
Component: build/upgrade/install | Version: 3.1.x
Resolution: | Keywords:
------------------------------------+---------------------------
Comment (by Bas Couwenberg):
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 at postgis_reg ERROR: Band at
index '2' not found for raster '2'
2021-02-22 19:32:26.090 UTC [21467] postgres at 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 at 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 at postgis_reg ERROR: Band at
index '2' not found for raster '2'
2021-02-22 19:32:26.091 UTC [21467] postgres at postgis_reg CONTEXT:
PL/pgSQL function st_grayscale(rastbandarg[],text) line 41 at RAISE
2021-02-22 19:32:26.091 UTC [21467] postgres at 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 at postgis_reg ERROR: Tolerance
cannot be less than zero
2021-02-22 19:32:28.845 UTC [21638] postgres at 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 at postgis_reg ERROR: Tolerance
cannot be less than zero
2021-02-22 19:32:28.853 UTC [21638] postgres at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at postgis_reg WARNING: Unable
to add constraint: 'scale_x'. Skipping
2021-02-22 19:32:31.877 UTC [21816] postgres at 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 at 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 at postgis_reg DETAIL: Failing
row contains (3,
01000001006ABC74931804F03FCB1A50CAFFFFEF3F0000000000000000000000...).
2021-02-22 19:32:31.882 UTC [21816] postgres at 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 at postgis_reg STATEMENT:
SELECT make_test_raster('regular', 3, 1.001, 0.9999999);
2021-02-22 19:32:31.887 UTC [21816] postgres at 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 at postgis_reg DETAIL: Failing
row contains (1,
0100000100E1639D31956AE5C3000000000000F03F0000000000000000000000...).
2021-02-22 19:32:31.887 UTC [21816] postgres at 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 at postgis_reg STATEMENT:
SELECT make_test_raster('big', 1, -12345678901234567890.0);
2021-02-22 19:32:31.889 UTC [21816] postgres at postgis_reg WARNING: Unable
to add constraint: 'scale_x'. Skipping
2021-02-22 19:32:31.889 UTC [21816] postgres at 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 at 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 at postgis_reg DETAIL: Failing
row contains (3,
0100000100F168E388B5F8E43E72C45A7C0A00F03F0000000000000000000000...).
2021-02-22 19:32:31.892 UTC [21816] postgres at 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 at postgis_reg STATEMENT:
SELECT make_test_raster('small', 3, 0.00001, 1.00001);
2021-02-22 19:32:31.933 UTC [21816] postgres at postgis_reg WARNING: Unable
to add constraint: 'blocksize_x'. Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres at 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 at postgis_reg WARNING: Unable
to add constraint: 'blocksize_y'. Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres at 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 at postgis_reg WARNING: Unable
to add constraint: 'pixel_types'. Skipping
2021-02-22 19:32:31.933 UTC [21816] postgres at 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 at postgis_reg WARNING: Unable
to add constraint: 'nodata_values'. Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres at 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 at postgis_reg WARNING: Unable
to add constraint: 'out_db'. Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres at 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 at postgis_reg WARNING: Unable
to add constraint: 'extent'. Skipping
2021-02-22 19:32:31.934 UTC [21816] postgres at 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 ...
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4860#comment:2>
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.
More information about the postgis-tickets
mailing list