[postgis-tickets] [PostGIS] #4044: PostgreSQL 11 regression failures on topology since March 3

[PostGIS]

#4044: PostgreSQL 11 regression failures on topology since March 3
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  trunk
Resolution:           |   Keywords:
----------------------+---------------------------
Description changed by robe:

Old description:

> Sorry guys been distracted lately and seems debbie has been chocking on
> PostgreSQL 11 runs.  I think it's changes upstream.
>
> Has been happening since March 3rd (thus no doc builds since then for 2.5
> either).
>
> One issue is topology
>

> {{{
> https://debbie.postgis.net/job/PostGIS_Regress/8825/consoleFull
> }}}
>
> Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
> TO '2.5.0devnext'
> Upgrading PostGIS Topology in 'postgis_reg' using: ALTER EXTENSION
> postgis_topology UPDATE TO '2.5.0devnext'
> Died at ../../regress/run_test.pl line 1485.
>  failed (Error encountered altering EXTENSION POSTGIS_TOPOLOGY:
> /var/lib/jenkins/workspace/postgis/tmp/2_5_pg11w64/regress_log)
> -----------------------------------------------------------------------------
> sh: 1: createlang: not found
> CREATE EXTENSION
> CREATE EXTENSION
> ALTER EXTENSION
> ERROR:  column proc.proisagg does not exist
> LINE 15: ...nd e.extname = $1 and c.relname = $2 AND
> COALESCE(proc.prois...
>                                                               ^
> HINT:  Perhaps you meant to reference the column "proc.prolang".
> QUERY:  SELECT 'ALTER EXTENSION ' || e.extname || ' DROP ' || $3 || ' '
> || COALESCE(proc.proname || '(' || oidvectortypes(proc.proargtypes) ||
> ')',typ.typname, cd.relname, op.oprname,
>                                 cs.typname || ' AS ' || ct.typname || ')
> ', opcname, opfname) || ';' AS remove_command
>                 FROM pg_depend As d INNER JOIN pg_extension As e
>                         ON d.refobjid = e.oid INNER JOIN pg_class As c ON
>                                 c.oid = d.classid
>                                 LEFT JOIN pg_proc AS proc ON proc.oid =
> d.objid
>                                 LEFT JOIN pg_type AS typ ON typ.oid =
> d.objid
>                                 LEFT JOIN pg_class As cd ON cd.oid =
> d.objid
>                                 LEFT JOIN pg_operator As op ON op.oid =
> d.objid
>                                 LEFT JOIN pg_cast AS ca ON ca.oid =
> d.objid
>                                 LEFT JOIN pg_type AS cs ON ca.castsource
> = cs.oid
>                                 LEFT JOIN pg_type AS ct ON ca.casttarget
> = ct.oid
>                                 LEFT JOIN pg_opclass As oc ON oc.oid =
> d.objid
>                                 LEFT JOIN pg_opfamily As ofa ON ofa.oid =
> d.objid
>                 WHERE d.deptype = 'e' and e.extname = $1 and c.relname =
> $2 AND COALESCE(proc.proisagg, false) = $4;
> CONTEXT:  PL/pgSQL function postgis_extension_remove_objects(text,text)
> line 27 at FOR over EXECUTE statement
> -----------------------------------------------------------------------------
> make[2]: *** [Makefile:79: check] Error 1
> make[2]: Leaving directory
> '/var/lib/jenkins/workspace/postgis/branches/2.5/topology/test'
> make[1]: *** [Makefile:131: check] Error 2
> make[1]: Leaving directory
> '/var/lib/jenkins/workspace/postgis/branches/2.5/topology'
> make: *** [GNUmakefile:16: check] Error 1
> Build step 'Execute shell' marked build as failure
> An attempt to send an e-mail to empty list of recipients, ignored.
> Triggering a new build of PostgreSQL stop

New description:

 Sorry guys been distracted lately and seems debbie has been chocking on
 PostgreSQL 11 runs.  I think it's changes upstream.

 Has been happening since March 3rd.

 One issue is topology
 https://debbie.postgis.net/job/PostGIS_Regress/8825/consoleFull

 {{{



 Upgrading PostGIS in 'postgis_reg' using: ALTER EXTENSION postgis UPDATE
 TO '2.5.0devnext'
 Upgrading PostGIS Topology in 'postgis_reg' using: ALTER EXTENSION
 postgis_topology UPDATE TO '2.5.0devnext'
 Died at ../../regress/run_test.pl line 1485.
  failed (Error encountered altering EXTENSION POSTGIS_TOPOLOGY:
 /var/lib/jenkins/workspace/postgis/tmp/2_5_pg11w64/regress_log)
 -----------------------------------------------------------------------------
 sh: 1: createlang: not found
 CREATE EXTENSION
 CREATE EXTENSION
 ALTER EXTENSION
 ERROR:  column proc.proisagg does not exist
 LINE 15: ...nd e.extname = $1 and c.relname = $2 AND
 COALESCE(proc.prois...
                                                               ^
 HINT:  Perhaps you meant to reference the column "proc.prolang".
 QUERY:  SELECT 'ALTER EXTENSION ' || e.extname || ' DROP ' || $3 || ' ' ||
 COALESCE(proc.proname || '(' || oidvectortypes(proc.proargtypes) ||
 ')',typ.typname, cd.relname, op.oprname,
                                 cs.typname || ' AS ' || ct.typname || ')
 ', opcname, opfname) || ';' AS remove_command
                 FROM pg_depend As d INNER JOIN pg_extension As e
                         ON d.refobjid = e.oid INNER JOIN pg_class As c ON
                                 c.oid = d.classid
                                 LEFT JOIN pg_proc AS proc ON proc.oid =
 d.objid
                                 LEFT JOIN pg_type AS typ ON typ.oid =
 d.objid
                                 LEFT JOIN pg_class As cd ON cd.oid =
 d.objid
                                 LEFT JOIN pg_operator As op ON op.oid =
 d.objid
                                 LEFT JOIN pg_cast AS ca ON ca.oid =
 d.objid
                                 LEFT JOIN pg_type AS cs ON ca.castsource =
 cs.oid
                                 LEFT JOIN pg_type AS ct ON ca.casttarget =
 ct.oid
                                 LEFT JOIN pg_opclass As oc ON oc.oid =
 d.objid
                                 LEFT JOIN pg_opfamily As ofa ON ofa.oid =
 d.objid
                 WHERE d.deptype = 'e' and e.extname = $1 and c.relname =
 $2 AND COALESCE(proc.proisagg, false) = $4;
 CONTEXT:  PL/pgSQL function postgis_extension_remove_objects(text,text)
 line 27 at FOR over EXECUTE statement
 -----------------------------------------------------------------------------
 make[2]: *** [Makefile:79: check] Error 1
 make[2]: Leaving directory
 '/var/lib/jenkins/workspace/postgis/branches/2.5/topology/test'
 make[1]: *** [Makefile:131: check] Error 2
 make[1]: Leaving directory
 '/var/lib/jenkins/workspace/postgis/branches/2.5/topology'
 make: *** [GNUmakefile:16: check] Error 1
 Build step 'Execute shell' marked build as failure
 An attempt to send an e-mail to empty list of recipients, ignored.
 Triggering a new build of PostgreSQL stop

 }}}

--

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