Hi Gabriel,
The database is SQL Server 2k5 with ArcSDE 9.2.
I'm using Selenium to do the load test which is quite complicated to setup outside of our environment.
However, I've created a quick JMeter test to simulate same kind of load on Geoserver.
The test is simple, it just ask for the same WMS request over and over again (without caching).
It looks like some of the gsvr processes become orphan at some point. With a max conn set to 1, the # of conn at the end of the test is around 4. With a max of 5 conns, 10 processes and so on....
You'll have to change the Servicer Name from the HTTP Request page and might need to crank the number of threads in the Jmeter test (see Thread Group from the Test Plan) depending on your setup.
I've ran the SDE plugin with the version 9.2 and 9.3 of the ESRI jars with the same result.
Also, if I stop Geoserver the gsvr processes disappear and if I re-save the ArcSDE datastore, the number of process go back to 1.
With the above behavior it let me think that the connection pool is not releasing connection properly but if it was the case we should get a connection pool exhausted and shouldn't create more process...
Let me know if you need anything else. I look forward to solve this issue as it is a show stopper for our project.
Thanks for your help
Mathieu
-----Original Message-----
From: Gabriel Roldan [mailto:groldan@…13…] On Behalf Of Gabriel Roldán
Sent: Monday, January 24, 2011 9:19 PM
To: Mathieu Lavoie
Cc: geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] Connection pool for ArcSDE store
Hi Mathieu,
it's not a known problem, sorry to hear that.
What is the backend database?
Could you explain how you're running the load test? if it's some kind of
script that's easy to run it'd be great if you can share it so I can
reproduce the issue more easily and see what's going wrong.
In the past I conducted several load and stress tests but I don't have
those scripts at hand right now. I'll be glad to look into it as it
sounds as a really bad thing that shouldn't be happening.
Best regards,
Gabriel
On Mon, 2011-01-24 at 19:36 -0800, Mathieu Lavoie wrote:
Hi,
I'm using Geoserver 2.0.2 with the ArcDE plugin. I've created a data
store to ArcSDE with the following configuration:
Initial conn: 1
Max conn: 5
I'm using ArcSDE 9.2
If I run a load test against Geoserver (WMS and WFS calls) I end up
with the following error: Error: Maximum number of connections to
instance esri_sde exceeded (-7). The test result are really bad as
most of the requests cannot be served.
Geoserver is the only app connected to ArcSDE. If I look at the task
manager under the database, I can see more than 5 gsrvr processes
running on the SDE server (up to 48, which is the max conn for SDE).
I would expect to see no more than 5 processes as the max conn is 5.
It looks like some of the processes are orphan and therefore can't be
reused forcing Geoserver to create a new process.
If I set initial conn and max conn at 1, the load test is just fine
even if I end up with 4 gsrvr processes at the end.
It looks like something isn't just right with SDE. Is this already a
known problem?
As far as I remember, ArcIMS had the same problem and ESRI suggest to
restart ArcSDE every week to fix the problem. Under load (say 50
concurrent users) I'm running out of connection in 10 min so
restarting ArcSDE every week does not appear to be a solution….
This is a bit annoying as I cannot take advantage of the pooling
mechanism provided in the ArcSDE plugin.
Thanks,
Mathieu Lavoie
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel
--
Gabriel Roldan
groldan@...1501...
Expert service straight from the developers
(attachments)
geoserver_simple_test.jmx (10.5 KB)