Opened 7 years ago
Last modified 7 years ago
#4044 closed defect
PostgreSQL 11 regression failures on topology since March 3 — at Initial Version
Reported by: | robe | Owned by: | pramsey |
---|---|---|---|
Priority: | blocker | Milestone: | PostGIS 2.4.4 |
Component: | postgis | Version: | master |
Keywords: | Cc: |
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".
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