[postgis-tickets] [PostGIS] #5341: debbie failing on raster upgrade from 3.2, 3.1 to 3.4

[PostGIS]

#5341: debbie failing on  raster upgrade from 3.2, 3.1 to 3.4
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  reopened
  Priority:  blocker                |  Milestone:  PostGIS 3.4.0
 Component:  build/upgrade/install  |    Version:  master
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Comment (by robe):

 I reopened because of the failures happening on PG14

 https://debbie.postgis.net/job/PostGIS_Regress/24560/consoleFull


 {{{
 6:48:19 psql:../../../raster/test/regress/hooks/hook-before-upgrade-
 raster.sql:33: NOTICE:  Adding coverage tile constraint required for
 regular blocking
 16:48:19 psql:../../../raster/test/regress/hooks/hook-before-upgrade-
 raster.sql:33: NOTICE:  Unable to create coverage raster: ST_AsRaster
 returned NULL.
 16:48:19 psql:../../../raster/test/regress/hooks/hook-before-upgrade-
 raster.sql:33: WARNING:  Unable to add constraint: 'regular_blocking'.
 Skipping
 16:48:19 psql:../../../raster/test/regress/hooks/hook-before-upgrade-
 raster.sql:33: ERROR:  None of the constraints specified could be added.
 Is the schema name, table name or column name incorrect?
 16:48:19 CONTEXT:  PL/pgSQL function
 addrasterconstraints(name,name,name,text[]) line 119 at RAISE
 16:48:19
 -----------------------------------------------------------------------------
 16:48:19 make: *** [../../../regress/runtest.mk:24: check-regress] Error 3
 16:48:19 make: Leaving directory
 '/var/lib/jenkins/workspace/postgis/branches/3.4/raster/test/regress'
 16:48:19 FAIL: postgis_raster extension upgrade unpackaged3.1--3.4.0dev
 16:48:19 Testing postgis_raster extension upgrade unpackaged3.2--3.4.0dev
 16:48:19 make: Entering directory
 '/var/lib/jenkins/workspace/postgis/branches/3.4/raster/test/regress'
 16:48:19 RUNTESTFLAGS: -v --extension --upgrade-path=unpackaged3.2--
 3.4.0dev -v --raster
 16:48:19 RUNTESTFLAGS_INTERNAL: --before-upgrade-script
 ../../../raster/test/regress/hooks/hook-before-upgrade-raster.sql
 --after-upgrade-script ../../../raster/test/regress/hooks/hook-after-
 upgrade-raster.sql
 }}}

 The error is different from before but still same area of failure.

 Seems to be only an issue going from 3.1 -> 3.4 or 3.2-- 3.4 .  3.3--> 3.4
 is fine.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5341#comment:19>
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.