Hello,


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.


Don't have any idea how to track down the problem.
Thanks for any advice.


--
joja


select * from mon$memory_usage where mon$stat_group=0;


MON$STAT_ID 1
MON$STAT_GROUP 0
MON$MEMORY_USED 4570256632
MON$MEMORY_ALLOCATED 5314478080
MON$MAX_MEMORY_USED 4570448304
MON$MAX_MEMORY_ALLOCATED 5314678784


select * from mon$database;


MON$DATABASE_NAME D:\P2_DB\FIREBIRD\DBA9627.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 11
MON$ODS_MINOR 2
MON$OLDEST_TRANSACTION 35186254
MON$OLDEST_ACTIVE 35186255
MON$OLDEST_SNAPSHOT 35186255
MON$NEXT_TRANSACTION 35187662
MON$PAGE_BUFFERS 16384
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 20000
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2015-04-15 08:58:37.1050
MON$PAGES 250031
MON$STAT_ID 1
MON$BACKUP_STATE 0


show version;
ISQL Version: WI-V2.5.4.26856 Firebird 2.5
Server version:
Firebird/x86-64/Windows NT (access method), version "WI-V2.5.4.26856
Firebird 2.5"
Firebird/x86-64/Windows NT (remote server), version "WI-V2.5.4.26856
Firebird 2.5/tcp (SV-W12-L900)/P12"
Firebird/x86-64/Windows NT (remote interface), version "WI-V2.5.4.26856
Firebird 2.5/tcp (SV-W12-L900)/P12"
on disk structure version 11.2