Opened 6 years ago

Last modified 6 years ago

#4044 closed defect

PostgreSQL 11 regression failures on topology since March 3 — at Version 1

Reported by: robe Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.4.4
Component: postgis Version: master
Keywords: Cc:

Description (last modified by robe)

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

Change History (1)

comment:1 by robe, 6 years ago

Description: modified (diff)
Note: See TracTickets for help on using tickets.