Opened 9 years ago

Closed 9 years ago

#3346 closed defect (worksforme)

PostGIS 2.0, PostGIS 2.1 branch does not regress

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 2.0.8
Component: QA/buildbots Version: 2.0.x
Keywords: Cc:

Description

I just resetup 8.4 on new debbie with last released 8.4 which is 8.4.22. Even on old debbie, the PostGIS 2.0 has been choking on 8.4 though seems for other reasons (might be because it's an older micro). On new debbie, I get this. 

 PostgreSQL 8.4.22 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 5.2.1-21) 5.2.1 20151003, 64-bit
 Postgis 2.0.8SVN - r - 2015-10-23 05:56:48
   GEOS: 3.4.3dev-CAPI-1.8.3 r0
   PROJ: Rel. 4.9.2, 08 September 2015

​http://debbie.postgis.net:8080/job/PostGIS_Regress/1798/consoleFul 

 regress_index_nulls .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_26_diff)
-----------------------------------------------------------------------------
--- regress_index_nulls_expected	2015-10-09 02:56:53.722986949 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_26_out	2015-10-23 05:58:02.083971536 +0000
@@ -1,4 +1,6 @@
 NOTICE:  table "indexnulls" does not exist, skipping
+ERROR:  parse error - invalid geometry at character 88
 NOTICE:  table "indexnulls" does not exist, skipping
+ERROR:  parse error - invalid geometry at character 87
 NOTICE:  table "indexempty" does not exist, skipping
 NOTICE:  table "indexempty" does not exist, skipping
-----------------------------------------------------------------------------
 lwgeom_regress .. ok 
 regress_lrs .. ok 
 removepoint .. ok 
 setpoint .. ok 
 simplify .. ok 
 snaptogrid .. ok 
 summary .. ok 
 affine .. ok 
 empty .. ok 
 measures .. ok 
 legacy .. ok 
 long_xact .. ok 
 ctors .. ok 
 sql-mm-serialize .. ok 
 sql-mm-circularstring .. ok 
 sql-mm-compoundcurve .. ok 
 sql-mm-curvepoly .. ok 
 sql-mm-general .. ok 
 sql-mm-multicurve .. ok 
 sql-mm-multisurface .. ok 
 polyhedralsurface .. ok 
 polygonize .. ok 
 postgis_type_name .. ok 
 out_geometry .. ok 
 out_geography .. ok 
 in_gml .. ok 
 in_kml .. ok 
 iscollection .. ok 
 regress_ogc .. ok 
 regress_ogc_cover .. ok 
 regress_ogc_prep .. ok 
 regress_bdpoly .. ok 
 regress_proj .. ok 
 regress_management .. ok 
 dump .. ok 
 dumppoints .. ok 
 wmsservers .. ok 
 wkt .. ok 
 wkb .. ok 
 tickets .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_66_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2015-10-09 02:56:53.478987101 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/2_0_pg8.4w64/test_66_out	2015-10-23 05:58:06.127969707 +0000
@@ -121,7 +121,7 @@
 ERROR:  Shell is not a line
 #695
 ERROR:  First argument must be a LINESTRING
-#696|010f000080060000000103000080010000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000010300008001000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000000000000000000001030000800100000005000000000000000000000000000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000000001030000800100000005000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000010300008001000000050000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000103000080010000000500000000000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f
+ERROR:  parse error - invalid geometry
 #720|MULTIPOINT(-1113194.91 4838471.4,-1113194.91 7326837.72,-1113194.91 11028513.63,556597.45 4838471.4,556597.45 7326837.72,556597.45 11028513.63,2226389.82 4838471.4,2226389.82 7326837.72,2226389.82 11028513.63,3896182.18 4838471.4,3896182.18 7326837.72,3896182.18 11028513.63,5565974.54 4838471.4,5565974.54 7326837.72,5565974.54 11028513.63)
 #723|0101000020e61000006284f068e33826c00000000000004440
 #723|0107000020e610000000000000
@@ -217,7 +217,7 @@
 #1697.2|0
 #1697.3|1024
 #1734.1|1026
-#1755|01e9030000000000000040554000000000008041400000000000000000
+ERROR:  parse error - invalid geometry
 #1776|POLYGON((0 0,10 0,10 10,0 0))|POLYGON((0 0,10 0,10 10,0 0))
 #1791|4.7
 ERROR:  ST_Segmentize: invalid max_distance 0 (must be >= 0)
@@ -243,4 +243,4 @@
 #2424|MULTILINESTRING((0 0,10 0,24 3,30 10))
 #2427|POINT(-1 0)
 #2168|5340.76237395|5340.76237395|0
-#2870|Point[G]
+ERROR:  parse error - invalid geometry at character 28
-----------------------------------------------------------------------------
 typmod .. ok 
 remove_repeated_points .. ok 
 split .. ok 
 relate .. ok 
 bestsrid .. ok 
 concave_hull .. ok 
 hausdorff .. ok 
 regress_buffer_params .. ok 
 offsetcurve .. ok 
 relatematch .. ok 
 isvaliddetail .. ok 
 sharedpaths .. ok 
 snap .. ok 
 node .. ok 
 unaryunion .. ok 
 clean .. ok 
 relate_bnr .. ok 
 in_geojson .. ok 
 uninstall .. ok (3699)

Run tests: 85
Failed: 2
Makefile:172: recipe for target 'check' failed
make[1]: *** [check] Error 2
make[1]: Leaving directory '/var/lib/jenkins/workspace/postgis/branches/2.0/regress'
GNUmakefile:14: recipe for target 'check' failed
make: *** [check] Error 1
Build step 'Execute shell' marked build as failure
ERROR: Failed to set Jenkins Identity header on email.
java.lang.NullPointerException
	at org.jenkinsci.main.modules.instance_identity.InstanceIdentity.get(InstanceIdentity.java:126)
	at jenkins.plugins.mailer.tasks.MimeMessageBuilder.setJenkinsInstanceIdent(MimeMessageBuilder.java:188)
	at jenkins.plugins.mailer.tasks.MimeMessageBuilder.buildMimeMessage(MimeMessageBuilder.java:166)
	at hudson.tasks.MailSender.createEmptyMail(MailSender.java:391)
	at hudson.tasks.MailSender.createFailureMail(MailSender.java:260)
	at hudson.tasks.MailSender.createMail(MailSender.java:178)
	at hudson.tasks.MailSender.run(MailSender.java:107)
	at hudson.tasks.Mailer.perform(Mailer.java:141)
	at hudson.tasks.BuildStepCompatibilityLayer.perform(BuildStepCompatibilityLayer.java:75)
	at hudson.tasks.BuildStepMonitor$1.perform(BuildStepMonitor.java:20)
	at hudson.model.AbstractBuild$AbstractBuildExecution.perform(AbstractBuild.java:779)
	at hudson.model.AbstractBuild$AbstractBuildExecution.performAllBuildSteps(AbstractBuild.java:726)
	at hudson.model.Build$BuildExecution.post2(Build.java:185)
	at hudson.model.AbstractBuild$AbstractBuildExecution.post(AbstractBuild.java:671)
	at hudson.model.Run.execute(Run.java:1766)
	at hudson.model.FreeStyleBuild.run(FreeStyleBuild.java:43)
	at hudson.model.ResourceController.execute(ResourceController.java:98)
	at hudson.model.Executor.run(Executor.java:408)
An attempt to send an e-mail to empty list of recipients, ignored.
Warning: you have no plugins providing access control for builds, so falling back to legacy behavior of permitting any downstream builds to be triggered
Triggering a new build of PostgreSQL stop
Finished: FAILURE

PostgreSQL 8.4 reached end of life in July 2014. ​http://www.postgresql.org/support/versioning/

So we are not obligated to support it. Should we bother trying to fix this or just put a note on 2.0 that 8.4 reached EOL, and that while PostGIS 2.0 still compiles against 8.4, it is no longer a supported platform and people should upgrade.

We don't support 8.4 in 2.1+ up so no issue there.

Change History (3)

comment:1 by robe, 9 years ago

Component: postgis → buildbots
Owner: changed from pramsey to robe
Summary: PostGIS 2.0 branch does not regress against PostgreSQL 8.4 → PostGIS 2.0 branch does not regress

Turns out I unfairly blamed 8.4 on this. It was just that 8.4 runs first and then the whole build fails when it fails. I switched to have 9.0 run first and it fails in a similar way.

But what's troubling me is the old debbie gets passed these parts and fails on raster. So seems something about the way I have it setup on new debbie is different.

old debbie is running: 

PostgreSQL 8.4.17 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.4.5-8) 4.4.5, 64-bit
 Postgis 2.0.8SVN - r14305 - 2015-10-22 17:37:14
   GEOS: 3.4.3dev-CAPI-1.8.3 r4073
   PROJ: Rel. 4.9.1, 04 March 2015

looks same right. I'm a bit bothered the revision numbers aren't coming thru on new debbie.

comment:2 by robe, 9 years ago

Priority: medium → blocker
Summary: PostGIS 2.0 branch does not regress → PostGIS 2.0, PostGIS 2.1 branch does not regress

This seems to be even deeper, rerunning PostGIS 2.1 compiled against GEOS 3.5.1dev I get similar issues: 

PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 5.2.1-21) 5.2.1 20151003, 64-bit
  Postgis 2.1.9dev - r14302 - 2015-10-23 15:29:52
  scripts 2.1.9dev r14302
  GEOS: 3.5.1-CAPI-1.9.1 r4110
  PROJ: Rel. 4.9.2, 08 September 2015

Running tests

 loader/Point .............. ok 
 loader/PointM .............. ok 
 loader/PointZ .............. ok 
 loader/MultiPoint .............. ok 
 loader/MultiPointM .............. ok 
 loader/MultiPointZ .............. ok 
 loader/Arc .............. ok 
 loader/ArcM .............. ok 
 loader/ArcZ .............. ok 
 loader/Polygon .............. ok 
 loader/PolygonM .............. ok 
 loader/PolygonZ .............. ok 
 loader/TSTPolygon ......... ok 
 loader/TSIPolygon ......... ok 
 loader/TSTIPolygon ......... ok 
 loader/PointWithSchema ..... ok 
 loader/NoTransPoint ......... ok 
 loader/NotReallyMultiPoint ......... ok 
 loader/MultiToSinglePoint ......... ok 
 loader/ReprojectPts ........ ok 
 loader/ReprojectPtsGeog ........ ok 
 loader/Latin1 .... ok 
 binary .. ok 
 operators .. ok 
 regress .. ok 
 regress_index .. ok 
 regress_index_nulls .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_1_pg9.4w64/test_27_diff)
-----------------------------------------------------------------------------
--- regress_index_nulls_expected	2015-10-23 15:29:38.018498182 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/2_1_pg9.4w64/test_27_out	2015-10-23 15:31:04.810598811 +0000
@@ -1,4 +1,6 @@
 NOTICE:  table "indexnulls" does not exist, skipping
+ERROR:  parse error - invalid geometry at character 88
 NOTICE:  table "indexnulls" does not exist, skipping
+ERROR:  parse error - invalid geometry at character 87
 NOTICE:  table "indexempty" does not exist, skipping
 NOTICE:  table "indexempty" does not exist, skipping
-----------------------------------------------------------------------------
 regress_selectivity .. ok 
 lwgeom_regress .. ok 
 regress_lrs .. ok 
 removepoint .. ok 
 setpoint .. ok 
 size .. ok 
 simplify .. ok 
 snaptogrid .. ok 
 summary .. ok 
 affine .. ok 
 empty .. ok 
 measures .. ok 
 legacy .. ok 
 long_xact .. ok 
 ctors .. ok 
 sql-mm-serialize .. ok 
 sql-mm-circularstring .. ok 
 sql-mm-compoundcurve .. ok 
 sql-mm-curvepoly .. ok 
 sql-mm-general .. ok 
 sql-mm-multicurve .. ok 
 sql-mm-multisurface .. ok 
 polyhedralsurface .. ok 
 polygonize .. ok 
 postgis_type_name .. ok 
 geography .. ok 
 out_geometry .. ok 
 out_geography .. ok 
 in_geohash .. ok 
 in_gml .. ok 
 in_kml .. ok 
 iscollection .. ok 
 regress_ogc .. ok 
 regress_ogc_cover .. ok 
 regress_ogc_prep .. ok 
 regress_bdpoly .. ok 
 regress_proj .. ok 
 regress_management .. ok 
 dump .. ok 
 dumppoints .. ok 
 boundary .. ok 
 wmsservers .. ok 
 wkt .. ok 
 wkb .. ok 
 tickets .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/2_1_pg9.4w64/test_72_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2015-10-23 15:29:36.218496087 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/2_1_pg9.4w64/test_72_out	2015-10-23 15:31:07.826602292 +0000
@@ -121,7 +121,7 @@
 ERROR:  Shell is not a line
 #695
 ERROR:  First argument must be a LINESTRING
-#696|010f000080060000000103000080010000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000010300008001000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000000000000000000001030000800100000005000000000000000000000000000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000000001030000800100000005000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000010300008001000000050000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000103000080010000000500000000000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f
+ERROR:  parse error - invalid geometry
 #720|MULTIPOINT(-1113194.91 4838471.4,-1113194.91 7326837.72,-1113194.91 11028513.63,556597.45 4838471.4,556597.45 7326837.72,556597.45 11028513.63,2226389.82 4838471.4,2226389.82 7326837.72,2226389.82 11028513.63,3896182.18 4838471.4,3896182.18 7326837.72,3896182.18 11028513.63,5565974.54 4838471.4,5565974.54 7326837.72,5565974.54 11028513.63)
 #723|0101000020e61000006284f068e33826c00000000000004440
 #723|0107000020e610000000000000
@@ -219,7 +219,7 @@
 #1697.2|0
 #1697.3|1024
 #1734.1|1026
-#1755|01e9030000000000000040554000000000008041400000000000000000
+ERROR:  parse error - invalid geometry
 #1776|POLYGON((0 0,10 0,10 10,0 0))|POLYGON((0 0,10 0,10 10,0 0))
 #1780|t
 #1791|4.7
@@ -258,4 +258,4 @@
 #2704|POLYGON((0 0,0 1,1 1,1 0,0 0))
 #2712|LINESTRING EMPTY
 #2788|f|Self-intersection|POINT(1 1)
-#2870|Point[GS]
+ERROR:  parse error - invalid geometry at character 28
-----------------------------------------------------------------------------
 typmod .. ok 
 remove_repeated_points .. ok 
 split .. ok 
 relate .. ok 
 bestsrid .. ok 
 concave_hull .. ok 
 knn .. ok 
 hausdorff .. ok 
 regress_buffer_params .. ok 
 offsetcurve .. ok 
 relatematch .. ok 
 isvaliddetail .. ok 
 sharedpaths .. ok 
 snap .. ok 
 node .. ok 
 unaryunion .. ok 
 clean .. ok 
 relate_bnr .. ok 
 delaunaytriangles .. ok 
 in_geojson .. ok 
 uninstall .  /var/lib/jenkins/workspace/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/uninstall_postgis.sql
. ok (4336)

Run tests: 93
Failed: 2

comment:3 by robe, 9 years ago

Resolution: → worksforme
Status: new → closed

This problem as of Oct 18, 2015 8:46 AM seems to have gone away. So closing. Not sure if it was something I changed or what.

Note: See TracTickets for help on using tickets.