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: [email protected] [mailto:[email protected]]
Gesendet: Freitag, 29. Mai 2015 12:03
An: [email protected]
Betreff: AW: [firebird-support] Re: Memory usage excess / leak in FBServer 2.5.4
> ---In [email protected], <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
