[mapguide-users] MapGuide runs out of FDO connections under Fusion MGOS 2.1 Beta

[GreenMapSanMiguel]

I have a beautiful Fusion application that I would like to put in production,
but it is crashing my MapGuide server.  I am running out of FDO connections
once the total number of items that have been selected (across all sessions)
from a search result list reaches about 100.  The only solution seems to be
restarting the MapGuide server.  

Here's the error-log entry:
<2009-07-18T12:58:34> 	3704	Fusion Viewer	127.0.0.1	Anonymous
 Error: Cannot create any more connections to the OSGeo.SDF FDO provider.
 StackTrace:
  - MgFeatureServiceHandler.ProcessOperation() line 83 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHandler.cpp
  - MgOpSelectFeaturesSpatial.Execute() line 110 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpSelectFeaturesSpatial.cpp
  - MgServerSelectFeatures.SelectFeatures() line 246 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerSelectFeatures.cpp
  - MgFdoConnectionManager.Open() line 259 file
c:\osgeo\mapguide_21\mgdev\server\src\common\manager\FdoConnectionManager.cpp	

I can see in the access log that there is a CloseFeatureReader for every
GetFeatures, so I don't think this is a problem.  Here are the commands that
show 'failure':
<2009-07-18T12:59:39> 	3708	Fusion Viewer	127.0.0.1	Anonymous
SelectFeatures.1.0.0:3(Library://SMAmap/SMA/Data/Roads.FeatureSource,Default:Roads,MgFeatureQueryOptions)
Failure
<2009-07-18T12:59:41> 	3720	Fusion Viewer	127.0.0.1	Anonymous
QueryFeatures.1.0.0:7(Session:0acc12ca-55f2-102c-8000-0013e857853f_en_7F0000010AFC0AFB0AFA//GreenMap4a620c8152763.Map,MgStringCollection,MgGeometry,4,,1,5)
Failure

I know I could increase the number of FDO connections in serverconfig.ini
but think that will just delay the crash.  Can anyone tell me how FDO
connections are supposed to be released?  I'm over my head here so I'd
really appreciate anyone's help on where to start debugging or what
additional information to gather.

Thank you!

Andy








-- 
View this message in context: http://n2.nabble.com/MapGuide-runs-out-of-FDO-connections-under-Fusion-MGOS-2.1-Beta-tp3281668p3281668.html
Sent from the MapGuide Users mailing list archive at Nabble.com.