Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#3940 closed defect (fixed)

Regression failures on Bessies - FreeBSD 11 bots

Reported by: robe Owned by: pramsey
Priority: blocker Milestone: PostGIS 2.5.0
Component: QA/buildbots Version: master
Keywords: Cc:

Description (last modified by robe)

Getting some weird failures on FreeBSD bots. Unfortunately not sure how long it's been happening since I had an issue with the regress database not being dropped.

I'm also going to do a clean checkout to make sure it's not a something to do with dirty install.

The error from 64-bit looks like this a lot of proj type looking errors

04:48:26  -------------- Dependencies -------------- 
04:48:26   GEOS config:          /usr/local/bin/geos-config
04:48:26   GEOS version:         3.6.2
04:48:26   GDAL config:          /usr/local/bin/gdal-config
04:48:26   GDAL version:         2.2.2
04:48:26   SFCGAL config:        /usr/local/bin/sfcgal-config
04:48:26   SFCGAL version:       1.3.1
04:48:26   PostgreSQL config:    /usr/local/bin/pg_config
04:48:26   PostgreSQL version:   PostgreSQL 10.1
04:48:26   PROJ4 version:        49
04:48:26   Libxml2 config:       /usr/local/bin/xml2-config
04:48:26   Libxml2 version:      2.9.4
04:48:26   JSON-C support:       no
04:48:26   protobuf-c support:   no
04:48:26   PCRE support:         no
04:48:26   Perl:                 /usr/local/bin/perl
04:48:26 
04:48:26  --------------- Extensions --------------- 
04:48:26   PostGIS Raster:       enabled
04:48:26   PostGIS Topology:     enabled
04:48:26   SFCGAL support:       enabled
04:48:26   Address Standardizer support:       disabled
04:48:26 
04:48:26  -------- Documentation Generation -------- 
04:48:26   xsltproc:             /usr/local/bin/xsltproc
04:48:26   xsl style sheets:     
04:48:26   dblatex:              
04:48:26   convert:              /usr/local/bin/convert
04:48:26   mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

04:50:54  out_geometry .. failed (diff expected obtained: /home/jenkins/tmp/pgis_reg_trunk/test_55_diff)
04:50:54 -----------------------------------------------------------------------------
04:50:54 --- out_geometry_expected	2017-11-28 18:23:08.079753000 +0000
04:50:54 +++ /home/jenkins/tmp/pgis_reg_trunk/test_55_out	2017-12-11 23:49:31.008324000 +0000
04:50:54 @@ -27,8 +27,8 @@
04:50:54  gml_out_curve_03|<gml:Polygon><gml:exterior><gml:Ring><gml:curveMember><gml:Curve><gml:segments><gml:ArcString><gml:posList srsDimension="2">-2 0 -1 -1 0 0 1 -1 2 0 0 2 -2 0</gml:posList></gml:ArcString></gml:segments></gml:Curve></gml:curveMember></gml:Ring></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="2">-1 0 0 0.5 1 0 0 1 -1 0</gml:posList></gml:LinearRing></gml:interior></gml:Polygon>
04:50:54  gml_out_curve_04|<gml:MultiCurve><gml:curveMember><gml:Curve><gml:segments><gml:LineStringSegment><gml:posList srsDimension="2">5 5 3 5 3 3 0 3</gml:posList></gml:LineStringSegment></gml:segments></gml:Curve></gml:curveMember><gml:curveMember><gml:Curve><gml:segments><gml:ArcString><gml:posList srsDimension="2">0 0 2 1 2 2</gml:posList></gml:ArcString></gml:segments></gml:Curve></gml:curveMember></gml:MultiCurve>
04:50:54  gml_out_curve_05|<gml:MultiSurface><gml:Polygon><gml:exterior><gml:Ring><gml:curveMember><gml:Curve><gml:segments><gml:ArcString><gml:posList srsDimension="2">-2 0 -1 -1 0 0 1 -1 2 0 0 2 -2 0</gml:posList></gml:ArcString></gml:segments></gml:Curve></gml:curveMember></gml:Ring></gml:exterior><gml:interior><gml:LinearRing><gml:posList srsDimension="2">-1 0 0 0.5 1 0 0 1 -1 0</gml:posList></gml:LinearRing></gml:interior></gml:Polygon><gml:Polygon><gml:exterior><gml:LinearRing><gml:posList srsDimension="2">7 8 10 10 6 14 4 11 7 8</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:MultiSurface>
04:50:54 -ERROR:  GetProj4StringSPI: Cannot find SRID (10) in spatial_ref_sys
04:50:54 -ERROR:  Input geometry has unknown (0) SRID
04:50:54 +kml_srid_01|<Point><coordinates>0,1</coordinates></Point>
04:50:54 +kml_srid_02|<Point><coordinates>0,1</coordinates></Point>


04:51:00  regress_proj .. failed (diff expected obtained: /home/jenkins/tmp/pgis_reg_trunk/test_70_diff)
04:51:00 -----------------------------------------------------------------------------
04:51:00 --- regress_proj_expected	2017-11-28 18:23:08.196550000 +0000
04:51:00 +++ /home/jenkins/tmp/pgis_reg_trunk/test_70_out	2017-12-11 23:49:36.271043000 +0000
04:51:00 @@ -1,11 +1,11 @@
04:51:00  0|EMPTY
04:51:00 -1|SRID=100001;POINT(574600 5316780)
04:51:00 -2|SRID=100001;POINT(574600 5316780 171)
04:51:00 -3|SRID=100001;POINT(574600 5316780 171 -500)
04:51:00 -4|SRID=100001;LINESTRING(574600 5316780,573140 5427940)
04:51:00 -5|SRID=100001;LINESTRING(574600 5316780 0 0,573140 5427940 0 0)
04:51:00 +1|SRID=100002;POINT(20 50)
04:51:00 +2|SRID=100002;POINT(20 50 171)
04:51:00 +3|SRID=100002;POINT(20 50 171 -500)
04:51:00 +4|SRID=100002;LINESTRING EMPTY
04:51:00 +5|SRID=100002;LINESTRING EMPTY
04:51:00  6|16.00000000|48.00000000
04:51:00 -ERROR:  Input geometry has unknown (0) SRID
04:51:00 +010100000000000000000000000000000000000000
04:51:00  8|SRID=100002;POINT(0 0)
04:51:00  9|POINT(574600 5316780)
04:51:00  10|POINT(574600 5316780)
04:51:00 -----------------------------------------------------------------------------

04:51:04  #408|Too few points in geometry component[
04:51:04 @@ -123,7 +133,7 @@
04:51:04  #695
04:51:04  ERROR:  First argument must be a LINESTRING
04:51:04  #696|010f000080060000000103000080010000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000010300008001000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000000000000000000001030000800100000005000000000000000000000000000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000000001030000800100000005000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000010300008001000000050000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000103000080010000000500000000000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f
04:51:04 -#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)
04:51:04 +#720|MULTIPOINT(-10 40,-10 55,-10 70,5 40,5 55,5 70,20 40,20 55,20 70,35 40,35 55,35 70,50 40,50 55,50 70)
04:51:04  #723|0101000020e61000006284f068e33826c00000000000004440
04:51:04  #723|0107000020e610000000000000
04:51:04  #723|0107000020e610000000000000
04:51:04 @@ -187,7 +197,7 @@
04:51:04  #852.2|1|t|t
04:51:04  #852.2|2|t|t
04:51:04  #1489|MULTIPOINT EMPTY|0|MULTILINESTRING EMPTY|0|MULTIPOLYGON EMPTY|0|GEOMETRYCOLLECTION EMPTY|0
04:51:04 -ERROR:  AddToPROJ4SRSCache: could not parse proj4 string '' 
04:51:04 +#1150|POINT(0 0)

04:51:15  knn_recheck .. failed (diff expected obtained: /home/jenkins/tmp/pgis_reg_trunk/test_97_diff)
04:51:29 -----------------------------------------------------------------------------
04:51:29 --- knn_recheck_expected	2017-11-28 18:23:08.047960000 +0000
04:51:29 +++ /home/jenkins/tmp/pgis_reg_trunk/test_97_out	2017-12-11 23:50:05.996983000 +0000
04:51:29 @@ -38,30 +38,16 @@
04:51:29  #3|500101|600001|1106.0791|1106.0791
04:51:29  #3|500101|600002|1210.3577|1210.3577
04:51:29  #3|500101|12905|1239.5484|1239.5484
04:51:29 -#1g|500000|0.0000|0.0000
04:51:29 -#1g|600003|69974.6935|69974.6935
04:51:29 -#1g|2614|70976.1794|70976.1794
04:51:29 -#1g|2615|75048.8551|75048.8551
04:51:29 -#1g|2795|86965.9298|86965.9298
04:51:29 -#2g|31244|4189.9122|4189.9122
04:51:29 -#2g|31061|6756.6424|6756.6424
04:51:29 -#2g|30878|15161.4706|15161.4706
04:51:29 -#2g|30695|21264.3654|21264.3654
04:51:29 -#2g|30512|25313.2118|25313.2118
04:51:29 -#3g|1000|t
04:51:29 -#3g|500000|t
04:51:29 -#1g|500000|0.0000|0.0000
04:51:29 -#1g|600003|69974.6935|69974.6935
04:51:29 -#1g|2614|70976.1794|70976.1794
04:51:29 -#1g|2615|75048.8551|75048.8551
04:51:29 -#1g|2795|86965.9298|86965.9298
04:51:29 -#2g|31244|4189.9122|4189.9122
04:51:29 -#2g|31061|6756.6424|6756.6424
04:51:29 -#2g|30878|15161.4706|15161.4706
04:51:29 -#2g|30695|21264.3654|21264.3654
04:51:29 -#2g|30512|25313.2118|25313.2118
04:51:29 -#3g|1000|t
04:51:29 -#3g|500000|t
04:51:29 +NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
04:51:29 +NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
04:51:29 +NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
04:51:29 +NOTICE:  Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29 +ERROR:  BOOM! Could not generate outside point!
04:51:29  #1nd-3|290|260.6797|260.6797
04:51:29  #1nd-3|287|264.3000|264.3000
04:51:29  #1nd-3|579|265.4356|265.4356
04:51:29 -----------------------------------------------------------------------------

and others

Change History (6)

comment:1 by robe, 7 years ago

Description: modified (diff)

comment:2 by robe, 7 years ago

I see similar wierdness on bessie32 so if it's just repo dirt, surprising they are both making the same screams since they are on separate virtual boxes so have their own local checkout.

comment:3 by robe, 7 years ago

okay I think the culprit is one of these recent commits by pramsey

r16141 r16142 r16143

Given where the errors are springing up most likely r16143

Last edited 7 years ago by robe (previous) (diff)

comment:4 by robe, 7 years ago

Owner: changed from robe to pramsey
Summary: Regression failures on Bessies - FReeBSD 11 botsRegression failures on Bessies - FreeBSD 11 bots

Confirmed it is r16143 (I retested both r16142 and r16143). r16142 was fine and things going south at r16143.

Creating database 'postgis_reg'
Preparing db 'postgis_reg' using: CREATE EXTENSION postgis
PostgreSQL 10.1 on amd64-portbld-freebsd11.0, compiled by FreeBSD clang version 3.8.0 (tags/RELEASE_380/final 262564) (based on LLVM 3.8.0), 64
  Postgis 2.5.0dev - r16143 - 2017-12-12 00:50:31
  scripts 2.5.0dev r16143
  raster scripts 2.5.0dev r16143
  GEOS: 3.6.2-CAPI-1.10.2 4d2925d6
  PROJ: Rel. 4.9.3, 15 August 2016
  SFCGAL: 1.3.1
  GDAL: GDAL 2.2.2, released 2017/09/15

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 .... failed ( wkt test: running shp2pgsql output: /root/tmp/pgis_reg_2.5/loader.err)
 loader/ReprojectPtsGeog .... failed ( wkt test: running shp2pgsql output: /root/tmp/pgis_reg_2.5/loader.err)
 loader/Latin1 .... ok
 loader/Latin1-implicit .... ok
 loader/mfile .... ok
 dumper/literalsrid ....... ok
 dumper/realtable ....... ok
 affine .. ok
 bestsrid .. ok
 binary .. ok
 boundary .. ok
 cluster .. ok
 concave_hull .. ok
 ctors .. ok
 curvetoline .. ok
 dump .. ok
 dumppoints .. ok
 empty .. ok
 estimatedextent .. ok
 forcecurve .. ok
 geography .. ok
 geometric_median .. ok
 in_geohash .. ok
 in_gml .. ok
 in_kml .. ok
 in_encodedpolyline .. ok
 iscollection .. ok
 legacy .. ok
 long_xact .. ok
 lwgeom_regress .. ok
 measures .. ok
 minimum_bounding_circle .. ok
 normalize .. ok
 operators .. ok
 orientation .. ok
 out_geometry .. failed (diff expected obtained: /root/tmp/pgis_reg_2.5/test_55_diff)
 out_geography .. ok
 polygonize .. ok
 polyhedralsurface .. ok
 postgis_type_name .. ok
 regress .. ok
 regress_bdpoly .. ok
 regress_index .. ok
 regress_index_nulls .. ok
 regress_management .. ok
 regress_selectivity .. ok
 regress_lrs .. ok
 regress_ogc .. ok
 regress_ogc_cover .. ok
 regress_ogc_prep .. ok
 regress_proj .. failed (diff expected obtained: /root/tmp/pgis_reg_2.5/test_70_diff)
 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
 tickets .. failed (diff expected obtained: /root/tmp/pgis_reg_2.5/test_91_diff)
 twkb .. ok
 typmod .. ok
 wkb .. ok
 wkt .. ok
 wmsservers .. ok
 knn_recheck .. failed (diff expected obtained: /root/tmp/pgis_reg_2.5/test_97_diff)
 temporal_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
 clipbybox2d .. ok
 subdivide .. ok
 voronoi .. ok
 minimum_clearance .. ok
 regress_brin_index .. ok
 regress_brin_index_3d .. ok
 regress_brin_index_geography .. ok
 regress_sfcgal .. ok
 sfcgal/empty .. ok
 sfcgal/geography .. ok
 sfcgal/legacy .. ok
 sfcgal/measures .. ok
 sfcgal/regress_ogc_prep .. ok
 sfcgal/regress_ogc .. ok
 sfcgal/regress .. ok
 sfcgal/tickets .. failed (diff expected obtained: /root/tmp/pgis_reg_2.5/test_126_diff)
 sfcgal/concave_hull .. ok
 sfcgal/wmsservers .. ok
 sfcgal/approximatemedialaxis .. ok
 uninstall .. ok (4663)

Run tests: 130
Failed: 7
gmake[2]: *** [Makefile:303: check] Error 7
gmake[2]: Leaving directory '/usr/home/jenkins/workspace/2.5/regress'
gmake[1]: *** [GNUmakefile:16: check] Error 1
gmake[1]: Leaving directory '/usr/home/jenkins/workspace/2.5'
*** Error code 2

Switching over to pramsey

comment:5 by robe, 7 years ago

Resolution: fixed
Status: newclosed

In 16148:

Move input_srid == output_srid check after input_srid is initialized
Closes #3940

comment:6 by pramsey, 7 years ago

In 16150:

Return pointer? references #3940

Note: See TracTickets for help on using tickets.