[postgis-tickets] [PostGIS] #2203: [raster]: Can't read out_db jpg in some cases

PostGIS trac at osgeo.org
Mon Feb 18 07:20:21 PST 2013 

#2203: [raster]: Can't read out_db jpg in some cases
---------------------+------------------------------------------------------
  Reporter:  robe    |       Owner:  dustymugs    
      Type:  defect  |      Status:  assigned     
  Priority:  medium  |   Milestone:  PostGIS 2.1.0
 Component:  raster  |     Version:  trunk        
Resolution:          |    Keywords:  history      
---------------------+------------------------------------------------------

Comment(by robe):

 Outputs from:

 {{{
 PostgreSQL 9.2.2 on x86_64-w64-mingw32, compiled by
 x86_64-w64-mingw32-gcc.exe (GCC) 4.5.4 20111030 (prerelease)
 [svn/rev.180676 - mingw-w64/oz], 64-bit POSTGIS="2.1.0SVN r11102"
 GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.9.2, released 2012/10/08" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER
 }}}

 {{{
 SELECT ST_SummaryStats(rast) from armory_outdb;

 NOTICE:  [rt_api.c:rt_raster_deserialize:8131] rt_raster_deserialize:
 Entering...
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8139] rt_raster_deserialize:
 Allocating memory for deserialized raster header
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8147] rt_raster_deserialize:
 Deserialize raster header
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8158] rt_raster_deserialize:
 Allocating memory for bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8166] rt_raster_deserialize: 3
 bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8192] rt_raster_deserialize: band
 0 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8260] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8261] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8304] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8192] rt_raster_deserialize: band
 1 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8260] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8261] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8304] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8192] rt_raster_deserialize: band
 2 with pixel type 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8260] rt_raster_deserialize: has
 nodata flag 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8261] rt_raster_deserialize:
 nodata value 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_deserialize:8304] rt_raster_deserialize: skip
 4 bytes of 8-bytes boundary padding
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3135] starting
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3170] nodata = 0.000000
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3171] hasnodata = 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3172] exclude_nodata_value =
 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3216] do_sample = 0
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_get_summary_stats:3238] sampling 27000000 of
 27000000 available pixels w/ 4500 per set
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1631] Raster geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, -1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1635] Using default
 geotransform matrix (0, 1, 0, 0, 0, -1)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1644] Offline geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, -1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_new:5197] Created rt_raster @
 000000000490FDD8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5934] GDALApplyGeoTransform
 (g -> c) for (0.000000, 0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5949] Corrected
 GDALApplyGeoTransform (g -> c) for (0.000000, 0.000000) = (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_cell_to_geopoint:5880] gt = (0.000000,
 1.000000, 0.000000, 0.000000, 0.000000, -1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_cell_to_geopoint:5884] GDALApplyGeoTransform
 (c -> g) for (-0.000000, -0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12578] rast1(ipX, ipxY) =
 (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12579] rast2(xr, yr) =
 (-0.000000, -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_same_alignment:12580] rast2(xw, yw) =
 (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_destroy:5226] Destroying rt_raster @
 000000000490FDD8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5934] GDALApplyGeoTransform
 (g -> c) for (0.000000, 0.000000) = (0.000000, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_geopoint_to_cell:5949] Corrected
 GDALApplyGeoTransform (g -> c) for (0.000000, 0.000000) = (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_load_offline_data:1668] offsets: (-0.000000,
 -0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9127] Raster dimensions
 (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9130] Creating new raster
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_new:5197] Created rt_raster @
 000000000490FDD8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9136] Created raster
 dimensions (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9150] Raster geotransform
 (0.000000, 1.000000, 0.000000, 0.000000, 0.000000, -1.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9183] GDAL Band 1 stats:
 0.000000, 255.000000, 98.720363, 81.487081
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9189] Processing band 1 of
 1
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9211] GDAL band dimensions
 (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9221] (hasnodata,
 nodataval) = (0, 0.000000)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_pixtype_size:973] Pixel type = 8BUI and size = 1
 bytes
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_new_inline:1328] Created rt_band @
 000000000490FE70 with pixtype 8BUI
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_band_new_inline:1341] Created rt_band with
 dimensions 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5516] Adding band 000000000490FE70
 to raster 000000000490FDD8
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5532] Oldbands at 0000000000000000
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5538] Checking bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5547] realloc returned
 000000000490FF08
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_add_band:5564] Raster now has 1 bands
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9235] Created band of
 dimension (width x height): 6000 x 4500
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9241] (nXBlockSize,
 nYBlockSize) = (128, 128)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9242] (nXBlocks, nYBlocks)
 = (47, 36)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9279] values len = 16384
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9285] (iXBlock, iYBlock) =
 (0, 0)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9286] (x, y) = (0, 0)
 CONTEXT:  SQL function "st_summarystats" statement 1
 NOTICE:  [rt_api.c:rt_raster_from_gdal_dataset:9302] (nXValid, nYValid) =
 (128, 128)
 CONTEXT:  SQL function "st_summarystats" statement 1
 ERROR:  rt_raster_from_gdal_dataset: Unable to get data from GDAL raster
 CONTEXT:  SQL function "st_summarystats" statement 1

 ********** Error **********

 ERROR: rt_raster_from_gdal_dataset: Unable to get data from GDAL raster
 SQL state: XX000
 Context: SQL function "st_summarystats" statement 1
 }}}

 Let me know if you need the local.  the local with debug enabled takes
 forever to load.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2203#comment:39>
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