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

[Jason Birch]

Does the below sound familiar to anyone?  Seems as if something isn't getting closed/dereferenced properly.

I remember a discussion about the old MgMap->Open() causing problems, but I can't find the ticket...

Jason
________________________________________
From: GreenMapSanMiguel
Sent: Saturday, July 18, 2009 6:09 PM
To: [hidden email]
Subject: Re: [mapguide-users] MapGuide runs out of FDO connections under        Fusion MGOS 2.1 Beta

I've been stepping through code and think I have isolated the problem.  At
this point I'm assuming that both of my issues (layers becoming permenantly
busy and running out of FDO connections) are related.

The issues occur after use of setSelection, which uses both
SaveSelection.php and GetSelectionProperties.php.  Both of these create a
feature service then call GetExtents.  Here's a sample from
SaveSelection.php:

                $featureService =
$siteConnection->CreateService(MgServiceType::FeatureService);
                $oExtents = $selection->GetExtents($featureService);

Creation of $featureService doesn't seem cause a problem, but as soon as
$oExtents is created the layer becomes busy and stays busy until the
MapGuide server is restarted.

Can anyone suggest where to go from here?  Perhaps the feature service needs
to be closed/destroyed somehow after use?

My undying gratitude to whoever can help me with this show-stopper,_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

[GreenMapSanMiguel]

I just tested with the interim build and the problem of SDF FDO connections not being released still occurs.  With a pool size of 200, the MapGuide server hangs after 100 setSelections and must be restarted.  (Each setSelection ties up one connection during execution of SaveSelection.php and another during execution of GetSelectionProperties.php)  This is 100 total setSelections since startup, not 100 per user.  It doesn't take many users or much activity to bring down the server.

This is a severe problem that prevents Fusion applications from being deployed.  Is there an 'official' way I should be reporting it?

Thanks

Andy

[Jason Birch]

Andy,

The interim build still has old fusion code; have you tried the latest commits against this ticket?  There were a couple more ->close statements that weren't quite right.

http://trac.osgeo.org/fusion/ticket/229

Also, are you using connection pooling?  I've never turned this on for SDF.  If so, can you try without and see if it makes a difference?

The best way to get this fixed is to provide a simple-as-possible test case (preferably attached to a Trac ticket) that would allow a developer to install and duplicate the problem within a few minutes.

I still think I remember seeing something where the old mechanism for creating selections caused leaks in .Net where the new method (based on map name) did not, but can't for the life of me find any reference to this.

Jason

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of GreenMapSanMiguel
Sent: Monday, July 27, 2009 10:38 AM
To: [hidden email]
Subject: Re: [mapguide-internals] FW: [mapguide-users] MapGuide runs out of FDO connections under Fusion MGOS 2.1 Beta


I just tested with the interim build and the problem of SDF FDO connections
not being released still occurs.  With a pool size of 200, the MapGuide
server hangs after 100 setSelections and must be restarted.  (Each
setSelection ties up one connection during execution of SaveSelection.php
and another during execution of GetSelectionProperties.php)  This is 100
total setSelections since startup, not 100 per user.  It doesn't take many
users or much activity to bring down the server.

This is a severe problem that prevents Fusion applications from being
deployed.  Is there an 'official' way I should be reporting it?

Thanks

Andy


--
View this message in context: http://n2.nabble.com/FW%3A--mapguide-users--MapGuide-runs-out-of-FDO-connections-under-Fusion-MGOS-2.1-Beta-tp3287689p3335288.html
Sent from the MapGuide Internals mailing list archive at Nabble.com.
_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals
_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

[GreenMapSanMiguel]

Hi Jason,

I did try with the latest commits for ticket 229 and it didn't make a difference.  I have tried altering every parameter related to connections without having any luck.  MapGuide hangs whether or not SDF is in the pool.  If I assign a number of connections to SDF, the MapGuide server will hang after half that number of setSelections.  Frequently checking for and timing out idle connections doesn't help either.

The problem seems to be internal to MapGuide but I do basically the same thing (select and zoom to features) in the AJAX version of my application and it works fine.  The AJAX version uses different commands from Fusion to accomplish this so perhaps it does have to do with the way the selections are created.

What do I need to include in a test case?  I think anyone could reproduce this by selecting and zooming to results from the search widget 100 times with a default pool size of 200.

Thanks very much for your help!

Andy

[Jason Birch]

I'm really hoping that someone has time to look at this issue.  It's fairly easy to replicate (see ticket below) and is a huge problem for anyone wanting to go to the current 2.1 stuff...  I wonder if this was somehow introduced (or if an existing flaw became easier to run into) with the new connection handling stuff?

http://trac.osgeo.org/mapguide/ticket/1051

Jason

-----Original Message-----
From: GreenMapSanMiguel
Sent: Monday, July 27, 2009 1:26 PM
To: [hidden email]
Subject: RE: [mapguide-internals] FW: [mapguide-users] MapGuide runs out of FDO connections under Fusion MGOS 2.1 Beta

The problem seems to be internal to MapGuide but I do basically the same
thing (select and zoom to features) in the AJAX version of my application
and it works fine.  The AJAX version uses different commands from Fusion to
accomplish this so perhaps it does have to do with the way the selections
are created.
_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

[Trevor Wekel]

Hi Jason,

One quick test to perform would be to use the HTML test pages to check the status of the Fdo connection cache.  In use connections could indicate bad cleanup on a feature reader somewhere.  Hitting FeatureService... GetFdoCacheInfo... should display information on the open connections.

Thanks,
Trevor

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Jason Birch
Sent: Monday, July 27, 2009 5:28 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] FW: [mapguide-users] MapGuide runs out of FDO connections under Fusion MGOS 2.1 Beta
Importance: High

I'm really hoping that someone has time to look at this issue.  It's fairly easy to replicate (see ticket below) and is a huge problem for anyone wanting to go to the current 2.1 stuff...  I wonder if this was somehow introduced (or if an existing flaw became easier to run into) with the new connection handling stuff?

http://trac.osgeo.org/mapguide/ticket/1051

Jason

-----Original Message-----
From: GreenMapSanMiguel
Sent: Monday, July 27, 2009 1:26 PM
To: [hidden email]
Subject: RE: [mapguide-internals] FW: [mapguide-users] MapGuide runs out of FDO connections under Fusion MGOS 2.1 Beta

The problem seems to be internal to MapGuide but I do basically the same
thing (select and zoom to features) in the AJAX version of my application
and it works fine.  The AJAX version uses different commands from Fusion to
accomplish this so perhaps it does have to do with the way the selections
are created.
_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals


_______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals

[Jason Birch]

Hi Trevor,

Yep...

Every time I do a selection, the connection number goes up by one, and each one remains open and active.  None of the other SDF layers on my map ever show up on this page, regardless of how quickly I refresh it.

Same test using exact same application and version of fusion against a 2.0.x server, and SDF excluded from the pooled providers, and no connections show up at all.

Jason

________________________________________
From: Trevor Wekel
Sent: Monday, July 27, 2009 4:43 PM
Subject: RE: [mapguide-internals] FW: [mapguide-users] MapGuide runs out of     FDO connections under Fusion MGOS 2.1 Beta

One quick test to perform would be to use the HTML test pages to check the status of the Fdo connection cache.  In use connections could indicate bad cleanup on a feature reader somewhere.  Hitting FeatureService... GetFdoCacheInfo... should display information on the open connections._______________________________________________
mapguide-internals mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-internals