Perpetual spatial queries drain Autodesk.SqlServer FDO provider connection pool: .NET API

[MaksimS]

MapGuide Enterprise 2008 / Microsoft SQL Server 2005 / Windows 2003 Server

Issuing perpetual calls to managed FeatureService.SelectFeatures using spatial query causes MapGuide to drain Autodesk.SqlServer FDO provider connection pool. Exception being thrown:

OSGeo.MapGuide.MgApplicationException: Cannot create any more connections to the Autodesk.SqlServer FDO provider.
- MgFeatureServiceHandler.ProcessOperation line 83 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\FeatureServiceHandler.cpp
- MgOpSelectFeatures.Execute line 112 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\OpSelectFeatures.cpp
- MgServerSelectFeatures.SelectFeatures line 243 file c:\build_bond_area\bond_nightly\build_41.3\ent\os\server\src\services\feature\ServerSelectFeatures.cpp
- MgFdoConnectionManager.Open line 256 file c:\build_bond_area\Bond_Nightly\BUILD_41.3\Ent\OS\Server\src\Common\Manager\FdoConnectionManager.cpp

Spatial query calls are running on the same MapGuide session. It seems that MapGuide opens a new SQL Server session on each spatial query and keeps it open for a while, long enough to fill the session pool.

[zspitzer]

Are you closing your queries?

[MaksimS]

Yes, closing - then disposing resulting FeatureReader. Although it shouldn't matter now I guess, due to the recent changes making a Close part of IDisposable implementation. Now awaiting for the patch/hotfix for MGE 2009 to see if things changed for better.

[MaksimS]

Here's related ticket: ​http://trac.osgeo.org/fdo/ticket/284

[tomfukushima]

Could you test to see if this is resolved in MGOS 2.0.1? Thanks, Tom

[MaksimS]

Since it's Autodesk.SqlServer provider (MGE), I need to wait for Autodesk to issue a patch/hotfix to include 2.0.1 (I don't know whether MGOS 2.0.1 includes that specific FDO core Close/Dispose fix too?). Anyway, I elevated the issue with MGE 2009 patch (MGOS 2.0.1) via ADN channel, hopingly Autodesk will respond before MGE 2010 gets released :-)

[tomfukushima]

As this is Autodesk MapGuide Enterprise, I am closing this ticket as it should be handled by Autodesk. If the problem occurs with open source components please open a new ticket. Thanks, Tom.

[MaksimS]

Tom, Ticket #533 seems to be related to this issue: ​Connection exhaustion problem with SDF connection pooling disabled