Opened 6 years ago

Closed 4 years ago

#4226 closed defect (fixed)

Prevent PostGIS runs from happening at same time as PostgreSQL builds are happening on debbie

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.1.0
Component: QA/buildbots Version: master
Keywords: Cc:

Description

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 @@

Change History (4)

comment:1 by robe, 6 years ago

Component: postgisbuildbots
Owner: changed from pramsey to robe
Summary: PostgreSQL 9.4 is failing badlyPrevent PostGIS runs from happening at same time as PostgreSQL builds are happening on debbie

okay think a false alarm. I see the 9.4 built about 30 minutes ago so was probably building at the same time.

Guess I got to come up with some rule to prevent both running at same time.

I've changed the title of this

comment:2 by Algunenano, 6 years ago

Priority: blockermedium

Not a blocker.

comment:3 by robe, 5 years ago

Milestone: PostGIS 3.0.0PostGIS 3.1.0

comment:4 by pramsey, 4 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.