AW: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
Hello Carlos, Selecting mon$transactions multiple times shows every time different transactions. So no long running transaction active, but memory consumption is growing at a rate of ~30MB/hour. -- Joja Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 29. Mai 2015 13:35 An: 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] Betreff: Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4 Is there any chance that you are manipulating blobs variables inside procedures/triggers and the associated transaction is being left open? Blob variable content (in memory) is static, meaning that each time you change the content of a blob variable, even a single byte change, Firebird will allocate new memory to store the whole blob content, so lots of memory can be consumed. The allocated memory is released only when the transaction commits. []s Carlos H. Cantu <http://www.FireBase.com.br> www.FireBase.com.br - <http://www.firebirdnews.org> www.firebirdnews.org <http://www.warmboot.com.br> www.warmboot.com.br - blog.firebase.com.br 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_ALLOCATED5314478080 MON$MAX_MEMORY_USED 4570448304 MON$MAX_MEMORY_ALLOCATED5314678784 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_TRANSACTION35187662 MON$PAGE_BUFFERS16384 MON$SQL_DIALECT 3 MON$SHUTDOWN_MODE 0 MON$SWEEP_INTERVAL 2 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_STATE0 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
Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
AW: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
Hello, I did two snapshots which I’ll send you soon. For the public, here is the current state of memory usage: MON$STAT_ID 1 MON$STAT_GROUP 0 MON$MEMORY_USED 5138925728 MON$MEMORY_ALLOCATED5976719360 MON$MAX_MEMORY_USED 5139664848 MON$MAX_MEMORY_ALLOCATED5978824704 Compared to yesterday, MON$MEMORY_ALLOCATED growed by 662241280 which is about __631MB__! -- joja >Can you please do the following - download FBMonLogger trial from >http://ib-aid.com/en/fbmonlogger/ >install it, run it, connect to the database and make snapshot of MON$. >MON$STAT_ID 1 >MON$STAT_GROUP 0 >MON$MEMORY_USED 4570256632 >MON$MEMORY_ALLOCATED5314478080 >MON$MAX_MEMORY_USED 4570448304 >MON$MAX_MEMORY_ALLOCATED5314678784
AW: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
>Did you look de settings in firebird.conf? DefaultDbCachePages for example... The firebird.conf file has not been modified, it's a blank standard firebird installation. The setting DefaultDbCachePages=2048 is commented out. >On 28/05/2015 10:24, 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] >wrote: > >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.
Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
Hello. Did you look de settings in firebird.conf? DefaultDbCachePages for example... On 28/05/2015 10:24, 'Jojakim Stahl' joja.li...@jojakim.de [firebird-support] wrote: 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 2 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 -- Atenciosamente, Hugo Eyng
Re: [firebird-support] Memory usage excess / leak in FBServer 2.5.4
Hi Jojakim, Can you please do the following - download FBMonLogger trial from http://ib-aid.com/en/fbmonlogger/ install it, run it, connect to the database and make snapshot of MON$. It will grab all information from MON$ tables and store it to the disk (you will be requested to select folder at the first step). Then please zip it and send to supp...@ib-aid.com for the investigation. Regards, Alexey Kovyazin IBSurgeon 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 2 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
[firebird-support] Memory usage excess / leak in FBServer 2.5.4
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_ALLOCATED5314478080 MON$MAX_MEMORY_USED 4570448304 MON$MAX_MEMORY_ALLOCATED5314678784 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_TRANSACTION35187662 MON$PAGE_BUFFERS16384 MON$SQL_DIALECT 3 MON$SHUTDOWN_MODE 0 MON$SWEEP_INTERVAL 2 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_STATE0 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