[PostGIS] #5764: PostGIS regress issues when building PostgreSQL with meson
PostGIS
trac at osgeo.org
Sun Jul 14 22:57:42 PDT 2024
#5764: PostGIS regress issues when building PostgreSQL with meson
----------------------+---------------------------
Reporter: robe | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.5.0
Component: install | Version: master
Resolution: | Keywords:
----------------------+---------------------------
Description changed by robe:
Old description:
> These could be specific to how I configured meson on each system.
>
> On debbie, I built PostgreSQL 17 with this:
>
> {{{
> export PG_VER=17
> cd pg17git
> rm -rf ../meson-pg${PG_VER}-build
> meson setup ../meson-pg${PG_VER}-build && cd ../meson-pg${PG_VER}-build
> meson configure -Dcassert=true
> --prefix=${WORKSPACE}/rel/pg${PG_VER}w${OS_BUILD}
> meson compile
> rm -rf ${WORKSPACE}/rel/pg${PG_VER}w${OS_BUILD}
> meson install
> }}}
>
> My autoconf build works fine regressing against postgis master branch,
> however this meson build one fails at loader tests:
>
> https://debbie.postgis.net/job/PostGIS_Regress/30767/consoleFull
>
> {{{
> 01:31:47 PostGIS is now configured for x86_64-pc-linux-gnu
> 01:31:47
> 01:31:47 -------------- Compiler Info -------------
> 01:31:47 C compiler: gcc -std=gnu99 -g -O2 -fno-math-errno
> -fno-signed-zeros -Wall -O2
> 01:31:47 C++ compiler (Wagyu): cc -std=c++11 -x c++
> 01:31:47 C++ compiler (FlatGeobuf): cc -std=c++11 -x c++
> 01:31:47 CPPFLAGS:
> -I/var/lib/jenkins/workspace/geos/rel-3.13w64/include
> -I/usr/include/libxml2 -I/usr/include -I/usr/include/json-c -DNDEBUG
> 01:31:47 LDFLAGS: -lm
> 01:31:47 SQL preprocessor: /usr/bin/cpp -traditional-cpp -w -P
> -Upixel -Ubool
> 01:31:47 Archiver: gcc-ar rs
> 01:31:47
> 01:31:47 -------------- Additional Info -------------
> 01:31:47 POSTGIS lib file includes minor: ENABLED
> 01:31:47 Interrupt Tests: ENABLED
> 01:31:47
> 01:31:47 -------------- Dependencies --------------
> 01:31:47 GEOS config:
> /var/lib/jenkins/workspace/geos/rel-3.13w64/bin/geos-config
> 01:31:47 GEOS version: 3.13.0dev (31300)
> 01:31:47 GDAL config:
> /var/lib/jenkins/workspace/gdal/rel-3.4w64/bin/gdal-config
> 01:31:47 GDAL version: 3.4.3
> 01:31:47 SFCGAL config: /usr/bin/sfcgal-config
> 01:31:47 SFCGAL version: 1.3.8
> 01:31:47 PostgreSQL config:
> /var/lib/jenkins/workspace/pg/rel/pg17w64/bin/pg_config
> 01:31:47 PostgreSQL version: PostgreSQL 17beta2
> 01:31:47 PROJ version: 7.2.1 (70201)
> 01:31:47 Libxml2 config: /usr/bin/xml2-config
> 01:31:47 Libxml2 version: 2.9.14
> 01:31:47 JSON-C support: yes
> 01:31:47 protobuf support: yes
> 01:31:47 protobuf-c version: 1003003
> 01:31:47 PCRE support: not found
> 01:31:47 Perl: /usr/bin/perl
> 01:31:47
> 01:31:47 --------------- Extensions ---------------
> 01:31:47 PostgreSQL EXTENSION support: enabled
> 01:31:47 PostGIS Raster: enabled
> 01:31:47 PostGIS Topology: enabled
> 01:31:47 SFCGAL support: enabled
> 01:31:47 Address Standardizer support: disabled
> }}}
>
> This error is for all loader and dumper tests
>
> {{{
> 01:34:49 regress/loader/Point ........ failed (dumper geog test: dumping
> loaded table:
> /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper.err)
> 01:34:49
> -----------------------------------------------------------------------------
> 01:34:49 could not connect to server: No such file or directory
> 01:34:49 Is the server running locally and accepting
> 01:34:49 connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.3617"?
> 01:34:49
> 01:34:49
> -----------------------------------------------------------------------------
> 01:34:49 regress/loader/PointM ........ failed (dumper geog test:
> dumping loaded table:
> /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper.err)
> 01:34:49
> -----------------------------------------------------------------------------
> 01:34:49 could not connect to server: No such file or directory
> 01:34:49 Is the server running locally and accepting
> 01:34:49 connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.3617"?
> 01:34:49
>
> :
> 01:34:56 regress/dumper/mfiledmp .. failed (dumping:
> /var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper-mfiledmp.err)
> 01:34:56
> -----------------------------------------------------------------------------
> 01:34:56 could not connect to server: No such file or directory
> 01:34:56 Is the server running locally and accepting
> 01:34:56 connections on Unix domain socket
> "/var/run/postgresql/.s.PGSQL.3617"?
> }}}
>
> On my windows new chain I have configured with meson, autoconf again
> works more or less okay(there are some regress failures but more to do
> with my new chain), however meson build completely falls on its face out
> of the gate and fails to install the extensions. strk thinks it's
> something with sed or grep, perhaps the use of PGXS is messing with it.
>
> {{{
> mkdir -p
> 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/contrib/postgis-3.5'
> /bin/sh
> C:/ming64/projects/POSTGR~1/rel/pg17w64/lib/pgxs/src/MAKEFI~1/../../config
> /install-sh -c -m 644 postgis_comments.sql raster_comments.sql
> topology_comments.sql sfcgal_comments.sql
> 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/contrib/postgis-3.5/'
> make[2]: Leaving directory '/projects/postgis/postgis-git/doc'
> mkdir -p /projects/postgis/liblwgeom-3.5w64/share/man/man1
> for f in man/shp2pgsql.1 man/pgsql2shp.1 man/pgtopo_export.1
> man/pgtopo_import.1 man/postgis.1 man/postgis_restore.1; do \
> /usr/bin/install -c -m 644 $f
> /projects/postgis/liblwgeom-3.5w64/share/man/man1/`basename $f`; \
> done
> make[1]: Leaving directory '/projects/postgis/postgis-git/doc'
> ---- Making install in extensions
> make[1]: Entering directory '/projects/postgis/postgis-git/extensions'
> for DIR in postgis postgis_tiger_geocoder postgis_topology
> postgis_sfcgal; do \
> echo "---- Making install in ${DIR}"; \
> make -C "${DIR}" install || exit 1; \
> done
> ---- Making install in postgis
> make[2]: Entering directory '/projects/postgis/postgis-
> git/extensions/postgis'
> mkdir -p 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension'
> mkdir -p 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension'
> mkdir -p "C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension"
> /bin/sh ../../config/install-sh -c -m 644 "sql/postgis--ANY--
> 3.5.0dev.sql"
> "C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension/postgis--ANY--
> 3.5.0dev.sql"
> /bin/sh: ../../config/install-sh: No such file or directory
> make[2]: *** [../upgrade-paths-rules.mk:26: install-upgrade-paths] Error
> 127
> make[2]: Leaving directory '/projects/postgis/postgis-
> git/extensions/postgis'
> make[1]: *** [Makefile:36: install] Error 1
> make[1]: Leaving directory '/projects/postgis/postgis-git/extensions'
> make: *** [GNUmakefile:27: install] Error 1
>
> }}}
New description:
These could be specific to how I configured meson on each system.
On debbie, I built PostgreSQL 17 with this:
{{{
export PG_VER=17
export OS_BUILD=64
cd pg17git
rm -rf ../meson-pg${PG_VER}-build
meson setup ../meson-pg${PG_VER}-build && cd ../meson-pg${PG_VER}-build
meson configure -Dcassert=true
--prefix=${WORKSPACE}/rel/pg${PG_VER}w${OS_BUILD}
meson compile
rm -rf ${WORKSPACE}/rel/pg${PG_VER}w${OS_BUILD}
meson install
}}}
My autoconf build works fine regressing against postgis master branch,
however this meson build one fails at loader tests:
https://debbie.postgis.net/job/PostGIS_Regress/30767/consoleFull
{{{
01:31:47 PostGIS is now configured for x86_64-pc-linux-gnu
01:31:47
01:31:47 -------------- Compiler Info -------------
01:31:47 C compiler: gcc -std=gnu99 -g -O2 -fno-math-errno
-fno-signed-zeros -Wall -O2
01:31:47 C++ compiler (Wagyu): cc -std=c++11 -x c++
01:31:47 C++ compiler (FlatGeobuf): cc -std=c++11 -x c++
01:31:47 CPPFLAGS:
-I/var/lib/jenkins/workspace/geos/rel-3.13w64/include
-I/usr/include/libxml2 -I/usr/include -I/usr/include/json-c -DNDEBUG
01:31:47 LDFLAGS: -lm
01:31:47 SQL preprocessor: /usr/bin/cpp -traditional-cpp -w -P
-Upixel -Ubool
01:31:47 Archiver: gcc-ar rs
01:31:47
01:31:47 -------------- Additional Info -------------
01:31:47 POSTGIS lib file includes minor: ENABLED
01:31:47 Interrupt Tests: ENABLED
01:31:47
01:31:47 -------------- Dependencies --------------
01:31:47 GEOS config:
/var/lib/jenkins/workspace/geos/rel-3.13w64/bin/geos-config
01:31:47 GEOS version: 3.13.0dev (31300)
01:31:47 GDAL config:
/var/lib/jenkins/workspace/gdal/rel-3.4w64/bin/gdal-config
01:31:47 GDAL version: 3.4.3
01:31:47 SFCGAL config: /usr/bin/sfcgal-config
01:31:47 SFCGAL version: 1.3.8
01:31:47 PostgreSQL config:
/var/lib/jenkins/workspace/pg/rel/pg17w64/bin/pg_config
01:31:47 PostgreSQL version: PostgreSQL 17beta2
01:31:47 PROJ version: 7.2.1 (70201)
01:31:47 Libxml2 config: /usr/bin/xml2-config
01:31:47 Libxml2 version: 2.9.14
01:31:47 JSON-C support: yes
01:31:47 protobuf support: yes
01:31:47 protobuf-c version: 1003003
01:31:47 PCRE support: not found
01:31:47 Perl: /usr/bin/perl
01:31:47
01:31:47 --------------- Extensions ---------------
01:31:47 PostgreSQL EXTENSION support: enabled
01:31:47 PostGIS Raster: enabled
01:31:47 PostGIS Topology: enabled
01:31:47 SFCGAL support: enabled
01:31:47 Address Standardizer support: disabled
}}}
This error is for all loader and dumper tests
{{{
01:34:49 regress/loader/Point ........ failed (dumper geog test: dumping
loaded table:
/var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper.err)
01:34:49
-----------------------------------------------------------------------------
01:34:49 could not connect to server: No such file or directory
01:34:49 Is the server running locally and accepting
01:34:49 connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.3617"?
01:34:49
01:34:49
-----------------------------------------------------------------------------
01:34:49 regress/loader/PointM ........ failed (dumper geog test: dumping
loaded table:
/var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper.err)
01:34:49
-----------------------------------------------------------------------------
01:34:49 could not connect to server: No such file or directory
01:34:49 Is the server running locally and accepting
01:34:49 connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.3617"?
01:34:49
:
01:34:56 regress/dumper/mfiledmp .. failed (dumping:
/var/lib/jenkins/workspace/postgis/tmp/3_5_pg17w64/dumper-mfiledmp.err)
01:34:56
-----------------------------------------------------------------------------
01:34:56 could not connect to server: No such file or directory
01:34:56 Is the server running locally and accepting
01:34:56 connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.3617"?
}}}
On my windows new chain I have configured with meson, autoconf again works
more or less okay(there are some regress failures but more to do with my
new chain), however meson build completely falls on its face out of the
gate and fails to install the extensions. strk thinks it's something with
sed or grep, perhaps the use of PGXS is messing with it.
{{{
mkdir -p
'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/contrib/postgis-3.5'
/bin/sh
C:/ming64/projects/POSTGR~1/rel/pg17w64/lib/pgxs/src/MAKEFI~1/../../config
/install-sh -c -m 644 postgis_comments.sql raster_comments.sql
topology_comments.sql sfcgal_comments.sql
'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/contrib/postgis-3.5/'
make[2]: Leaving directory '/projects/postgis/postgis-git/doc'
mkdir -p /projects/postgis/liblwgeom-3.5w64/share/man/man1
for f in man/shp2pgsql.1 man/pgsql2shp.1 man/pgtopo_export.1
man/pgtopo_import.1 man/postgis.1 man/postgis_restore.1; do \
/usr/bin/install -c -m 644 $f
/projects/postgis/liblwgeom-3.5w64/share/man/man1/`basename $f`; \
done
make[1]: Leaving directory '/projects/postgis/postgis-git/doc'
---- Making install in extensions
make[1]: Entering directory '/projects/postgis/postgis-git/extensions'
for DIR in postgis postgis_tiger_geocoder postgis_topology postgis_sfcgal;
do \
echo "---- Making install in ${DIR}"; \
make -C "${DIR}" install || exit 1; \
done
---- Making install in postgis
make[2]: Entering directory '/projects/postgis/postgis-
git/extensions/postgis'
mkdir -p 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension'
mkdir -p 'C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension'
mkdir -p "C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension"
/bin/sh ../../config/install-sh -c -m 644 "sql/postgis--ANY--3.5.0dev.sql"
"C:/ming64/projects/POSTGR~1/rel/pg17w64/share/extension/postgis--ANY--
3.5.0dev.sql"
/bin/sh: ../../config/install-sh: No such file or directory
make[2]: *** [../upgrade-paths-rules.mk:26: install-upgrade-paths] Error
127
make[2]: Leaving directory '/projects/postgis/postgis-
git/extensions/postgis'
make[1]: *** [Makefile:36: install] Error 1
make[1]: Leaving directory '/projects/postgis/postgis-git/extensions'
make: *** [GNUmakefile:27: install] Error 1
}}}
--
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5764#comment:1>
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