Icon View Incident Report

Serious Serious
Reported By: Peter Moser
Reported On: 6/23/2008
For: Version 2.00 Build 2
# 2687 Engine Accumulating Memory During Session Opens

On our webserver I can watch edbsrvr.exe eating memory in the Taskmanager. It looks like our apps are allocating memory in edbsrvr.exe and are not freeing it.

The setting:
Software: Delphi 7 - CGI - Webmodules with ElevateDB 1.09 C/S
IIS 6 on Windows Server 2003 R2 Servicepack 1
edbsrvr.exe as service on another Windows Server 2003 R2 Servicepack 1
We are textindexing three CLOB columns - using Roy Lambert's very fine wordgenerator Version 2.

The CGI Applications and queries are ported from DBISAM 4 and worked fine there. Again: it is not about memory holes in the CGI Application: it is edbsrvr.exe eating memory.

The Code in BeforeDispatch:

  EDBdatenbank.connected:=false;
  EDBsession.connected:=false;
  EDBsession.SessionType:=edbcomps.stRemote;
  EDBsession.LoginUser:=inifile.readstring('EDBRemote','user','');
  EDBsession.LoginPassword:=inifile.readstring('EDBRemote','passwort','');
  EDBsession.RemoteAddress:=inifile.readstring('EDBRemote','IP','');
  EDBsession.RemotePort:=inifile.ReadInteger('EDBremote','port',12005);
  EDBsession.RemoteCompression:=inifile.ReadInteger('EDBremote','compression',0);
  EDBdatenbank.database:=inifile.readstring('EDBRemote','datenbank','');

The code in afterDispatch:

  EDBDatenbank.Close;
  EDBDatenbank.connected:=false;
  EDBSession.DropConnections;
  EDBsession.Connected:=false;
  EDBsession.close;
  EDBEngine.Close;



Comments Comments
This issue affected all server and local sessions, and was caused by the internal lock and catalog manager files for each session's configuration being allocated but not destroyed until the process was terminated. It wasn't technically a memory leak because the memory was eventually freed, but the end result was the same - runaway memory consumption when the number of session connections and disconnections were rapid and frequent.


Resolution Resolution
Fixed Problem on 6/25/2008 in version 2.01 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image