[postgis-tickets] [PostGIS] #2224: [raster]: raster2pgsql tiled outdb crashes

[PostGIS]

#2224: [raster]: raster2pgsql tiled outdb crashes
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  high    |   Milestone:  PostGIS 2.1.0
Component:  raster  |     Version:  trunk        
 Keywords:          |  
--------------------+-------------------------------------------------------
 I haven't tried all permutations of this, but I wanted to do some speed
 tests for queries using my in db aerials vs. same aerials stored out db
 using the same tile settings. this is testing with
  r11142

 My command looks like this:

 {{{
 raster2pgsql -I -e -F -C -Y -R -s 26986 -t 500x500 -l 2 *.jpg
 aerials.boston_outdb | psql
 }}}


 I'll need to also retry this with indb since when I did the in db it was
 in PostGIS 2.0.

 I'm also going to try without tiling.  Anyway things sort of move smoothly
 except for this notice for each tile:


 {{{
 Processing 116/116: E:/GISDATA/bostonaerials2008/jpeg/25229020.sid.jpg
 }}}

 and its when it finally gets to the last tile that it crashes. Presumably
 when trying to apply constraints and so forth.


 {{{
   Fault Module Version: 6.1.7601.17725
   Fault Module Timestamp:       4ec4aa8e
   Exception Code:       c0000374
   Exception Offset:     00000000000c40f2
   OS Version:   6.1.7601.2.1.0.274.10
   Locale ID:    1033
   Additional Information 1:     6005
   Additional Information 2:     6005ee1f61854d6369e1fbaa6883c156
   Additional Information 3:     9869
   Additional Information 4:     986908455240911563ee66b8d79d92ea
 }}}

 which looks like gibberish.
 when I close the crash window -- it shows this notice in console:


 {{{
 ERROR: diff_rastinfo: Could not run raster alignment test
 ERROR:  rt_raster_from_hexwkb: Raster HEXWKB input must have an even
 number of c
 haracters
 CONTEXT:  COPY o_2_boston_outdb, line 25, column rast:
 "01000003006E3433333333E3
 3FD73433333333E3BFBBCA487D73D80E4136BCAF0C86832B4100000000000000000000000000..."
 }}}

 I'm running this on Windows 2008 64-bit using


 {{{
 PostgreSQL 9.2.3, compiled by Visual C++ build 1600, 64-bit
 POSTGIS="2.1.0SVN r11142" 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" TOPOLOGY (topology procs from "2.1.0SVN r11095" need
 upgrade) RASTER
 }}}

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