[mapguide-trac] #323: Perpetual spatial queries drain Autodesk.SqlServer FDO provider connection pool: .NET API

[MapGuide Open Source]

#323: Perpetual spatial queries drain Autodesk.SqlServer FDO provider connection
pool: .NET API
-------------------------------+--------------------------------------------
   Reporter:  MaksimS          |       Owner:       
       Type:  defect           |      Status:  new  
   Priority:  medium           |   Milestone:       
  Component:  Feature Service  |     Version:  1.2.0
   Severity:  major            |    Keywords:       
External_id:                   |  
-------------------------------+--------------------------------------------
 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.

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/323>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals