Firebird memory not released (Using superserver)
------------------------------------------------
Key: CORE-3533
URL: http://tracker.firebirdsql.org/browse/CORE-3533
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Windows 2003 Server 32 bits
Reporter: Jesus Angel Garcia Zarco
Priority: Critical
I'm using Firebird 2.5.1.26292 Superserver. The server is running for two weeks
and the memory consumption increase daily, but not decrease. I have tested in
other enviroment, and all the memory is freed only when all users are
disconnected. For know, using Process Explorer from sysinternals, 1326148K of
private bytes and 1145716K of Working set, but everyday is increasing between
50 and 100Kb.
After two weeks working, today i have started to have this problem (Operating
system call _beginthreadex failed. Error code 8), and i have read that is a
problem of memory with server that can not allocate more than 2 Gb. This is
because day by day the memory consumption increase, more and more.
If i disconnect all users, fbserver only uses 8 Mb RAM, all memory is released
right and start by a memory consumption low, between 200 and 300 Mb, but day by
day it increses the momory usage.
I have sent emails attached, with several selects from mon$*, but Alexander
Peshkov, can't help anymore because he work only with posix builds. This
database structure is used in Firebird 1.0 and Interbase 7-2009 for years
without problem.
I only use in my app one UDF and this is the code:
unit UDFMath;
interface
function UDF_power( var Base, Exponent: Double ): double; cdecl; export;
function UDF_sqrt( var Value: double ): double; cdecl; export;
implementation
uses Math;
function UDF_power(var Base, Exponent: Double): double; cdecl;
begin
try
Result := power( Base, Exponent );
except
Result := 0;
end;
end;
function UDF_sqrt( var Value: double ): double; cdecl;
begin
try
Result := sqrt( Value );
except
Result := 0;
end;
end;
initialization
IsMultiThread := True;
end.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
