Please create a ticket, with whatever details you have.
There is no real developer community priority a preferred datastore. Comes
down to what volunteers are willing to work on (or what customers are
willing to pay for). In this case having a bug report to point to is a
good way to start the conversation.
So you are thinking the memory link is in the native code - and thus not
something that shows up in a memory profiler?
--
Jody
Jody Garnett
On Mon, Apr 7, 2014 at 11:11 PM, daniel.soneira
<daniel.sone...@joyn-it.at>wrote:
> 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
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
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
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
