[postgis-devel] [PostGIS] #1066: [raster] raster crashes server with arbitrary tests

[PostGIS]

#1066: [raster] raster crashes server with arbitrary tests
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  dustymugs    
      Type:  defect          |      Status:  assigned     
  Priority:  blocker         |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------

Comment(by robe):

 I haven't done the crash dump thing yet.  That requires me to test with my
 mingw install which I seem to be missing some dependency file for.  I
 assume its just some dll I forgot to copy.

 Anyrate I'm getting a totally different error now and one I have never
 seen before.


 {{{
 CONTEXT:  PL/pgSQL function "st_asraster" line 26 at RETURN
 psql:raster_gardentest_20.sql:16154: ERROR:  current transaction is
 aborted, com
 mands ignored until end of transaction block
 psql:raster_gardentest_20.sql:16176: lost synchronization with server: got
 messa
 ge type "D", length 288025282
 }}}

 When I run the offending line in isolation -- offending query is:


 {{{SELECT ST_AsRaster(foo2.the_geom, rast1.rast, '1BB', 1.5, 1.5, false),
 ST_AsEWKT(rast1.rast::geometry) As ref1_geom, ST_AsEWKT(foo2.the_geom) As
 ref2_geom

                                         FROM (
                         (SELECT
 ST_SetSRID(ST_SetValue(ST_AddBand(ST_MakeEmptyRaster( 100, 100, (i-1)*100,
 (i-1)*100, 0.0005, -0.0005, 0*i, 0*i), '1BB'), i, (i+1),0),4326) As rast
                                 FROM generate_series(1,10) As i)
                  ) As rast1 CROSS JOIN ((SELECT
 ST_Buffer(ST_SetSRID(ST_Point(i,j),4326), j*0.05)  As the_geom
                 FROM (SELECT a*1.11111111 FROM generate_series(-10,50,10)
 As a) As i(i)
                         CROSS JOIN generate_series(40,70, 20) As j
                         ORDER BY i, i*j, j)) As foo2
                                         LIMIT 2;
 }}}


 It generates this error:

 {{{

 ERROR:  out of memory
 DETAIL:  String of 288024126 bytes is too long for encoding conversion.
 }}}

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