Opened 4 days ago

Closed 3 days ago

#5763 closed defect (fixed)

Berrie64 PostgreSQL support not building with XML support

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.5.0
Component: management Version: master
Keywords: Cc:

Description

Berrie64 is not building with XML support so failing on garden tests.

17:09:49  -------------- Dependencies -------------- 
17:09:49   GEOS config:          /home/jenkins/workspace/geos/rel-3.13.0/bin/geos-config
17:09:49   GEOS version:         3.13.0dev (31300)
17:09:49   GDAL config:          /usr/bin/gdal-config
17:09:49   GDAL version:         3.2.2
17:09:49   PostgreSQL config:    /home/jenkins/workspace/pg/label/berrie64/rel/pg17w64/bin/pg_config
17:09:49   PostgreSQL version:   PostgreSQL 18devel
17:09:49   PROJ version:         7.2.1 (70201)
17:09:49   Libxml2 config:       /usr/bin/xml2-config
17:09:49   Libxml2 version:      2.9.10
17:09:49   JSON-C support:       yes
17:09:49   protobuf support:     yes
17:09:49   protobuf-c version:   1003003
17:09:49   PCRE support:         Version 1
17:09:49   Perl:                 /usr/bin/perl
17:09:49 
17:09:49  --------------- Extensions --------------- 
17:09:49   PostgreSQL EXTENSION support:       enabled
17:09:49   PostGIS Raster:                     enabled
17:09:49   PostGIS Topology:                   enabled
17:09:49   SFCGAL support:                     disabled
17:09:49   Address Standardizer support:       enabled
17:09:49 
17:09:49  -------- Documentation Generation -------- 
17:09:49   xsltproc:             /usr/bin/xsltproc
17:09:49   docbook xsl base:     http://cdn.docbook.org/release/xsl/current
17:09:49   dblatex:              /usr/bin/dblatex
17:09:49   convert:              /usr/bin/convert
17:09:49 

PostGIS garden tests in progress (it will take time)
17:52:55 -------------------------------------------------
17:52:55 psql -X -ad postgis_garden < \
17:52:55 	../doc/postgis_gardentest_35.sql \
17:52:55 	> postgis_garden_result.txt 2>&1 || { \
17:52:55 	tail -n 20 postgis_garden_result.txt; false; }
19:07:35 tail -n 20 postgis_garden_result.txt
19:07:42 				    FROM postgis_garden_log35 ORDER BY logid DESC LIMIT 1;UPDATE postgis_garden_log35 SET log_end = clock_timestamp()
19:07:42 ERROR:  unsupported XML feature
19:07:42 DETAIL:  This functionality requires the server to be built with libxml support.
19:07:42 		FROM (SELECT logid FROM postgis_garden_log35 ORDER BY logid DESC limit 1) As foo
19:07:42 		WHERE postgis_garden_log35.logid = foo.logid  AND postgis_garden_log35.log_end IS NULL;
19:07:42 ERROR:  current transaction is aborted, commands ignored until end of transaction block
19:07:42 COMMIT;
19:07:42 ROLLBACK

I need to review this and while I'm at it will also change to build using Meson.

Change History (1)

comment:1 by robe, 3 days ago

Resolution: fixed
Status: newclosed
Version: 3.4.xmaster

okay might be some change in PG17 and I had switched berrie to test against PG17/PG18.

I had to explicitly add in the postgresql configure —with-libxml for it to build with xml support even though xml is detected without specifying path.

I'll close this out now and reopen if it is still an issue.

I'm going to test meson building perhaps against PG18

Note: See TracTickets for help on using tickets.