in_gml regression test fails

[naziryavuz]

Hi,

I compiled both Postgres and Postgis from their source code. When I run

make check

in_gml regression test fails.

Commands I used for building Postgres:

./configure
make
sudo make install

Commands I used for building Postgis:

./autogen.sh
./configure --without-raster
make check

Environment:

5.18.12-1-default x86_64 GNU/Linux - OpenSuse Tumbleweed

diff file of in_gml:

--- ./regress/core/in_gml_expected	2022-07-22 15:42:10.041741801 +0300
+++ /tmp/pgis_reg/test_24_out	2022-08-10 14:13:38.773649194 +0300
@@ -95,7 +95,7 @@
 mpoint_4|MULTIPOINT EMPTY
 mpoint_5|MULTIPOINT EMPTY
 mpoint_6|MULTIPOINT(1 2,3 4)
-mpoint_7|27582|MULTIPOINT((1 2),(400000 7000000))
+ERROR:  Could not create LWPROJ*
 mpoint_8|MULTIPOINT(1 2)
 mpoint_9|MULTIPOINT(1 2,3 4)
 mpoint_10|MULTIPOINT EMPTY
@@ -107,7 +107,7 @@
 mline_6|MULTILINESTRING((1 2,3 4),(5 6,7 8))
 mline_7|MULTILINESTRING((1 2,4 5),(7 8,9 10))
 mline_8|MULTILINESTRING((1 2,3 4),(5 6,8 9))
-mline_9|27582|MULTILINESTRING((1 2,3 4),(400000 7000000,400010 7000010))
+ERROR:  Could not create LWPROJ*
 mcurve_1|MULTILINESTRING((1 2,3 4))
 mcurve_2|MULTILINESTRING((1 2,3 4),(5 6,7 8))
 mcurve_3|SRID=4326;MULTILINESTRING((1 2,3 4))
@@ -116,7 +116,7 @@
 mcurve_6|MULTILINESTRING((1 2,3 4),(5 6,7 8))
 mcurve_7|MULTILINESTRING((1 2,4 5),(7 8,9 10))
 mcurve_8|MULTILINESTRING((1 2,3 4),(5 6,8 9))
-mcurve_9|27582|MULTILINESTRING((1 2,3 4),(400000 7000000,400010 7000010))
+ERROR:  Could not create LWPROJ*
 mcurve_10|MULTILINESTRING((1 2,3 4))
 mcurve_11|MULTILINESTRING((1 2,3 4),(5 6,7 8))
 mcurve_12|MULTILINESTRING EMPTY
@@ -128,7 +128,7 @@
 mpoly_6|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,9 10,11 12,7 8)))
 mpoly_7|MULTIPOLYGON(((1 2,4 5,7 8,1 2)),((10 11,12 13,14 15,10 11)))
 mpoly_8|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,10 11,13 14,7 8)))
-mpoly_9|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((400000 7000000,400010 7000010,400020 7000020,400000 7000000),(400100 7000100,400110 7000110,400120 7000120,400100 7000100)))
+ERROR:  Could not create LWPROJ*
 msurface_1|MULTIPOLYGON(((1 2,3 4,5 6,1 2)))
 msurface_2|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,9 10,11 12,7 8)))
 msurface_3|SRID=4326;MULTIPOLYGON(((1 2,3 4,5 6,1 2)))
@@ -137,7 +137,7 @@
 msurface_6|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,9 10,11 12,7 8)))
 msurface_7|MULTIPOLYGON(((1 2,4 5,7 8,1 2)),((10 11,12 13,14 15,10 11)))
 msurface_8|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,10 11,13 14,7 8)))
-msurface_9|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((400000 7000000,400010 7000010,400020 7000020,400000 7000000),(400100 7000100,400110 7000110,400120 7000120,400100 7000100)))
+ERROR:  Could not create LWPROJ*
 msurface_10|MULTIPOLYGON(((1 2,3 4,5 6,1 2)))
 msurface_11|MULTIPOLYGON(((1 2,3 4,5 6,1 2)),((7 8,9 10,11 12,7 8)))
 msurface_12|MULTIPOLYGON EMPTY
@@ -197,7 +197,7 @@
 collection_11|GEOMETRYCOLLECTION(POINT(1 2),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(3 4))))
 collection_12|GEOMETRYCOLLECTION(POINT(1 2),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(4 5))))
 collection_13|GEOMETRYCOLLECTION(POINT(1 2),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(3 4))))
-collection_14|27582|GEOMETRYCOLLECTION(POINT(1 2),GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(400000 7000000))))
+ERROR:  Could not create LWPROJ*
 srs_1|SRID=4326;POINT(1 2)
 srs_2|SRID=4326;POINT(2 1)
 srs_3|SRID=4326;POINT(2 1)

Thanks,

Nazir Bilal Yavuz

[pramsey]

At a minimum you need to include the output of SELECT postgis_full_version(). The error has something to do with your proj library in all likelihood.

[naziryavuz]

Replying to pramsey:

At a minimum you need to include the output of SELECT postgis_full_version(). The error has something to do with your proj library in all likelihood.

When I try to enable Postgis extension, it errors with: could not access file "$libdir/postgis-3"

[naziryavuz]

It seems that both proj and proj-devel need to be installed on OpenSUSE Tumbleweed. proj-devel is enough to build but in_gml test doesn't pass.

Ticket can be closed now.

Thanks,

Nazir Bilal Yavuz