|Subject||AW: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4|
> Do you HAVE a memory problem? Or are you upset about Firebird using this amount of RAM?In my opinion FB is leaking memory. Initially the fbserver.exe has about 150MB and it it's all my memory over time. First time till ~20GB and finally the server went out of service. Now I try to restart every couple of days to avoid driving into the wall.
On 03/06/2015 09:48, 'Jojakim Stahl' joja.lists@... [firebird-support] wrote:
still no solution. Running since last Friday, fbserver.exe grew up to +3GB memory so far. Few minutes ago, I stopped all our services, it remained only one attachment from isql to select mon$memory_usage: memory did not went down. IMHO, this memory leak is not caused by a client leaving open something, otherwise the memory should go down when the connection is closed, shouldn't it?
SQL> select cast('NOW' as timestamp) TS, m.*, (select count(*) from mon$attachme
nts) ATTACHMENTS, (select count(*) from mon$statements) STATEMENTS from mon$memo
ry_usage m where m.mon$stat_group=0;
TS 2015-06-03 14:04:02.3910
Any hints how to investigate this problem?
Von: firstname.lastname@example.org [mailto:email@example.com]
Gesendet: Freitag, 29. Mai 2015 12:03
Betreff: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
> ---In firstname.lastname@example.org, <joja.lists@...> wrote :
> I'm facing a problem where the firebird server v2.5.4 on win 2012 server in superserver mode is leaking > memory. Currently I'm at ~5GB usage.
I just restarted our services: FB memory usage went down to normal values:
>1. Show us results of
>select count(*) form mon$attachments
Before restart: 11
After restart: 11
>select count(*) form mon$transactions
Before restart: 0
After restart: 3
>select count(*) form mon$statements
Before restart: 84
After restart: 122
>2. Do you use any custom UDF's ?