PostgreSQL 9.5 regress failure raster

[robe]

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.

[robe]

I should note the change must have happened in past 7 days of PostgreSQL repo

[robe]

As of 4/25 debbie weekend run, it's still sadly an issue so something we probably need to address.

[Bborie Park]

Fixed in -trunk as of r13471