[Geoserver-users] ArcSDE connection pooling issues

Bart_van_den_Eijnden · February 20, 2008, 3:49pm

Hi Gabriel,

the OL layers are WFS layers, so Untiled. There are only 3 layers (one for
points, polygons and lines) in the application, and using OpenLayers
(Layer.WFS) new features are added.

So we don't use WMS, only WFS in this case.

I have the default value for the connection timeout, I'll try increasing it.

Best regards,
Bart

--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl

--------- Oorspronkelijk bericht --------
Van: Gabriel Roldán <groldan@anonymised.com>
Naar: geoserver-users@lists.sourceforge.net
<geoserver-users@lists.sourceforge.net>, Bart van den Eijnden OSGIS
<bartvde@anonymised.com>
Cc: Saul Farber <Saul.Farber@anonymised.com>
Onderwerp: Re: [Geoserver-users] ArcSDE connection pooling issues
Datum: 20/02/08 13:41

Hi Bart,

My first thought is it may be a matter of balance bettween connection pool

size and pool's connTimeout argument. Did you try increasing the

connTimeout

parameter in the DataStore config?

question though: is the openlayers client requesting tiles? I've to admit

I

never tried a tiling client over arcsde layers myself, but it would make
sense to run out of connections depending on the ammount of tiles being
requested at a time and the ammount of layers composing the map.
Yet its though. I've been trying Saul's massgis WMS[1] through uDig before

replying to this message and it seems to perform well even requesting 20
layers at a time.

May be Saul (cc'ed) can give us a couple clues about how to set up a
production geoserver backed up by arcsde?

Saul: did you ever run into connection exhaustion issues with your server

and,

if so, how did you solved them? is it just a matter of having a ton of
available connections? and did you ever tried hitting it with a tiling
client?

cheers,

Gabriel

[1]Massgis WMS server:

<http://giswebservices.massgis.state.ma.us/geoserver/wms?service=WMS&request=GetCapabilities>

On Wednesday 20 February 2008 02:20:39 pm Bart van den Eijnden (OSGIS)

wrote:

> Hi list,
>
> we are running into connection pooling issues (using 1.6RC2), we now

have

> even increased the maximum number up to 25 (coming from 8), but still
> Geoserver runs out of connections after a while. There is only 1

client

> (OpenLayers based) active!
>
> What could be the issue?
>
> Caused by: java.util.NoSuchElementException: Could not aquire
> feature:org.geotools.data.DataSourceException: The maximun of 25 to
> org.geotools.arcsde.pool.ArcSDEConnectionConfig[dbtype=arcsde,
> server=geodatabase.ad.rws.nl, port=5151, instance=null, user=DID,
> password=*****, minConnections=2, maxConnections=25,

connTimeOut=1000] has

> been reached
>
> 2008-02-20 11:17:03,298 WARN
> [org.geotools.arcsde.pool.ArcSDEConnectionPool] - Out of connections:
> Timeout waiting for idle object
> java.util.NoSuchElementException: Timeout waiting for idle object
> at
>

org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPo

>ol.java(Compiled Code))
> at
>

org.geotools.arcsde.pool.ArcSDEConnectionPool.getConnection(ArcSDEConnectio

>nPool.java(Compiled Code))
> at
>

org.geotools.arcsde.data.ArcSDEDataStore.getFeatureWriterAppend(ArcSDEDataS

>tore.java:963) at
>

org.geotools.data.AbstractFeatureStore.addFeatures(AbstractFeatureStore.jav

>a:249) at
>

org.vfny.geoserver.global.GeoServerFeatureStore.addFeatures(GeoServerFeatur

>eStore.java:76) at
>

org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:16

>4) at org.geoserver.wfs.Transaction.execute(Transaction.java:328) at
> org.geoserver.wfs.Transaction.transaction(Transaction.java:104) at
>

org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureSer

>vice.java:156) at

sun.reflect.GeneratedMethodAccessor203.invoke(Unknown

> Source) at
>

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp

>l.java(Compiled Code))
> at java.lang.reflect.Method.invoke(Method.java(Compiled

Code))

> at
>

org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(Aop

>Utils.java:292) at
>

org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoin

>t(ReflectiveMethodInvocation.java:155) at
>

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec

>tiveMethodInvocation.java:122) at
> org.geoserver.wfs.WFSLogger.invoke(WFSLogger.java:44)
> at
>

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec

>tiveMethodInvocation.java:144) at
>

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPr

>oxy.java:174) at $Proxy0.transaction(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown

Source)

> at
>

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp

>l.java(Compiled Code))
> at java.lang.reflect.Method.invoke(Method.java(Compiled

Code))

> at
>

org.geoserver.security.OperationSecurityInterceptor.invoke(OperationSecurit

>yInterceptor.java:41) at
> org.geoserver.ows.Dispatcher.execute(Dispatcher.java:495) at
>

org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:188)

> at
>

org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstra

>ctController.java:139) at
>

org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(S

>impleControllerHandlerAdapter.java:44) at
>

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServ

>let.java:684) at
>

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServl

>et.java:625) at
>

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkSe

>rvlet.java:392) at
>

org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.ja

>va:357) at

javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at

> javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled

Code))

> at
>

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio

>nFilterChain.java(Compiled Code))
> at
>

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC

>hain.java(Compiled Code))
> at
>

org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacter

>EncodingFilter.java:108) at
>

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicatio

>nFilterChain.java(Compiled Code))
> at
>

org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterC

>hain.java(Compiled Code))
> at
>