View Incident Report

Serious

Reported By: Bernd Kuhlmann
Reported On: 9/25/2002
For: Version 3.16 Build 1

# 1214 Trying to Open a Table That Does Not Exist Causes a Small Memory Leak

Every time You try to open a table that does not exist, the server uses 10-20KB additional memory (shown in srvadmin.exe). The main problem is that this memory is not freed, when the client is closed. We used the code below to test if a table can be opened and after two weeks the server used around 400MB.

var tableOK: Boolean;    
begin    
  table1.tablename:='ABC';    
  try    
    table1.open    
    tableOK:=true;    
  except    
    on e: exception do tableOK:=false;   
  end;   
end;   
 
Workaround: 
var tableOK: Boolean;    
begin    
  table1.tablename:='ABC';    
  try    
    if table1.exists then begin 
      table1.open    
      tableOK:=true;    
    end else begin 
      tableOK:=false;    
    end; 
  except    
    on e: exception do tableOK:=false;   
  end;   
end;

Resolution

Fixed Problem on 10/10/2002 in version 3.18 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap