[postgis-users] raster2pgsql gives me segmentation fault

[Imre Samu]

> raster2pgsql gives me segmentation fault
> I'm using RELEASE: 3.3.2 GDAL_VERSION=36 (4975da8) in debian.

Hello Andrea,

If you are familiar with Docker, you could potentially test with the
"postgis/postgis:16-master" Docker image
( https://github.com/postgis/docker-postgis )
to see if your problem can be reproduced with the latest
PostGIS/GDAL/PROJ/GEOS code.

The "postgis/postgis:16-master" contains the most recent development codes:
POSTGIS="3.5.0dev 3.4.0rc1-829-g4338f0b59" [EXTENSION] PGSQL="160"
GEOS="3.13.0dev-CAPI-1.18.0" SFCGAL="SFCGAL 1.5.0, CGAL 5.6.1,
BOOST 1.74.0" PROJ="9.4.0 NETWORK_ENABLED=OFF URL_ENDPOINT=
https://cdn.proj.org
USER_WRITABLE_DIRECTORY=/var/lib/postgresql/.local/share/proj
DATABASE_PATH=/usr/local/share/proj/proj.db"
*GDAL="GDAL 3.9.0dev-1872179537, released 2023/12/03" *
LIBXML="2.9.10"
LIBJSON="0.15"
LIBPROTOBUF="1.3.3"
WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER

Best regards,
  Imre

andy via postgis-users <postgis-users at lists.osgeo.org> ezt írta (időpont:
2023. dec. 4., H, 13:52):

> Hi,
> I'm using RELEASE: 3.3.2 GDAL_VERSION=36 (4975da8) in debian.
>
> When I run this command
>
> raster2pgsql -I -C -M -F -t auto -R ou_s6_01_01_stack.tif
> public.rasters_outdb
>
> I have in the stdout the first part without errors, but after about 80
> records I have error.
> Below are some output example lines.
>
> These are the tif metadata:
> https://gist.github.com/aborruso/caa16e5eb5d5b4756035f68bee191ed4
>
> What can the problem be? How to solve it?
>
> Thank you
>
> INSERT INTO "public"."rasters_outdb" ("rast","filename") VALUES
> ('0100000400392BA226FA7C743F392BA226FA7C74BFAE4A22FB20BF304098E315889EBA424000000000000000000000000000000000E61000000001E8008A00000000006F755F73365F30315F30315F737461636B2E746966008A00000000016F755F73365F30315F30315F737461636B2E746966008A00000000026F755F73365F30315F30315F737461636B2E746966008A00000000036F755F73365F30315F30315F737461636B2E74696600'::raster,'ou_s6_01_01_stack.tif');
> INSERT INTO "public"."rasters_outdb" ("rast","filename") VALUES
> ('0100000400392BA226FA7C743F392BA226FA7C74BF626D8C9DF006324098E315889EBA424000000000000000000000000000000000E6100000C400E8008A00000000006F755F73365F30315F30315F737461636B2E746966008A00000000016F755F73365F30315F30315F737461636B2E746966008A00000000026F755F73365F30315F30315F737461636B2E746966008A00000000036F755F73365F30315F30315F737461636B2E74696600'::raster,'ou_s6_01_01_stack.tif');
> CREATE INDEX ON "public"."rasters_outdb" USING gist
> (st_convexhull("rast"));
> ANALYZE "public"."rasters_outdb";
> SELECT
> AddRasterConstraints('public','rasters_outdb','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE);
> END;
> VACUUM ANALYZE "public"."rasters_outdb";
> [1]    52988 segmentation fault  raster2pgsql -I -C -M -F -t auto -R
> ou_s6_01_01_stack.tif public.rasters_outd
>
>
>
> --
> ___________________
>
> Andrea Borruso
> website: https://medium.com/tantotanto
> 38° 7' 48" N, 13° 21' 9" E, EPSG:4326
> ___________________
>
> "cercare e saper riconoscere chi e cosa,
>  in mezzo all’inferno, non è inferno,
> e farlo durare, e dargli spazio"
>
> Italo Calvino
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20231204/e29b6846/attachment.htm>