[postgis-tickets] [PostGIS] #4226: PostgreSQL 9.4 is failing badly

[PostGIS]

#4226: PostgreSQL 9.4 is failing badly
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 I looked at debbie and her 9.4 runs of 3.0 are failing.  I'm going to
 investigate if it's a change upstream or some fluke on her last build of
 9.4 git branch or perhaps her 9.4 build was happening at the same time as
 this.

 It's starts failing at dumper and then a disaster from there

 {{{
  ../dumper/literalsrid ... failed (dumping:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/dumper-
 literalsrid.err)
 -----------------------------------------------------------------------------
 could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket
 "/var/run/postgresql/.s.PGSQL.3094"?

 -----------------------------------------------------------------------------
  failed (Unable to run sql script ../dumper/literalsrid-post.sql:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_25_tmp)
 -----------------------------------------------------------------------------
 sh: 1: psql: not found
 -----------------------------------------------------------------------------
  ... but cleanup sql failed! ../dumper/realtable . failed (Unable to run
 sql script ../dumper/realtable-pre.sql:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_26_tmp)
 -----------------------------------------------------------------------------
 sh: 1: psql: not found
 -----------------------------------------------------------------------------
 .. failed (dumping: /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64
 /dumper-realtable.err)
 -----------------------------------------------------------------------------
 could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket
 "/var/run/postgresql/.s.PGSQL.3094"?

 -----------------------------------------------------------------------------
  failed (Unable to run sql script ../dumper/realtable-post.sql:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_26_tmp)
 -----------------------------------------------------------------------------
 sh: 1: psql: not found
 -----------------------------------------------------------------------------
  ... but cleanup sql failed! affine .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_27_diff)
 -----------------------------------------------------------------------------
 --- affine_expected     2018-10-19 23:06:40.853381476 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_27_out
 2018-11-04 20:52:18.998743702 +0000
 @@ -1,45 +1 @@
 -ST_Translate|POINT(5 12)
 -ST_Translate|POINT(-3 -7 3)
 -ST_Scale|POINT(5 5)
 -ST_Scale|POINT(3 2)
 -ST_Scale|POINT(40 40 40)
 -ST_ScaleBOX|f
 -ST_ScaleM1|POINT(40 40 40 3)
 -ST_ScaleM2|POINT(4 -3 3 8)
 -ST_ScaleM3|POINT(-30 40 5 9)
 -ST_ScaleOrigin|LINESTRING(1 1,3 3)
 -ST_Rotate|POINT(29 11)
 -ST_Rotate|POINT(-2 0)
 -ST_Rotate|POINT(19 1)
 -ST_Rotate|POINT(-0.5 0.5)
 -ST_RotateZ|POINT(-1 -1)
 -ST_RotateZ|POINT(-1 1)
 -ST_RotateZ|POINT(1 -1)
 -ST_RotateZ|POINT(1 1)
 -ST_RotateY|POINT(-1 1 -1)
 -ST_RotateY|POINT(1 1 -1)
 -ST_RotateY|POINT(-1 1 1)
 -ST_RotateY|POINT(1 1 1)
 -ST_RotateX|POINT(1 -1 -1)
 -ST_RotateX|POINT(1 -1 1)
 -ST_RotateX|POINT(1 1 -1)
 -ST_RotateX|POINT(1 1 1)
 -ST_TransScale|POINT(2 2)
 -ST_TransScale|POINT(3 3)
 -ST_TransScale|POINT(0 0)
 -ST_TransScale|POINT(1 2)
 -ST_TransScale|POINT(2 1)
 -ST_TransScale|POINT(0 2)
 -ST_TransScale|POINT(2 0)
 -ST_TransScale|POINT(3 2)
 -ST_TransScale|POINT(2 3)
 -ST_TransScale|POINT(4 2)
 -ST_TransScale|POINT(2 4)
 -ST_TransScale|POINT(15 28)
 -ST_TransScale|POINT(15 28 1)
 -#3159|Point[]
 -transl_bbox|BOX(1 0,2 1)
 -ST_Scale_bbox|BOX(2 0,4 0)
 -ST_Scale_bbox|BOX(3 1,4 2)
 -ST_RotZ_bbox|BOX(-1 0,0 0)
 -ST_RotY_bbox|BOX(-1 0,0 0)
 +sh: 1: psql: not found
 -----------------------------------------------------------------------------
  bestsrid .. failed (diff expected obtained:
 /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_28_diff)
 -----------------------------------------------------------------------------
 --- bestsrid_expected   2018-10-19 23:06:40.885381261 +0000
 +++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg9.4w64/test_28_out
 2018-11-04 20:52:19.014743307 +0000
 @@ -1,127 +1 @@
 }}}

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