Opened 10 years ago

Closed 10 years ago

#2897 closed defect (fixed)

winnie testing crashes on raster tests

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

Description

I've been ignoring this for a bit, but on winnie buildbot testing if I'm getting crashers on 9.2. Might be just bot specific since I was in middle of setting this extensions.

Issue doesn't exists in 2.2 which is compiling (and regressing) with GDAL 1.11.0.

This might be an incompatibility with GDAL I am compiling with. Seems its testing against 1.9 but compiling against 1.10.0 so have to figure out why that is. So might only happen if you compile with a different version of GDAL than what you are running with or a bug in GDAL 1.9

GEOS config:          /projects/geos/rel-3.4.2w64/bin/geos-config
  GEOS version:         3.4.2
  GDAL config:          /projects/gdal/rel-1.10.0w64/bin/gdal-config
  GDAL version:         1.10.0
  PostgreSQL config:    /projects/postgresql/rel/pg9.2w64/bin/pg_config
  PostgreSQL version:   PostgreSQL 9.2.4
  PROJ4 version:        48
  Libxml2 config:       /projects/libxml/rel-libxml2-2.7.8w64/bin/xml2-config
  Libxml2 version:      2.7.8
  JSON-C support:       yes
  PostGIS debug level:  0
  Perl:                 /bin/perl
PostgreSQL 9.2.4 on x86_64-w64-mingw32, compiled by gcc.exe (GCC) 4.5.4 20111030 (prerelease) [svn/rev.180676 - mingw-w64/oz], 64-bit
  Postgis 2.1.4dev
 - r12886
 - 2014-08-15 00:10:22
  scripts 2.1.4dev r12886
  raster scripts 2.1.4dev r12886
  GEOS: 3.4.2-CAPI-1.8.2 r0
  PROJ: Rel. 4.8.0, 6 March 2012
  GDAL: GDAL 1.9.1, released 2012/05/15

Running tests

 check_gdal .. ok 
 check_raster_columns .. ok 
 check_raster_overviews .. ok 
 rt_io .. ok 
 rt_bytea .. ok 
 box3d .. ok 
 rt_addband .. ok 
 rt_band .. ok 
 rt_tile .. ok 
 rt_dimensions .. ok 
 rt_scale .. ok 
 rt_pixelsize .. ok 
 rt_upperleft .. ok 
 rt_rotation .. ok 
 rt_georeference .. ok 
 rt_set_properties .. ok 
 rt_isempty .. ok 
 rt_hasnoband .. ok 
 rt_metadata .. ok 
 rt_rastertoworldcoord .. ok 
 rt_worldtorastercoord .. ok 
 rt_convexhull .. ok 
 rt_band_properties .. ok 
 rt_set_band_properties .. ok 
 rt_pixelaspolygons .. ok 
 rt_pixelaspoints .. ok 
 rt_pixelascentroids .. ok 
 rt_setvalues_array .. ok 
 rt_summarystats .. ok 
 rt_count .. ok 
 rt_histogram .. ok 
 rt_quantile .. ok 
 rt_valuecount .. ok 
 rt_valuepercent .. ok 
 rt_bandmetadata .. ok 
 rt_pixelvalue .. ok 
 rt_neighborhood .. ok 
 rt_nearestvalue .. ok 
 rt_pixelofvalue .. ok 
 rt_polygon .. ok 
 rt_utility .. ok 
 rt_reclass .. ok 
 rt_gdalwarp .. ok 
 rt_asraster .. ok 
 rt_dumpvalues .. ok 
 rt_mapalgebraexpr .. ok 
 rt_mapalgebrafct .. ok 
 rt_mapalgebraexpr_2raster .. ok 
 rt_mapalgebrafct_2raster .. ok 
 rt_mapalgebrafctngb .. ok 
 rt_mapalgebrafctngb_userfunc .. ok 
 rt_intersection .. ok 
 rt_clip .. ok 
 rt_mapalgebra .. ok 
 rt_mapalgebra_expr .. ok 
 rt_union .. ok 
 rt_invdistweight4ma .. ok 
 rt_4ma .. ok 
 rt_setvalues_geomval .. ok 
 rt_elevation_functions .. ok 
 rt_colormap .. ok 
 rt_gist_relationships .. ok 
 rt_intersects .. ok 
 rt_samealignment .. ok 
 rt_geos_relationships .. ok 
 rt_iscoveragetile .. ok 
 bug_test_car5 .. ok 
 permitted_gdal_drivers .. failed (diff expected obtained: /projects/postgis/tmp/2.1.4dev_pg9.2_geos3.4.2_gdal1.10.0w64/test_68_diff)
-----------------------------------------------------------------------------
--- permitted_gdal_drivers_expected	2014-05-04 12:24:55 -0400
+++ /projects/postgis/tmp/2.1.4dev_pg9.2_geos3.4.2_gdal1.10.0w64/test_68_out	2014-08-14 20:20:31 -0400
@@ -1,10 +1,6 @@
 DO
 4326
-ERROR:  RASTER_fromGDALRaster: Could not open bytea with GDAL. Check that the bytea is of a GDAL supported format
-ERROR:  rt_raster_load_offline_data: Access to offline bands disabled
-ERROR:  rt_raster_load_offline_data: Access to offline bands disabled
-4326
-4326
-ERROR:  rt_raster_load_offline_data: Access to offline bands disabled
-ERROR:  rt_raster_load_offline_data: Access to offline bands disabled
-4326
+server closed the connection unexpectedly
+	This probably means the server terminated abnormally
+	before or while processing the request.
+connection to server was lost
-----------------------------------------------------------------------------
 tickets .. failed (diff expected obtained: /projects/postgis/tmp/2.1.4dev_pg9.2_geos3.4.2_gdal1.10.0w64/test_69_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2013-11-27 11:24:51 -0500
+++ /projects/postgis/tmp/2.1.4dev_pg9.2_geos3.4.2_gdal1.10.0w64/test_69_out	2014-08-14 20:20:31 -0400
@@ -1 +1 @@
-#1485|0
+psql: FATAL:  the database system is in recovery mode
-----------------------------------------------------------------------------
 loader/Basic ... failed ( test: running raster2pgsql output: /projects/postgis/tmp/2.1.4dev_pg9.2_geos3.4.2_gdal1.10.0w64/loader.err)
-----------------------------------------------------------------------------
psql: FATAL:  the database system is in recovery mode
-----------------------------------------------------------------------------
 loader/BasicCopy .... ok 
 loader/BasicFilename .... ok 
 clean .. ok 
 uninstall .  /projects/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/uninstall_rtpostgis.sql
  /projects/postgis/branches/2.1/regress/00-regress-install/share/contrib/postgis/uninstall_postgis.sql
. ok (4061
)

Run tests: 74
Failed: 3
make[3]: *** [check] Error 3
make[3]: Leaving directory `/projects/postgis/branches/2.1/raster/test/regress'
make[2]: *** [check] Error 2
make[2]: Leaving directory `/projects/postgis/branches/2.1/raster/test'
make[1]: *** [check] Error 2
make[1]: Leaving directory `/projects/postgis/branches/2.1/raster'
make: *** [check] Error 1

Change History (1)

comment:1 by robe, 10 years ago

Resolution: fixed
Status: newclosed

I still have the issue with its building with GDAL 1.10.0 (not sure where it's getting that from). However I discovered I had accidentally polluted my postgresql bin folder with libgdal1.dll (from 1.9.2), so it was picking that up but the code was compiled with 1.10.0 which I think was what was causing the crashing. Once I deleted that file and the gdal-data folder I had also accidentally copied, it started passing regression again.

Note: See TracTickets for help on using tickets.