[postgis-tickets] [PostGIS] #4970: GEOS 3.9 regress failures on PostGIS 2.5

PostGIS trac at osgeo.org
Sun Aug 15 15:52:57 PDT 2021


#4970: GEOS 3.9 regress failures on PostGIS 2.5
----------------------+---------------------------
 Reporter:  robe      |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  critical  |  Milestone:  PostGIS 2.5.6
Component:  postgis   |    Version:  2.5.x
 Keywords:            |
----------------------+---------------------------
 The freeBSD project released GEOS 3.9.1 which means the bessies bessie32 /
 bessie are trying to test PostGIS 2.5 against GEOS 3.9 and no surprise
 they are failing miserably.

 So options are to stop testing freebsd on 2.5 or back port GEOS 3.9
 regression fixes.

 I'm leaning toward backporting the GEOS 3.9 to 2.5, as I think a lot of
 developers might fall into this boat.

 {{{
 18:20:41 PATH is
 /usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/home/jenkins/bin:/usr/local:/usr/local/lib:/usr/local/bin
 18:20:41 Checking for shp2pgsql ... found
 18:20:41 Checking for pgsql2shp ... found
 18:20:41 Checking for raster2pgsql ... found
 18:20:41 TMPDIR is
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b
 18:20:41 Creating database 'postgis_reg'
 18:20:41 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis
 18:20:43 Preparing db 'postgis_reg' using: CREATE EXTENSION postgis_sfcgal
 18:20:45 PostgreSQL 12.7 on amd64-portbld-freebsd12.2, compiled by FreeBSD
 clang version 10.0.1 (git at github.com:llvm/llvm-project.git
 llvmorg-10.0.1-0-gef32c611aa2), 64-bit
 18:20:45   Postgis 2.5.6dev - r - 2021-08-15 22:11:04
 18:20:45   scripts 2.5.6dev r0
 18:20:45   raster scripts 2.5.6dev r0
 18:20:45   GEOS: 3.9.1-CAPI-1.14.2
 18:20:45   PROJ: Rel. 7.2.1, January 1st, 2021
 18:20:45   SFCGAL: 1.3.8
 18:20:45   GDAL: GDAL 3.2.1, released 2020/12/29
 }}}

 -- below tests failing
 {{{
 -- this one is a little troubling as I dont' recall having to make any
 changes to concavehull tests
 18:21:37  concave_hull_hard .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_35_diff)
 18:24:05
 -----------------------------------------------------------------------------
 18:24:05 --- concave_hull_hard_expected 2021-08-15 18:10:52.152402000
 -0400
 18:24:05 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_35_out
 2021-08-15 18:22:53.520382000 -0400
 18:24:05 @@ -2,4 +2,4 @@
 18:24:05  ST_ConcaveHull Lines 0.80|t|t
 18:24:05  ST_ConcaveHull Lines 0.80 holes|t|t
 18:24:05  #3638|t|t
 18:24:05 -#3697|t|t
 18:24:05 +#3697|f|t
 18:24:05
 ----------------------------------------------------------------------------
 }}}

 {{{
 18:24:22  regress_ogc .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_72_diff)
 18:24:22
 -----------------------------------------------------------------------------
 18:24:22 --- regress_ogc_expected       2021-08-15 18:10:52.215569000
 -0400
 18:24:22 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_72_out
 2021-08-15 18:23:11.013382000 -0400
 18:24:22 @@ -91,7 +91,7 @@
 18:24:22  intersection|POINT(0 0)
 18:24:22  difference|MULTILINESTRING((0 10,0 2),(0 -2,0 -10))
 18:24:22  boundary|MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4
 4,4 2,2 2))
 18:24:22 -symdifference|GEOMETRYCOLLECTION(LINESTRING(2 2,4
 4),LINESTRING(10 10,20 20),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,2 4,2
 2,4 2,4 4)))
 18:24:22 +symdifference|GEOMETRYCOLLECTION(POLYGON((0 10,10 10,10 0,0 0,0
 10),(2 4,2 2,4 2,4 4,2 4)),LINESTRING(2 2,4 4),LINESTRING(10 10,20 20))
 18:24:22  issimple|t
 18:24:22  equals|t
 18:24:22  pointonsurface|t
 18:24:22 @@ -107,7 +107,7 @@
 18:24:22  intersects|f
 18:24:22  ST_GeometryN|LINESTRING(0 0,1 1)
 18:24:22  ST_NumGeometries|1
 18:24:22 -ST_Union1|POLYGON((0 0,0 1,0.5 1,0.5 1.5,1.5 1.5,1.5 0.5,1 0.5,1
 0,0 0))
 18:24:22 +ST_Union1|POLYGON((0 1,0.5 1,0.5 1.5,1.5 1.5,1.5 0.5,1 0.5,1 0,0
 0,0 1))
 18:24:22  ST_StartPoint1|POINT(0 0)
 18:24:22  ST_EndPoint1|POINT(2 2)
 18:24:22  ST_PointN1|POINT(1 1)
 18:24:22
 -----------------------------------------------------------------------------


 18:24:28  tickets .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_96_diff)
 18:24:30
 -----------------------------------------------------------------------------
 18:24:30 --- tickets_expected   2021-08-15 18:10:52.358418000 -0400
 18:24:30 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_96_out
 2021-08-15 18:23:18.563244000 -0400
 18:24:30 @@ -1,4 +1,4 @@
 18:24:30 -#2|POLYGON((1 1,1 2,2 2,3 2,3 1,2 1,1 1))
 18:24:30 +#2|POLYGON((1 2,2 2,3 2,3 1,2 1,1 1,1 2))
 18:24:30  #11|0
 18:24:30  WARNING:  ST_Locate_Between_Measures and ST_Locate_Along_Measure
 were deprecated in 2.2.0. Please use ST_LocateAlong and ST_LocateBetween
 18:24:30  #21|SRID=31293;POINTM(6220.13 5337367.145 4566)
 18:24:30 @@ -130,7 +130,7 @@
 18:24:30  #723|f
 18:24:30  #804|<gml:Point srsName="urn:ogc:def:crs:EPSG::4326"><gml:pos
 srsDimension="2">0 0</gml:pos></gml:Point>
 18:24:30  #845|t
 18:24:30 -#834|GEOMETRYCOLLECTION(POINT(0 0 5),LINESTRING(10 10 5,10 0 5))
 18:24:30 +#834|GEOMETRYCOLLECTION(LINESTRING(10 10 4,10 0 5),POINT(0 0 5))
 18:24:30  #884|1|f
 18:24:30  #884|2|t
 18:24:30  #938|
 18:24:30 @@ -254,7 +254,7 @@
 18:24:30  #2412|LINESTRING(0 0,10 0,20 0)
 18:24:30  #2420.1|LINESTRING(0 0,10 0,10 10,0 10,0 0)
 18:24:30  #2420.2|LINESTRING(0 0,10 0,10 10,0 10)
 18:24:30 -#2423|POLYGON((-10 0,-9.2388 3.82683,-7.07107 7.07107,-3.82683
 9.2388,0 10,3.82683 9.2388,7.07107 7.07107,9.2388 3.82683,10 0,-10 0))
 18:24:30 +#2423|POLYGON((-9.80785 1.9509,-8.3147 5.5557,-5.5557
 8.3147,-1.9509 9.80785,1.9509 9.80785,5.5557 8.3147,8.3147 5.5557,9.80785
 1.9509,10 0,-10 0,-9.80785 1.9509))
 18:24:30  #2424|MULTILINESTRING((0 0,10 0,24 3,30 10))
 18:24:30  #2427|POINT(-1 0)
 18:24:30  #2168|5340.76237395|5340.76237395|0
 18:24:30
 -----------------------------------------------------------------------------

 18:24:53  unaryunion .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_113_diff)
 18:24:53
 -----------------------------------------------------------------------------
 18:24:53 --- unaryunion_expected        2021-08-15 18:10:52.368293000
 -0400
 18:24:53 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_113_out
 2021-08-15 18:23:41.783336000 -0400
 18:24:53 @@ -1,3 +1,3 @@
 18:24:53  1|MULTILINESTRING((0 0,5 0),(5 0,10 0),(5 -5,5 0),(5 0,5 5))
 18:24:53 -2|POLYGON((10 5,10 0,0 0,0 10,5 10,5 15,15 15,15 5,10 5))
 18:24:53 -3|GEOMETRYCOLLECTION(POINT(-5 4),LINESTRING(2 -10,2
 0),LINESTRING(2 10,2 20),POLYGON((10 5,10 0,2 0,0 0,0 10,2 10,5 10,5 15,15
 15,15 5,10 5)))
 18:24:53 +2|POLYGON((10 0,0 0,0 10,5 10,5 15,15 15,15 5,10 5,10 0))
 18:24:53 +3|GEOMETRYCOLLECTION(POINT(-5 4),POLYGON((2 0,0 0,0 10,2 10,5
 10,5 15,15 15,15 5,10 5,10 0,2 0)),LINESTRING(2 -10,2 0),LINESTRING(2 10,2
 20))
 18:24:53
 -----------------------------------------------------------------------------
 18:24:53  clean .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_114_diff)
 18:24:54
 -----------------------------------------------------------------------------
 18:24:54 --- clean_expected     2021-08-15 18:10:52.151356000 -0400
 18:24:54 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_114_out
 2021-08-15 18:23:42.853320000 -0400
 18:24:54 @@ -27,5 +27,5 @@
 18:24:54  PG|4|t|t|f
 18:24:54  PG|5|t|t|f
 18:24:54  #1719.1|POINT(0 0)
 18:24:54 -#1719.2|GEOMETRYCOLLECTION(POINT(0 0),MULTIPOINT(3 4,5
 2),POINT(4 4),MULTIPOLYGON(((0 0,5 5,10 0,0 0)),((5 5,0 10,10 10,5 5))))
 18:24:54 +#1719.2|GEOMETRYCOLLECTION(POINT(0 0),MULTIPOINT(3 4,5
 2),POINT(4 4),MULTIPOLYGON(((5 5,10 0,0 0,5 5)),((0 10,10 10,5 5,0 10))))
 18:24:54  #1719.3|MULTIPOINT(3 4,5 2)
 18:24:54
 -----------------------------------------------------------------------------

 18:26:04  mvt .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_127_diff)
 18:26:33
 -----------------------------------------------------------------------------
 18:26:33 --- mvt_expected       2021-08-15 18:10:52.182738000 -0400
 18:26:33 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_127_out
 2021-08-15 18:25:22.195001000 -0400
 18:26:33 @@ -1,11 +1,11 @@
 18:26:33  PG1|POINT(1 4094)
 18:26:33  PG2|POINT(0 4095)
 18:26:33  PG3|POINT(2 4092)
 18:26:33 -PG4|MULTIPOLYGON(((5 4096,10 4091,10 4096,5 4096)),((5 4096,0
 4101,0 4096,5 4096)))
 18:26:33 +PG4|MULTIPOLYGON(((10 4096,5 4096,10 4091,10 4096)),((0 4096,5
 4096,0 4101,0 4096)))
 18:26:33  PG5|
 18:26:33  PG6|POLYGON((2791 594,894 2704,600 594,2791 594))
 18:26:33  PG7|t
 18:26:33 -PG8|MULTIPOLYGON(((5 4096,10 4091,10 4096,5 4096)),((5 4096,0
 4101,0 4096,5 4096)))
 18:26:33 +PG8|MULTIPOLYGON(((10 4096,5 4096,10 4091,10 4096)),((0 4096,5
 4096,0 4101,0 4096)))
 18:26:33  PG9|16777216
 18:26:33  PG9.1|2|12.5|f
 18:26:33  PG10|
 18:26:33 @@ -45,7 +45,7 @@
 18:26:33  PG42 - ON |LINESTRING(0 10,0 0,1 0)
 18:26:33  PG42 - OFF|LINESTRING(0 10,0 0,1 0)
 18:26:33  PG43 - ON |MULTIPOLYGON(((5 5,0 0,10 0,5 5)),((5 5,10 10,0 10,5
 5)))
 18:26:33 -PG43 - OFF|MULTIPOLYGON(((5 5,-1 -1,11 -1,5 5)),((5 5,11 11,-1
 11,5 5)))
 18:26:33 +PG43 - OFF|MULTIPOLYGON(((11 -1,5 5,-1 -1,11 -1)),((-1 11,5 5,11
 11,-1 11)))
 18:26:33  PG44|
 18:26:33  PG45|
 18:26:33  PG46|SRID=3857;POLYGON((3262 2030,3253 2158,3245 2224,3262
 2030))

 18:26:33 -#4348Clip|t
 18:26:33 +#4348Clip|f

 18:26:36  sfcgal/regress_ogc_prep .. ok
 18:26:37  sfcgal/regress_ogc .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_135_diff)
 18:26:37
 -----------------------------------------------------------------------------
 18:26:37 --- sfcgal/regress_ogc_expected        2021-08-15
 18:10:52.230380000 -0400
 18:26:37 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_135_out
 2021-08-15 18:25:25.843214000 -0400
 18:26:37 @@ -91,7 +91,7 @@
 18:26:37  intersection|POINT(0 0)
 18:26:37  difference|MULTILINESTRING((0 -2,0 -10),(0 10,0 2))
 18:26:37  boundary|MULTILINESTRING((0 0,0 10,10 10,10 0,0 0),(2 2,2 4,4
 4,4 2,2 2))
 18:26:37 -symdifference|GEOMETRYCOLLECTION(LINESTRING(2 2,4
 4),LINESTRING(10 10,20 20),POLYGON((0 0,0 10,10 10,10 0,0 0),(4 4,2 4,2
 2,4 2,4 4)))
 18:26:37 +symdifference|GEOMETRYCOLLECTION(POLYGON((0 10,10 10,10 0,0 0,0
 10),(2 4,2 2,4 2,4 4,2 4)),LINESTRING(2 2,4 4),LINESTRING(10 10,20 20))

 18:26:37 -ST_Union1|POLYGON((0 0,0 1,0.5 1,0.5 1.5,1.5 1.5,1.5 0.5,1 0.5,1
 0,0 0))
 18:26:37 +ST_Union1|POLYGON((0 1,0.5 1,0.5 1.5,1.5 1.5,1.5 0.5,1 0.5,1 0,0
 0,0 1))
 18:26:37  ST_StartPoint1|POINT(0 0)
 18:26:37  ST_EndPoint1|POINT(2 2)
 18:26:37  ST_PointN1|POINT(1 1)
 18:26:37
 -----------------------------------------------------------------------------
 18:26:37  sfcgal/regress .. ok
 18:26:37  sfcgal/tickets .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_137_diff)
 18:26:39
 -----------------------------------------------------------------------------
 18:26:39 --- sfcgal/tickets_expected    2021-08-15 18:10:52.231601000
 -0400
 18:26:39 +++
 /home/jenkins/tmp/pgis_reg_d0d82e6b16bf2756e49c390d82a7ec80ca69ee5b/test_137_out
 2021-08-15 18:25:27.550356000 -0400
 18:26:39 @@ -1,4 +1,4 @@
 18:26:39 -#2|POLYGON((1 1,1 2,2 2,3 2,3 1,2 1,1 1))
 18:26:39 +#2|POLYGON((1 2,2 2,3 2,3 1,2 1,1 1,1 2))
 18:26:39  #11|0
 18:26:39  WARNING:  ST_Locate_Between_Measures and ST_Locate_Along_Measure
 were deprecated in 2.2.0. Please use ST_LocateAlong and ST_LocateBetween
 18:26:39  #21|SRID=31293;POINTM(6220.13 5337367.145 4566)
 18:26:39
 -----------------------------------------------------------------------------
 }}}

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