Do you HAVE a memory problem? Or are you upset about Firebird using this amount of RAM?

 

Hello,
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
MON$STAT_ID 1
MON$STAT_GROUP 0
MON$MEMORY_USED 3329950624
MON$MEMORY_ALLOCATED 3870920704
MON$MAX_MEMORY_USED 3331189248
MON$MAX_MEMORY_ALLOCATED 3870990336
ATTACHMENTS 1
STATEMENTS 1

Any hints how to investigate this problem?
Thank you.

--
joja

Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Freitag, 29. Mai 2015 12:03
An: firebird-support@yahoogroups.com
Betreff: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4

> ---In firebird-support@yahoogroups.com, <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:
MON$STAT_ID 1
MON$STAT_GROUP 0
MON$MEMORY_USED 145842736
MON$MEMORY_ALLOCATED 152465408
MON$MAX_MEMORY_USED 147606936
MON$MAX_MEMORY_ALLOCATED 154570752

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

No

--
Joja