[mapguide-internals] Session repository lock under multi-threaded update

Trevor Wekel trevor_wekel at otxsystems.com
Wed Jan 5 17:48:03 EST 2011


Ok.  Thanks Bruce, Thanks Andreas.

Would this also apply to DBXML 2.3.10 used in MGE 2011 and MGOS 2.2, or is it strictly DBXML 2.5.16 related?

Regards,
Trevor

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Bruce Dechant
Sent: January 5, 2011 3:45 PM
To: MapGuide Internals Mail List
Subject: RE: [mapguide-internals] Session repository lock under multi-threaded update

The problem is that DBXML 2.5.16 always uses a transaction when doing dbxml operations.
Our resource service was for some operations not creating a transaction and this in turn caused dbxml to create one internally - this can be problematic and may have caused the lockups you are seeing. I remember seeing this while doing the dbxml upgrade. I changed the resource service code to follow the dbxml guidelines to always use a transaction for all dbxml operations. With this change the lockups went away. I tested with between 20 and 100 concurrent user loads over the weekend (48+ hours) and there were no lockups and with the new session repository strategy I didn't see any DB_BUSY errors either.

Thanks,
Bruce

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Andreas Morf
Sent: Wednesday, January 05, 2011 3:11 PM
To: 'MapGuide Internals Mail List'
Subject: RE: [mapguide-internals] Session repository lock under multi-threaded update

Trevor,
I saw this many times when I was upgrading to dbxml 2.5.16 which is
especially more sensitive when being called by an untransacted
dbxml-API-operation. After eliminating these in MgResourceService there are
DB_BUSY errors sometimes which I was able to handle in my JAVA Webapi code -
but in my opinion, this could/should be handled by MgResourceService in a
better way...

Andreas

-----Ursprüngliche Nachricht-----
Von: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] Im Auftrag von Trevor
Wekel
Gesendet: Mittwoch, 5. Januar 2011 22:19
An: MapGuide Internals Mail List
Betreff: [mapguide-internals] Session repository lock under multi-threaded
update

Hello,

Has anyone experienced session repository lockup when executing 4+
concurrent calls to SetResource using different session ids?  The
SetResource call is creating new resources and not updating old resources.

Thanks,
Trevor



_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals




More information about the mapguide-internals mailing list