[postgis-devel] [PostGIS] #1659: ST_Union raster out of memory then kicks the bucket on windows 64bit

PostGIS trac at osgeo.org
Tue Mar 6 21:20:30 PST 2012


#1659: ST_Union raster out of memory then kicks the bucket on windows 64bit
----------------------------------------+-----------------------------------
 Reporter:  robe                        |       Owner:  pramsey      
     Type:  defect                      |      Status:  new          
 Priority:  medium                      |   Milestone:  PostGIS 2.0.0
Component:  postgis                     |     Version:  trunk        
 Keywords:  mingw windows 64bit, 32bit  |  
----------------------------------------+-----------------------------------
 I ran this test on my mingw32 build (on PostgreSQL windows 32-bit on
 windows 7 64-bit) and my mingw64bit (on PostgreSQL windows 64-bit windows
 2003).


 {{{
 SELECT ST_AsEWKT(ST_ConvexHull(ST_Union(rast1.rast, 1))) 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), '16BSI'), i, (i+1),-6000),4326) As
 rast FROM generate_series(1,10) As i) ) As rast1 LIMIT 3;
 }}}

 On my postgsi 32 bit it gives error

 {{{
 NOTICE:  Neither raster provided has a NODATA value for the specified band
 indices.  NODATA value set to minimum possible for 16BSI
 CONTEXT:  PL/pgSQL function "_st_mapalgebra4unionstate" line 13 at RETURN
 SQL function "_st_mapalgebra4unionstate" statement 1
 ERROR:  out of memory
 DETAIL:  Failed on request of size 373628520.
 CONTEXT:  PL/pgSQL function "_st_mapalgebra4unionstate" line 13 at RETURN
 SQL function "_st_mapalgebra4unionstate" statement 1

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

 ERROR: out of memory
 SQL state: 53200
 Detail: Failed on request of size 373628520.
 Context: PL/pgSQL function "_st_mapalgebra4unionstate" line 13 at RETURN
 SQL function "_st_mapalgebra4unionstate" statement 1

 }}}

 on the 64-bit build it gives


 {{{
 NOTICE:  Neither raster provided has a NODATA value for the specified band
 indices.  NODATA value set to minimum possible for 16BSI
 CONTEXT:  PL/pgSQL function "_st_mapalgebra4unionstate" line 13 at RETURN
 SQL function "_st_mapalgebra4unionstate" statement 1
 ********** Error **********
 }}}

 Then just kills the service.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1659>
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-devel mailing list