Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#4967 closed defect (fixed)

Dronie PostgreSQL 9.5 PostGIS 2.5 compile / regress failing

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 2.5.6
Component: QA/buildbots Version: 2.5.x -- EOL
Keywords: Cc:

Description

This might have something to do with my upgrade of trisquel about a month ago, but still the error is puzzling:

https://dronie.osgeo.org/postgis/postgis/2028/1/2

Configure details

-------------- Compiler Info ------------- 
  C compiler:           gcc -O0 -Wall -fno-omit-frame-pointer -Werror
  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

 -------------- Additional Info ------------- 
  Interrupt Tests:   DISABLED use: --with-interrupt-tests to enable

 -------------- Dependencies -------------- 
  GEOS config:          /usr/local/bin/geos-config
  GEOS version:         3.6.5
  GDAL config:          /usr/local/bin/gdal-config
  GDAL version:         2.2.3
  PostgreSQL config:    /usr/lib/postgresql/9.5/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.5.25
  PROJ4 version:        49
  Libxml2 config:       /usr/bin/xml2-config
  Libxml2 version:      2.9.3
  JSON-C support:       yes
  protobuf-c support:   yes
  protobuf-c version:   1003000
  PCRE support:         no
  Perl:                 /usr/bin/perl

 --------------- Extensions --------------- 
  PostGIS Raster:       enabled
  PostGIS Topology:     enabled
  SFCGAL support:       disabled
  Address Standardizer support:       disabled

 -------- Documentation Generation -------- 
  xsltproc:             /usr/bin/xsltproc
  xsl style sheets:     /usr/share/xml/docbook/stylesheet/docbook-xsl
  dblatex:              
  convert:              /usr/bin/convert
  mathml2.dtd:          /usr/share/xml/schema/w3c/mathml/dtd/mathml2.dtd

configure: WARNING:  --------- GEOS VERSION WARNING ------------ 
configure: WARNING:   You are building against GEOS 3.6.5 
configure: WARNING:   To take advantage of all the features of 
configure: WARNING:   this PostGIS version requires GEOS 3.7.0 or higher.
configure: WARNING:   To take advantage of most of the features of this PostGIS
configure: WARNING:   we recommend GEOS 3.6 or higher
configure: WARNING:   You can download the latest versions from 
configure: WARNING:   http://trac.osgeo.org/geos 
configure: WARNING: 

Error details:

gcc  -I../liblwgeom -O0 -Wall -fno-omit-frame-pointer -Werror -I/usr/include/postgresql/9.5/server   -fPIC -DPIC  -Wall -Wmissing-prototypes  -c -o lwgeom_cache.o lwgeom_cache.c
gcc  -I../liblwgeom -O0 -Wall -fno-omit-frame-pointer -Werror -I/usr/include/postgresql/9.5/server   -fPIC -DPIC  -Wall -Wmissing-prototypes  -c -o lwgeom_pg.o lwgeom_pg.c
lwgeom_transform.c:15:22: fatal error: postgres.h: No such file or directory
compilation terminated.
Makefile:61: recipe for target 'lwgeom_transform.o' failed
make[1]: *** [lwgeom_transform.o] Error 1
make[1]: *** Waiting for unfinished jobs....
lwgeom_cache.c:13:22: fatal error: postgres.h: No such file or directory
compilation terminated.
make[1]: *** [lwgeom_cache.o] Error 1
lwgeom_pg.c:17:22: fatal error: postgres.h: No such file or directory
compilation terminated.
Makefile:61: recipe for target 'lwgeom_cache.o' failed
make[1]: *** [lwgeom_pg.o] Error 1
Makefile:61: recipe for target 'lwgeom_pg.o' failed
gserialized_gist.c:12:22: fatal error: postgres.h: No such file or directory
compilation terminated.
make[1]: *** [gserialized_gist.o] Error 1
make: *** [all] Error 1
Makefile:61: recipe for target 'gserialized_gist.o' failed
make[1]: Leaving directory '/drone/src/libpgcommon'
GNUmakefile:16: recipe for target 'all' failed

Change History (8)

comment:1 by strk, 3 years ago

Sounds like it is related to your upgrade, yes. /usr/include/postgresql/9.5/server not containing postgres.h ...

comment:2 by robe, 3 years ago

I'll try rebuilding again and see if any errors show during the build for postgresql 9.5. This time i'll make sure the minor switch is on.

comment:3 by robe, 3 years ago

okay I looked at jenkins build logs. I guess for 9.3 - 9.5 since postgresql project has EOFed. Upstream apt EOF'ed the dev packages too so we'd have to build ourselves.

I'm tempted to just chuck these from dronie and add 12 and 13. Debbie will still be testing 9.5 since she builds those from scratch anyway.

Here is what the log error says:

Configuring postgresql-common
-----------------------------

Obsolete major version 9.3

The PostgreSQL version 9.3 is obsolete, but the server or client packages are
still installed. Please install the latest packages (postgresql-13 and
postgresql-client-13) and upgrade the existing  clusters with pg_upgradecluster
(see manpage).

Please be aware that the installation of postgresql-13 will automatically
create a default cluster 13/main. If you want to upgrade the 9.3/main cluster,
you need to remove the already existing 13 cluster (pg_dropcluster --stop 13
main, see manpage for details).

The old server and client packages are no longer supported. After the existing
clusters are upgraded, the postgresql-9.3 and postgresql-client-9.3 packages
should be removed.

Please see /usr/share/doc/postgresql-common/README.Debian.gz for details.

Obsolete major version 9.4

The PostgreSQL version 9.4 is obsolete, but the server or client packages are
still installed. Please install the latest packages (postgresql-13 and
postgresql-client-13) and upgrade the existing  clusters with pg_upgradecluster
(see manpage).

Please be aware that the installation of postgresql-13 will automatically
create a default cluster 13/main. If you want to upgrade the 9.4/main cluster,
you need to remove the already existing 13 cluster (pg_dropcluster --stop 13
main, see manpage for details).

The old server and client packages are no longer supported. After the existing
clusters are upgraded, the postgresql-9.4 and postgresql-client-9.4 packages
should be removed.

Please see /usr/share/doc/postgresql-common/README.Debian.gz for details.

Obsolete major version 9.5

The PostgreSQL version 9.5 is obsolete, but the server or client packages are
still installed. Please install the latest packages (postgresql-13 and
postgresql-client-13) and upgrade the existing  clusters with pg_upgradecluster
(see manpage).

Please be aware that the installation of postgresql-13 will automatically
create a default cluster 13/main. If you want to upgrade the 9.5/main cluster,
you need to remove the already existing 13 cluster (pg_dropcluster --stop 13
main, see manpage for details).

The old server and client packages are no longer supported. After the existing
clusters are upgraded, the postgresql-9.5 and postgresql-client-9.5 packages
should be removed.

Please see /usr/share/doc/postgresql-common/README.Debian.gz for details.

comment:4 by Regina Obe <lr@…>, 3 years ago

In f723582/git:

Take 9.5 out of dronie testing, apt no longer providing dev packages for it as it's eol'd. References #4967

comment:5 by pramsey, 3 years ago

Close out?

comment:6 by robe, 3 years ago

Resolution: fixed
Status: newclosed

Yap I rebuilt the image with explicit dev and that fixed it.

comment:7 by robe, 3 years ago

I should note I did put back 9.5 after I fixed the image.

comment:8 by Regina Obe <lr@…>, 3 years ago

In b68202a/git:

Put back 9.5 now that trisquel2 image is fixed. Closes #4967

Note: See TracTickets for help on using tickets.