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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
