[postgis-tickets] [PostGIS] #3096: PostgreSQL 9.5 regress failure raster
PostGIS
trac at osgeo.org
Sun Apr 5 00:08:23 PDT 2015
#3096: PostgreSQL 9.5 regress failure raster
---------------------+------------------------------------------------------
Reporter: robe | Owner: dustymugs
Type: defect | Status: new
Priority: blocker | Milestone: PostGIS 2.2.0
Component: raster | Version: trunk
Keywords: |
---------------------+------------------------------------------------------
Debbie's weekly run of PostgreSQL 9.5 failed again.
This time different of course.
Details here, I will output the specific raster failures
{{{
rt_createoverview .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/test_53_diff)
-----------------------------------------------------------------------------
--- rt_createoverview_expected 2014-09-06 20:09:58.000000000 -0700
+++
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/test_53_out
2015-04-04 20:08:33.000000000 -0700
@@ -1,15 +1,11 @@
t
-t
-t
-t
-t
-res1|r|0|1|-1|10|10|t|t|t|t|t|t
-o_2_res1|r|0|2|-2|10|10|t|t|t|t|t|t
-o_4_res1|r|0|4|-4|10|10|t|t|t|t|t|t
-o_8_res1|r|0|8|-8|10|10|t|t|t|t|t|t
-o_16_res1|r|0|16|-16|10|10|t|t|t|t|t|t
-o_2_res1|r|res1|r|2
-o_4_res1|r|res1|r|4
-o_8_res1|r|res1|r|8
-o_16_res1|r|res1|r|16
-count|544|136|36|10|3
+ERROR: invalid input syntax for type double precision: "'-1'"
+ERROR: invalid input syntax for type double precision: "'-1'"
+ERROR: invalid input syntax for type double precision: "'-1'"
+ERROR: invalid input syntax for type double precision: "'-1'"
+ERROR: invalid input syntax for type double precision: "'-1'"
+ERROR: relation "o_2_res1" does not exist at character 74
+ERROR: table "o_16_res1" does not exist
+ERROR: table "o_8_res1" does not exist
+ERROR: table "o_4_res1" does not exist
+ERROR: table "o_2_res1" does not exist
loader/Basic .... failed (testdiff expected obtained:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/test_79_diff)
-----------------------------------------------------------------------------
--- loader/Basic.select.expected 2015-01-24 20:05:28.000000000
-0800
+++
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/test_79_out
2015-04-04 20:08:36.000000000 -0700
@@ -1,4 +1,4 @@
-0|1.0000000000|-1.0000000000|90|50|t|f|3|{8BUI,8BUI,8BUI}|{NULL,NULL,NULL}|{f,f,f}|POLYGON((0
-50,0 0,90 0,90 -50,0 -50))
+ERROR: invalid input syntax for type double precision: "'-1'"
POLYGON((0 0,1 0,1 -1,0 -1,0 0))|255
POLYGON((89 -49,90 -49,90 -50,89 -50,89 -49))|0
POLYGON((44 -24,45 -24,45 -25,44 -25,44 -24))|0
-----------------------------------------------------------------------------
loader/Projected .... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
failed (Errors while running sql script loader/Projected-post.sql:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/test_80_tmp)
-----------------------------------------------------------------------------
TRUNCATE TABLE
ERROR: table "o_2_loadedrast" does not exist
-----------------------------------------------------------------------------
... but cleanup sql failed! loader/BasicCopy ... failed ( test: running
raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
loader/BasicFilename ... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
loader/BasicOutDB ... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
loader/Tiled10x10 ... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
loader/Tiled10x10Copy ... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
loader/Tiled8x8 ... failed ( test: running raster2pgsql output:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.err)
-----------------------------------------------------------------------------
BEGIN
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/loader.out:2:
ERROR: relation "loadedrast" already exists
-----------------------------------------------------------------------------
clean .. ok
uninstall .
/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/regress/00
-regress-install/share/contrib/postgis/uninstall_rtpostgis.sql
failed (Error encountered loading
/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/regress/00
-regress-install/share/contrib/postgis/uninstall_rtpostgis.sql:
/var/lib/jenkins/workspace/postgis/regress_pgdev/tmp/2_2_pg9.5w64/regress_log)
-----------------------------------------------------------------------------
createlang: language "plpgsql" is already installed in database
"postgis_reg"
}}}
I assume this one is coming from upgrade test:
{{{
psql:/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/regress/00
-regress-install/share/contrib/postgis/uninstall_rtpostgis.sql:70: ERROR:
cannot drop function st_envelope(raster) because other objects depend on
it
DETAIL: constraint enforce_max_extent_rast on table loadedrast depends on
function st_envelope(raster)
HINT: Use DROP ... CASCADE to drop the dependent objects too.
-----------------------------------------------------------------------------
make[3]: *** [check] Error 1
make[3]: Leaving directory
`/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/raster/test/regress'
make[2]: *** [check] Error 2
make[2]: Leaving directory
`/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/raster/test'
make[1]: *** [check] Error 2
make[1]: Leaving directory
`/var/lib/jenkins/workspace/postgis/regress_pgdev/branches/2.2/raster'
}}}
Anyway it seems all raster this time. Last week was fine and since our
other PostgreSQL versions are doing fine, I can only assume it's a change
in PostgreSQL 9.5 code base.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3096>
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.
More information about the postgis-tickets
mailing list