[postgis-tickets] [PostGIS] #4329: PostgreSQL 12 many regression failures Look like rounding
PostGIS
trac at osgeo.org
Tue Feb 19 16:18:52 PST 2019
#4329: PostgreSQL 12 many regression failures Look like rounding
-------------------------+---------------------------
Reporter: robe | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.5.2
Component: postgis | Version: trunk
Keywords: postgres 12 |
-------------------------+---------------------------
I'm not sure how long this has been going on. I suspect somewhere between
Feb 11th and Feb 15th is when it started.
Debbie has this with pg12 head
I've disabled her 12 testing on PostGIS 2.5, but kept it on for 3.0
{{{
Checking for shp2pgsql ... found
Checking for pgsql2shp ... found
TMPDIR is /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64
Creating database 'postgis_reg'
Loading PostGIS into 'postgis_reg'
/var/lib/jenkins/workspace/postgis/branches/3.0/regress/00-regress-
install/share/contrib/postgis/postgis.sql
/var/lib/jenkins/workspace/postgis/branches/3.0/regress/00-regress-
install/share/contrib/postgis/postgis_comments.sql
/var/lib/jenkins/workspace/postgis/branches/3.0/regress/00-regress-
install/share/contrib/postgis/postgis_proc_set_search_path.sql
PostgreSQL 12devel on x86_64-pc-linux-gnu, compiled by gcc (Debian
8.2.0-9) 8.2.0, 64-bit
Postgis 3.0.0dev - r17261 - 2019-02-19 04:35:15
scripts 3.0.0dev r17261
GEOS: 3.7.2dev-CAPI-1.11.2 0cd06b20
PROJ: Rel. 5.2.0, September 15th, 2018
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
../loader/Latin1-implicit .... ok
../loader/mfile .... ok
../dumper/literalsrid ....... ok
../dumper/realtable ....... ok
affine .. ok
bestsrid .. ok
binary .. ok
boundary .. ok
chaikin .. ok
filterm .. ok
cluster .. ok
concave_hull .. ok
concave_hull_hard .. ok
ctors .. ok
curvetoline .. ok
dump .. ok
dumppoints .. ok
empty .. ok
estimatedextent .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_41_diff)
-----------------------------------------------------------------------------
--- estimatedextent_expected 2019-01-23 17:21:20.650097294 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_41_out
2019-02-19 04:38:35.021379610 +0000
@@ -6,17 +6,32 @@
WARNING: stats for "t.g" do not exist
#877.2.deprecated|
WARNING: stats for "t.g" do not exist
+WARNING: stats for "t.g" do not exist
+WARNING: stats for "t.g" do not exist
+WARNING: stats for "t.g" do not exist
#877.3||||
#877.4|-10.15000|20.15000|-50.40000|30.40000
#877.5|-10.15000|20.15000|-50.40000|30.40000
WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
#3391.1||||
WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
#3391.2||||
WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
#3391.3||||
#3391.4|0.00|1.00|0.00|1.00
WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
+WARNING: stats for "c2.g" do not exist
#3391.5||||
#3391.6|0.00|1.00|0.00|1.00
#3391.7|0.00|1.00|0.00|1.00
@@ -26,15 +41,30 @@
#3391.11|-1.00|0.00|-1.00|0.00
#3391.12|-1.01|2.02|-1.01|2.02
WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
#3391.13||||
WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
#3391.14||||
WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
#3391.15||||
WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
+WARNING: stats for "c1.g" do not exist
#3391.16||||
#3391.17|0.00|1.00|0.00|1.00
WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
+WARNING: stats for "p.g" do not exist
#3391.18||||
#3391.19|0.00|1.00|0.00|1.00
#3391.20|0.00|1.00|0.00|1.00
-----------------------------------------------------------------------------
forcecurve .. ok
geography .. ok
geometric_median .. ok
hausdorff .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_45_diff)
-----------------------------------------------------------------------------
--- hausdorff_expected 2018-10-19 23:06:41.113379730 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_45_out
2019-02-19 04:38:35.293380987 +0000
@@ -1,6 +1,6 @@
-hausdorff_poly_poly|0.707106781186548
+hausdorff_poly_poly|0.7071067811865476
hausdorff_ls_ls|1
hausdorff_ls_ls_2|2
hausdorff_ls_mp|1
-hausdorff_ls_ls_3|14.142135623731
+hausdorff_ls_ls_3|14.142135623730951
hausdorffdensify_ls_ls|70
-----------------------------------------------------------------------------
in_geohash .. ok
in_gml .. ok
in_kml .. ok
in_encodedpolyline .. ok
iscollection .. ok
knn_recheck .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_51_diff)
-----------------------------------------------------------------------------
--- knn_recheck_expected 2018-10-19 23:06:41.065380052 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_51_out
2019-02-19 04:38:57.481493351 +0000
@@ -103,5 +103,5 @@
#3nd-3|600001|9749|54.5453|54.5453
#3nd-3|600001|10041|54.6233|54.6233
#3573|8
-#3418|0.331823813642119|0.331823813642119
+#3418|0.33182381364211927|0.33182381364211927
#3418|0.55|0.55
-----------------------------------------------------------------------------
legacy .. ok
long_xact .. ok
lwgeom_regress .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_54_diff)
-----------------------------------------------------------------------------
--- lwgeom_regress_expected 2018-10-19 23:06:41.121379675 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_54_out
2019-02-19 04:38:58.309497543 +0000
@@ -28,8 +28,8 @@
ERROR: Argument must be POINT geometries
ERROR: parse error - invalid geometry
ST_Angle_4_pts|4.71238898038469
-ST_Angle_4_pts|0.785398163397448
-ST_Angle_3_pts|1.5707963267949
+ST_Angle_4_pts|0.7853981633974483
+ST_Angle_3_pts|1.5707963267948966
ERROR: Operation on mixed SRID geometries
ERROR: Empty geometry
ST_Angle_2_lines|4.71238898038469
-----------------------------------------------------------------------------
measures .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_55_diff)
-----------------------------------------------------------------------------
--- measures_expected 2019-02-18 08:55:22.999999325 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_55_out
2019-02-19 04:38:58.381497909 +0000
@@ -1,9 +1,9 @@
113|291
114|140
115|140
-116|4.24264068711929
-117|4.24264068711929
-118|5.19615242270663
+116|4.242640687119286
+117|4.242640687119286
+118|5.196152422706632
134|0
135|13
136|13
@@ -16,7 +16,7 @@
st_maxdistance_134|0
st_maxdistance_135|13
st_maxdistance_136|13
-st_maxdistance_dist|22.3606797749979|22.3606797749979
+st_maxdistance_dist|22.360679774997898|22.360679774997898
st_longestline_134|LINESTRING(1 2,1 2)
st_longestline_135|LINESTRING(5 0,10 12)
st_longestline_136|LINESTRING(0 0,5 12)
@@ -25,14 +25,14 @@
distancetest2|0|50|0.0000000000|0.0000000000|0.0000000000|0.0000000000|LINESTRING(-40
-20,-10 20)|LINESTRING(-10 20,-40 -20)
distancepoly1|1|50|LINESTRING(17 18,17 19)|LINESTRING(17 19,17
18)|LINESTRING(29 39,-1 -1)|LINESTRING(-1 -1,29 39)
distancepoly2|0|26.1725046566048|LINESTRING(17 14,17 14)|LINESTRING(17
14,17 14)|LINESTRING(17 18,-1 -1)|LINESTRING(-1 -1,17 18)
-distancepoly3|0|26.9072480941474|LINESTRING(17 19,17 19)|LINESTRING(17
19,17 19)|LINESTRING(17 19,-1 -1)|LINESTRING(-1 -1,17 19)
-distancepoly4|0|28.3196045170126|LINESTRING(16 19,16 19)|LINESTRING(16
19,16 19)|LINESTRING(18 20,-1 -1)|LINESTRING(-1 -1,18 20)
+distancepoly3|0|26.90724809414742|LINESTRING(17 19,17 19)|LINESTRING(17
19,17 19)|LINESTRING(17 19,-1 -1)|LINESTRING(-1 -1,17 19)
+distancepoly4|0|28.319604517012593|LINESTRING(16 19,16 19)|LINESTRING(16
19,16 19)|LINESTRING(18 20,-1 -1)|LINESTRING(-1 -1,18 20)
distancepoly5|0|26.1725046566048|LINESTRING(17 12,17 12)|LINESTRING(17
12,17 12)|LINESTRING(17 18,-1 -1)|LINESTRING(-1 -1,17 18)
-distancepoly6|0|32.5269119345812|LINESTRING(2 2,2 2)|LINESTRING(2 2,2
2)|LINESTRING(2 2,25 25)|LINESTRING(25 25,2 2)
-3dDistancetest1|6.40312423743285|6.40312423743285|f|f|LINESTRING(1 1 1,3
2 7)|POINT(1 1 1)|LINESTRING(1 1 1,3 2 7)
-3dDistancetest2|0|1.73205080756888|t|t|LINESTRING(1 1 1,1 1 1)|POINT(1 1
1)|LINESTRING(1 1 1,0 0 0)
+distancepoly6|0|32.526911934581186|LINESTRING(2 2,2 2)|LINESTRING(2 2,2
2)|LINESTRING(2 2,25 25)|LINESTRING(25 25,2 2)
+3dDistancetest1|6.4031242374328485|6.4031242374328485|f|f|LINESTRING(1 1
1,3 2 7)|POINT(1 1 1)|LINESTRING(1 1 1,3 2 7)
+3dDistancetest2|0|1.7320508075688772|t|t|LINESTRING(1 1 1,1 1 1)|POINT(1
1 1)|LINESTRING(1 1 1,0 0 0)
3dDistancetest3|4.09994192757944|6.48074069840786|t|f|LINESTRING(1 1
1,0.61904761904762 -0.19047619047619 4.90476190476191)|POINT(1 1
1)|LINESTRING(1 1 1,5 2 6)
-3dDistancetest4|2|10.0498756211209|t|f|LINESTRING(1 1 3,1 1 1)|POINT(1 1
3)|LINESTRING(5 7 8,1 1 1)
+3dDistancetest4|2|10.04987562112089|t|f|LINESTRING(1 1 3,1 1 1)|POINT(1 1
3)|LINESTRING(5 7 8,1 1 1)
3dDistancetest5|2|10|t|f|LINESTRING(5 0 5,5 2 5)|POINT(5 0
5)|LINESTRING(11 0 5,5 0 13)
3dDistancetest6|0
3dDistancetest7|0
-----------------------------------------------------------------------------
minimum_bounding_circle .. ok
normalize .. ok
operators .. ok
orientation .. ok
out_geometry .. ok
out_geography .. ok
polygonize .. ok
polyhedralsurface .. ok
postgis_type_name .. ok
quantize_coordinates .. ok
regress .. ok
regress_bdpoly .. ok
regress_buffer_params .. ok
regress_gist_index_nd .. ok
regress_index .. ok
regress_index_nulls .. ok
regress_management .. ok
regress_selectivity .. ok
regress_lrs .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_74_diff)
-----------------------------------------------------------------------------
--- regress_lrs_expected 2018-12-03 21:53:22.510210503 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_74_out
2019-02-19 04:39:03.129521953 +0000
@@ -20,7 +20,7 @@
#4155.1|MULTILINESTRING Z ((2 2 2,5 5 5))
#4155.2|TIN Z EMPTY
#4155.3|MULTIPOLYGON Z EMPTY
-line_locate_point_1|0.528602749909894
+line_locate_point_1|0.5286027499098938
line_locate_point_2|1
line_locate_point_3|0
line_locate_point_4|0
-----------------------------------------------------------------------------
regress_ogc .. ok
regress_ogc_cover .. ok
regress_ogc_prep .. ok
regress_proj .. ok
relate .. ok
remove_repeated_points .. ok
removepoint .. ok
reverse .. ok
setpoint .. ok
simplify .. ok
simplifyvw .. ok
size .. ok
snaptogrid .. ok
split .. 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
swapordinates .. ok
summary .. ok
temporal .. ok
temporal_knn .. ok
tickets .. ok
twkb .. ok
typmod .. ok
wkb .. ok
wkt .. ok
wmsservers .. ok
offsetcurve .. ok
relatematch .. ok
isvaliddetail .. ok
sharedpaths .. ok
snap .. ok
node .. ok
unaryunion .. ok
clean .. ok
relate_bnr .. ok
delaunaytriangles .. ok
clipbybox2d .. ok
subdivide .. ok
voronoi .. ok
regress_brin_index .. ok
regress_brin_index_3d .. ok
regress_brin_index_geography .. ok
minimum_clearance .. ok
oriented_envelope .. ok
frechet .. failed (diff expected obtained:
/var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_124_diff)
-----------------------------------------------------------------------------
--- frechet_expected 2018-10-19 23:06:40.889381235 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_124_out
2019-02-19 04:39:27.985647831 +0000
@@ -1,5 +1,5 @@
frechet_ls_ls|1
frechet_ls_ls_2|2.23606797749979
frechet_ls_mp|1
-frechet_ls_ls_3|70.7106781186548
+frechet_ls_ls_3|70.71067811865476
frechetdensify_ls_ls|50
-----------------------------------------------------------------------------
in_geojson .. ok
regress_spgist_index_2d .. ok
regress_spgist_index_3d .. ok
regress_spgist_index_nd .. ok
mvt .. ok
geobuf .. ok
mvt_jsonb .. ok
uninstall . /var/lib/jenkins/workspace/postgis/branches/3.0/regress/00
-regress-install/share/contrib/postgis/uninstall_postgis.sql
. ok (4679)
Run tests: 132
Failed: 7
make[2]: *** [Makefile:212: check] Error 7
make[2]: Leaving directory
'/var/lib/jenkins/workspace/postgis/branches/3.0/regress/core'
make[1]: *** [Makefile:28: check] Error 2
make[1]: Leaving directory
'/var/lib/jenkins/workspace/postgis/branches/3.0/regress'
make: *** [GNUmakefile:20: check] Error 1
}}}
I compiled PostgreSQL 12 and get same failures.
at a glance looks like mostly rounding issues that perhaps buttoning up
the tests with some grace for floats will solve.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4329>
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