[mapguide-trac] #1687: A DBXML exception happens under stress test

[MapGuide Open Source]

#1687: A DBXML exception happens under stress test
--------------------------------+-------------------------------------------
   Reporter:  hubu              |       Owner:  hubu 
       Type:  defect            |      Status:  new  
   Priority:  medium            |   Milestone:  2.3  
  Component:  Resource Service  |     Version:  2.2.0
   Severity:  critical          |    Keywords:  DBXML
External_id:  1381089           |  
--------------------------------+-------------------------------------------
 After create about 150 sessions, MgServer can’t create session anymore.
 And we will get many errors like below:
                 Error: An exception occurred in DB XML component.
         Error: DB_RUNRECOVERY: Fatal error, run database recovery
 StackTrace:
   - MgSiteServiceHandler.ProcessOperation() line 83 file
 SiteServiceHandler.cpp
   - MgOpCreateSession.Execute() line 109 file OpCreateSession.cpp
   - MgServerSiteService.CreateSession() line 762 file
 ServerSiteService.cpp
   - MgServerResourceService.CreateRepository() line 541 file
 ServerResourceService.cpp
   - MgSessionRepository.MgSessionRepository() line 76 file
 SessionRepository.cpp

 This is a regression since we implemented "File-per-Session". After create
 150 sessions, the DBxml is locked(hang up), because it can’t allocate
 memory anymore.

 We need to tune DBXML configuration, reduce the log buffer and cache size
 for session repository.

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