[postgis-tickets] [PostGIS] #4876: PostgreSQL 14 regress failure on uninstall

[PostGIS]

#4876: PostgreSQL 14 regress failure on uninstall
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.2.0
Component:  postgis  |    Version:  master
 Keywords:           |
---------------------+---------------------------
 https://debbie.postgis.net/job/PostGIS_Regress/16554/consoleFull

 {{{
 23:59:40  -------------- Compiler Info -------------
 23:59:40   C compiler:           gcc -std=gnu99 -g -O2 -fno-math-errno
 -fno-signed-zeros
 23:59:40   C++ compiler (Wagyu): gcc -std=c++11 -x c++
 23:59:40   CPPFLAGS:
 -I/var/lib/jenkins/workspace/geos/rel-3.10w64/include
 -I/usr/include/libxml2 -I/usr/include -I/usr/include/json-c  -DNDEBUG
 23:59:40   LDFLAGS:               -lm
 23:59:40   SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P
 23:59:40
 23:59:40  -------------- Additional Info -------------
 23:59:40   Interrupt Tests:   DISABLED use: --with-interrupt-tests to
 enable
 23:59:40
 23:59:40  -------------- Dependencies --------------
 23:59:40   GEOS config:
 /var/lib/jenkins/workspace/geos/rel-3.10w64/bin/geos-config
 23:59:40   GEOS version:         3.10.0dev
 23:59:40   GDAL config:
 /var/lib/jenkins/workspace/gdal/rel-3.2w64/bin/gdal-config
 23:59:40   GDAL version:         3.2.2
 23:59:40   SFCGAL config:        /usr/bin/sfcgal-config
 23:59:40   SFCGAL version:       1.3.8
 23:59:40   PostgreSQL config:
 /var/lib/jenkins/workspace/pg/rel/pg14w64/bin/pg_config
 23:59:40   PostgreSQL version:   PostgreSQL 14devel
 23:59:40   PROJ4 version:        72
 23:59:40   Libxml2 config:       /usr/bin/xml2-config
 23:59:40   Libxml2 version:      2.9.10
 23:59:40   JSON-C support:       yes
 23:59:40   protobuf support:     yes
 23:59:40   protobuf-c version:   1003003
 23:59:40   PCRE support:         no
 23:59:40   Perl:                 /usr/bin/perl
 23:59:40
 23:59:40  --------------- Extensions ---------------
 23:59:40   PostGIS Raster:                     enabled
 23:59:40   PostGIS Topology:                   enabled
 23:59:40   SFCGAL support:                     enabled
 23:59:40   Address Standardizer support:       disabled
 23:59:40
 23:59:40  -------- Documentation Generation --------
 23:59:40   xsltproc:             /usr/bin/xsltproc
 23:59:40   xsl style sheets:     /usr/share/xml/docbook/stylesheet
 /docbook-xsl
 23:59:40   dblatex:              /usr/bin/dblatex
 23:59:40   convert:              /usr/bin/convert
 23:59:40   mathml2.dtd:
 /usr/share/xml/schema/w3c/mathml/dtd/mathml2.dtd
 23:59:40
 }}}

 {{{
 00:05:54 psql:/var/lib/jenkins/workspace/postgis/branches/3.2/regress/00
 -regress-install/share/contrib/postgis/uninstall_postgis.sql:82: ERROR:
 cannot drop operator @(geometry,geometry) because other objects depend on
 it
 00:05:54 DETAIL:  constraint enforce_max_extent_rast on table loadedrast
 depends on operator @(geometry,geometry)
 00:05:54 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
 00:05:54
 -----------------------------------------------------------------------------
 00:05:54 . failed (Object count pre-install (5173) != post-uninstall
 (6584))
 00:05:54
 00:05:54 Run tests: 293
 00:05:54 Failed: 30
 }}}

 Started happening around 3/8 or so but hard to say what caused it.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4876>
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.