[Geoserver-users] Antw: geoserver opening up many postgres connections

Hi,

i observed the same behaviour when GE starts.
It takes a long time to load the data for the first time.
After fully loading there are more than 600 sessions opened for GeoServer in Tomcat Manager.
to compare : a GeoServer instance used as a WFS-Gazetteer and more than 500 Request per hour opens averagly 100 sessions.
Additionally i get sometimes the following error message from GeoServer :

---->
INFO: handling request:
GetMap Request
version: 1.1.1
output format: application/vnd.google-earth.kmz XML
width height: 1024,1024
bbox: Env[11.8091849300848 : 12.51688839412645, 53.99691939262987 : 54.37056257648141]
layers: hro:BAUSTELLE_AKT
styles: hro_baustellen
17.07.2007 10:07:16 org.vfny.geoserver.servlets.AbstractService sendError
SCHWERWIEGEND: Service exception occurred
org.vfny.geoserver.wms.WmsException: Java heap space
  at org.vfny.geoserver.wms.WmsExceptionHandler.newServiceException(WmsExceptionHandler.java:65)
  at org.vfny.geoserver.servlets.AbstractService.sendError(AbstractService.java:865)
  at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:621)
  at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:315)
  at org.geoserver.request.Dispatcher.dispatch(Dispatcher.java:192)
  at org.geoserver.request.Dispatcher.handleRequestInternal(Dispatcher.java:52)
  at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:139)
  at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
  at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:684)
  at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:625)
  at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:392)
  at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:347)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
  at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
  at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
  at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
  at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
  at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
  at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
  at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.OutOfMemoryError: Java heap space
17.07.2007 10:07:16 org.vfny.geoserver.servlets.AbstractService sendError
<---------

I use
GeoServer 1.5.1
apache tomcat 5.5.23/jdk-1.5.0_12
OracleDatastore
GE WinXP / Kubuntu 7.04 (same behaviour on both platforms)
Network-Link : http://geoportal.rostock.de/geoserver_public/wms/kml_reflect?layers=hro:BAUSTELLE_AKT
(Rostock/Germany)

Greetings
Ronald

--
Ronald Woita
http://geoportal.rostock.de
Hansestadt Rostock
Kataster-, Vermessungs- und Liegenschaftsamt
Holbeinplatz 14, 18069 Rostock
email: ronald.woita@anonymised.com
phone: +49 (0)381 - 381 6256

<dlamoris@anonymised.com> 16.07.2007 20:18 >>>

Hi all,

I've been playing with geoserver and some test gps data, basically
plotting them on google earth. I'm using geoserver 1.5.1, postgres
8.2.4 and postgis 1.2.1.
I've noticed that the first time I open google earth, it takes a very
long time for the data to appear, but zooming in afterwards it was
faster. But the speed would still vary. I just noticed, using ps -e,
that I have about 45 postgres instances running. Is that normal (it's
stopped spawning)?

Also, in google earth when I tried to see the 'states' that came with
geoserver it shows a white overlay over the US instead of color coded.
The same thing happens when I try to overlay polygons, for example,
zip code outlines. If zoomed out it shows the outline correctly, but
zoomed in everything becomes white. Does someone know what's the cause
of this?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Ronald Woita ha scritto:

Hi,

i observed the same behaviour when GE starts.
It takes a long time to load the data for the first time.
After fully loading there are more than 600 sessions opened for GeoServer in Tomcat Manager. to compare : a GeoServer instance used as a WFS-Gazetteer and more than 500 Request per hour opens averagly 100 sessions.

Where session is the number of threads Tomcat is using to serve
up requests, or you mean the HTTP sessions used?
So GE is doing an incredible number of parallel requests?
Wondering why, maybe we are not setting up the KML the proper way,
or maybe we're just overloading poor GE with too many data...
any way we can involve someone from Google into this discussion?
Maybe you should report this to the GE user group too:
http://groups.google.com/group/earth-help

Cheers
Andrea

Andrea Aime wrote:

Ronald Woita ha scritto:

Hi,

i observed the same behaviour when GE starts.
It takes a long time to load the data for the first time.
After fully loading there are more than 600 sessions opened for GeoServer in Tomcat Manager. to compare : a GeoServer instance used as a WFS-Gazetteer and more than 500 Request per hour opens averagly 100 sessions.

Where session is the number of threads Tomcat is using to serve
up requests, or you mean the HTTP sessions used?
So GE is doing an incredible number of parallel requests?
Wondering why, maybe we are not setting up the KML the proper way,
or maybe we're just overloading poor GE with too many data...
any way we can involve someone from Google into this discussion?
Maybe you should report this to the GE user group too:
http://groups.google.com/group/earth-help

I have had this happen randomly where GE starts bombarding the server with requests... I am pretty sure its a GE bug.. Just recently I believe a user tried to track this down but I am not sure how far they got.

Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469c7cac255252090977483!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org