[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:  closed 
 Priority:  medium            |     Milestone:  2.3    
Component:  Resource Service  |       Version:  2.2.0  
 Severity:  critical          |    Resolution:  fixed  
 Keywords:  DBXML             |   External_id:  1381089
------------------------------+---------------------------------------------
Description changed by brucedechant:

Old description:

> 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.

New description:

 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#comment:3>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals