Hello GeoServer community,
I've spent quite some time (all of last week) investigating a performance
problem regarding our mapping application built on top of GeoServer /
OpenLayers.
The memory consumption grew as time went by and never recovered / declined
anymore to the point where the operating system began to swap which resulted
in a really poor performance.
The log entry 'rendering takes >60 sec, aborting..' came up in shorter
intervals and at some point the server just didn't respond anymore.
To find the reason for that I've used different servers (Tomcat / WebLogic)
and even different JVMs (HotSpot / JRockit).
A heap dump didn't really show anything extraordinary, but looking at some
other data the native memory part was suspicious.
As it turns out the culprit seems to be the OCI drivers (or their usage).
The problem can be observed by using the built-in Layer Preview feature
(just moving around the map - panning / zooming in and out is sufficient).
As soon as I switch to Thin-Driver the application performs better and the
memory stays within some sensible boundaries (after some initial climbing).
Since the usage of OCI is mandatory for our customer the Thin-Driver option
is unfortunately not possible.
I guess Oracle is not the preferred database in the GeoServer community and
OCI is even less used to access it but has anyone some experience in dealing
with such a situation nontheless?
Should I create a ticket for that?
Thanks for any input in advance,
Daniel
==============================================================================
Datasource settings (OCI):
Connection timeout: 20
validate connections: true
max connections: 10
Primary key metadata table: geo_pk_metadata
Loose bbox: true
Expose primary keys: true
Max open prepared statements: 100
fetch size: 1000
Estimated extends: true
min connections: 1
==============================================================================
Environment:
GeoServer: 2.5 final
App-Server / Servlet container: WebLogic 10.3.2 (it behaves the same on
Tomcat 6)
OS: Red Hat Enterprise Linux Server release 5.4 (Tikanga)
Database: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 -
64bit
Production
JVM:
Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
BEA JRockit(R) (build
R27.6.5-32_o-121899-1.6.0_14-20091001-2113-linux-ia32, compiled mode)
Java settings: -Xmx1024m -Xms1024m
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Suspected-memory-leak-when-using-Oracle-OCI-drivers-tp5133570.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Put Bad Developers to Shame
Dominate Development with Jenkins Continuous Integration
Continuously Automate Build, Test & Deployment
Start a new project now. Try Jenkins in the cloud.
http://p.sf.net/sfu/13600_Cloudbees_APR
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
