[postgis-devel] [PostGIS] #518: Postgres backend terminated by exception 0xC0000005

[PostGIS]

#518: Postgres backend terminated by exception 0xC0000005
-----------------------+----------------------------------------------------
  Reporter:  loldrup   |       Owner:  pramsey                     
      Type:  defect    |      Status:  new                         
  Priority:  critical  |   Milestone:                              
 Component:  postgis   |     Version:  1.4.X                       
Resolution:            |    Keywords:  backend terminated exception
-----------------------+----------------------------------------------------
Comment (by loldrup):

 Did a linux build of Postgres 8.4.3 including POSTGIS="1.4.2"
 GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS,
 and compiled with --enable-cassert

 Changed postgresql.conf with the following options:
 max_connections = 10
 shared_buffers = 128kB
 client_min_messages = debug5
 log_min_messages = debug5

 Ran the test again, starting at 09:34 - runnung stable without problems
 (as expected on a linux build). At 13:34, and 1.889.000 samples the 5
 backends was using between 109 and 123MB virtual memory each. At 16:20
 JMeter came to a halt, probably another leak there.

 I got a 3.9G log-file from postgres, but nothing special there - anyone
 with a neural network that can grep for "non repeated things" in a GB
 file?

 I am not realy sure what can be concluded at this point apart, that there
 is some leak in both platforms, and a to low shared_buffers triggers a
 problem on win platform.

 At 17:05 JMeter out controll, so I stopped it.

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