[postgis-tickets] [PostGIS] #3937: Failure on bessie32 regress_brin tests

[PostGIS]

#3937: Failure on bessie32 regress_brin tests
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:  PostGIS 2.5.0
Component:  postgis  |    Version:  2.4.x
 Keywords:           |
---------------------+---------------------------
 So I got bessie32 up and going after I was done with bessie (64-bit).
 Both are FreeBSD 11.1 (bessie is 64-bit, bessie32 is 32-bit)

 Tested on trunk, but assume same issue is probably in 2.4 and possibly 2.3
 since we haven't touched brin in a while.

 bessie passes all tests (though I'm having trouble getting postgis find
 the Cunit install).

 Bessie32 configure

 {{{
  PostGIS is now configured for i386-unknown-freebsd11.1

  -------------- Compiler Info -------------
   C compiler:           cc -g -O2
   SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P

  -------------- Dependencies --------------
   GEOS config:          /usr/local/bin/geos-config
   GEOS version:         3.6.2
   GDAL config:          /usr/local/bin/gdal-config
   GDAL version:         2.2.2
   PostgreSQL config:    /usr/local/bin/pg_config
   PostgreSQL version:   PostgreSQL 10.1
   PROJ4 version:        49
   Libxml2 config:       /usr/local/bin/xml2-config
   Libxml2 version:      2.9.4
   JSON-C support:       no
   protobuf-c support:   no
   PCRE support:         no
   Perl:                 /usr/local/bin/perl

  --------------- Extensions ---------------
   PostGIS Raster:       enabled
   PostGIS Topology:     enabled
   SFCGAL support:       disabled
   Address Standardizer support:       disabled

  -------- Documentation Generation --------
   xsltproc:             /usr/local/bin/xsltproc
   xsl style sheets:
   dblatex:
   convert:              /usr/local/bin/convert
   mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

 configure: WARNING:  --------- GEOS VERSION WARNING ------------
 configure: WARNING:   You are building against GEOS 3.6.2
 configure: WARNING:   To take advantage of all the features of
 configure: WARNING:   this PostGIS version requires GEOS 3.7.0 or higher
 which is not out yet.
 configure: WARNING:   To take advantage of most of the features of this
 PostGIS
 configure: WARNING:   we recommend GEOS 3.6 or higher
 configure: WARNING:   You can download the latest versions from
 configure: WARNING:   http://trac.osgeo.org/geos
 configure: WARNING:
 }}}


 bessie32 is not happy with some tests.


 {{{
 Creating database 'postgis_reg'
 Loading PostGIS into 'postgis_reg'

 PostgreSQL 10.1 on i386-portbld-freebsd11.0, compiled by FreeBSD clang
 version 3.8.0 (tags/RELEASE_380/final 262564) (based on LLVM 3.8.0),
 32-bit
   Postgis 2.5.0dev - r16117 - 2017-11-26 23:49:21
   scripts 2.5.0dev r16117
   GEOS: 3.6.2-CAPI-1.10.2 4d2925d6
   PROJ: Rel. 4.9.3, 15 August 2016

 minimum_clearance .. ok

  regress_brin_index .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_trunk/test_118_diff)
  regress_brin_index_3d .. failed (diff expected obtained:
 /home/jenkins/tmp/pgis_reg_trunk/test_119_diff)
  regress_brin_index_geography .. ok

  uninstall .. ok (4663)

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

 Stop.
 make: stopped in /usr/home/jenkins/workspace/Test_Slave/trunk
 Build step 'Execute shell' marked build as failure
 Finished: FAILURE

 }}}

 Output of diffs is as follows:

 #regress_brin_index

 {{{
 @@ -42,20 +42,20 @@
  2d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  2d|20
 -summarize 2d|8
 +summarize 2d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  2d|20
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|20
 -summarize 3d|8
 +summarize 3d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|20
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|20
 -summarize 4d|8
 +summarize 4d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|20
 }}}

 #regress_brin_index3d

 {{{
 @@ -134,21 +134,21 @@
  2d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  2d|20
 -summarize 2d|8
 +summarize 2d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  2d|20
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|20
 -summarize 3d|8
 +summarize 3d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  3d|20
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|1
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|20
 -summarize 4d|8
 +summarize 4d|7
  scan_idx|Bitmap Heap Scan,Bitmap Index Scan
  4d|20
  scan_seq|Seq Scan
 }}}

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