Do you have several Firebird installations(instances) in the same machine?Perhaps firebird is reading a different firebird.conf. Why don't you post your complete firebird.conf?
On Wednesday, May 23, 2018, 9:29:30 AM CDT, Fabiano Bonin fabiano.bo...@personalsoft.com.br [firebird-support] <firebird-support@yahoogroups.com> wrote: Hi, Thomas. It is zero. I presume in this case it uses the system default, right? Regards, Fabiano Database header page information: Flags 0 Generation 62390727 System Change Number 0 Page size 4096 ODS version 12.0 Oldest transaction 905 Oldest active 62303005 Oldest snapshot 62303005 Next transaction 62382577 Sequence number 0 Next attachment ID 1290314 Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc Shadow count 0 Page buffers 0 Next header page 0 Database dialect 3 Creation date Apr 4, 2018 7:03:44 Attributes force write 2018-05-22 18:30 GMT-03:00 'Thomas Kragh-Pedersen (TKG)' t...@kmd.dk [firebird-support] <firebird-support@yahoogroups.com>: Hey Fabiano PerhapsDefaultDbCachePages is overwritten by database header information. Gstat -h will tell you that. Look for “Page buffers” From: firebird-support@yahoogroups. com <firebird-support@yahoogroups. com> Sent: 18. maj 2018 16:12 To: firebird-support@yahoogroups. com Subject: [firebird-support] Firebird using all available memory Hi, I have a Debian 9 Linux server with 8GB of memory, a database with 30GB, page size 4KB, and Firebird 3.0.3 running in superserver mode and about 150-200 concurrent connections. In my firebird.conf I have changed the following properties: DefaultDbCachePages = 524288 # 2GB TempCacheLimit = 1024M # 1GB LockMemSize = 2M As superserver uses a shared cache, I presumed the total used memory should stay between 3GB and 4GB, but it keeps growing during the day until it reaches the 8GB limit and Firebird shuts down with this message: debian Fri May 18 10:45:35 2018 Shutting down the server with 150 active connection(s) to 2 database(s), 0 active service(s) I am checking the active transactions during the day, and altought there are some old (2h to 3h) active transactions, I don't that an old active transaction should cause this, but I am reporting anyway, maybe it is relevant. Do someone have some advice to what should I do to prevent this from happening? Maybe my understanding about how Firebird uses memory is incorrect, so any advice about how I should calculate the required amount of memory needed is welcome. PS: I have migrated from FB 2.5 recently (previously I did use superclassic mode), and these problems started after the migration. Regards, Fabiano Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen. Please note that this message may contain confidential information. If you have received this message by mistake, please inform the sender of the mistake by sending a reply, then delete the message from your system without making, distributing or retaining any copies of it. Although we believe that the message and any attachments are free from viruses and other errors that might affect the computer or it-system where it is received and read, the recipient opens the message at his or her own risk. We assume no responsibility for any loss or damage arising from the receipt or use of this message.. #yiv8758777567 #yiv8758777567 -- #yiv8758777567ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8758777567 #yiv8758777567ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8758777567 #yiv8758777567ygrp-mkp #yiv8758777567hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8758777567 #yiv8758777567ygrp-mkp #yiv8758777567ads {margin-bottom:10px;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad {padding:0 0;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad p {margin:0;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad a {color:#0000ff;text-decoration:none;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ygrp-lc {font-family:Arial;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ygrp-lc #yiv8758777567hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ygrp-lc .yiv8758777567ad {margin-bottom:10px;padding:0 0;}#yiv8758777567 #yiv8758777567actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8758777567 #yiv8758777567activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8758777567 #yiv8758777567activity span {font-weight:700;}#yiv8758777567 #yiv8758777567activity span:first-child {text-transform:uppercase;}#yiv8758777567 #yiv8758777567activity span a {color:#5085b6;text-decoration:none;}#yiv8758777567 #yiv8758777567activity span span {color:#ff7900;}#yiv8758777567 #yiv8758777567activity span .yiv8758777567underline {text-decoration:underline;}#yiv8758777567 .yiv8758777567attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8758777567 .yiv8758777567attach div a {text-decoration:none;}#yiv8758777567 .yiv8758777567attach img {border:none;padding-right:5px;}#yiv8758777567 .yiv8758777567attach label {display:block;margin-bottom:5px;}#yiv8758777567 .yiv8758777567attach label a {text-decoration:none;}#yiv8758777567 blockquote {margin:0 0 0 4px;}#yiv8758777567 .yiv8758777567bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8758777567 .yiv8758777567bold a {text-decoration:none;}#yiv8758777567 dd.yiv8758777567last p a {font-family:Verdana;font-weight:700;}#yiv8758777567 dd.yiv8758777567last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8758777567 dd.yiv8758777567last p span.yiv8758777567yshortcuts {margin-right:0;}#yiv8758777567 div.yiv8758777567attach-table div div a {text-decoration:none;}#yiv8758777567 div.yiv8758777567attach-table {width:400px;}#yiv8758777567 div.yiv8758777567file-title a, #yiv8758777567 div.yiv8758777567file-title a:active, #yiv8758777567 div.yiv8758777567file-title a:hover, #yiv8758777567 div.yiv8758777567file-title a:visited {text-decoration:none;}#yiv8758777567 div.yiv8758777567photo-title a, #yiv8758777567 div.yiv8758777567photo-title a:active, #yiv8758777567 div.yiv8758777567photo-title a:hover, #yiv8758777567 div.yiv8758777567photo-title a:visited {text-decoration:none;}#yiv8758777567 div#yiv8758777567ygrp-mlmsg #yiv8758777567ygrp-msg p a span.yiv8758777567yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8758777567 .yiv8758777567green {color:#628c2a;}#yiv8758777567 .yiv8758777567MsoNormal {margin:0 0 0 0;}#yiv8758777567 o {font-size:0;}#yiv8758777567 #yiv8758777567photos div {float:left;width:72px;}#yiv8758777567 #yiv8758777567photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8758777567 #yiv8758777567photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8758777567 #yiv8758777567reco-category {font-size:77%;}#yiv8758777567 #yiv8758777567reco-desc {font-size:77%;}#yiv8758777567 .yiv8758777567replbq {margin:4px;}#yiv8758777567 #yiv8758777567ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8758777567 #yiv8758777567ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8758777567 #yiv8758777567ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8758777567 #yiv8758777567ygrp-mlmsg select, #yiv8758777567 input, #yiv8758777567 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8758777567 #yiv8758777567ygrp-mlmsg pre, #yiv8758777567 code {font:115% monospace;}#yiv8758777567 #yiv8758777567ygrp-mlmsg * {line-height:1.22em;}#yiv8758777567 #yiv8758777567ygrp-mlmsg #yiv8758777567logo {padding-bottom:10px;}#yiv8758777567 #yiv8758777567ygrp-msg p a {font-family:Verdana;}#yiv8758777567 #yiv8758777567ygrp-msg p#yiv8758777567attach-count span {color:#1E66AE;font-weight:700;}#yiv8758777567 #yiv8758777567ygrp-reco #yiv8758777567reco-head {color:#ff7900;font-weight:700;}#yiv8758777567 #yiv8758777567ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ov li a {font-size:130%;text-decoration:none;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8758777567 #yiv8758777567ygrp-sponsor #yiv8758777567ov ul {margin:0;padding:0 0 0 8px;}#yiv8758777567 #yiv8758777567ygrp-text {font-family:Georgia;}#yiv8758777567 #yiv8758777567ygrp-text p {margin:0 0 1em 0;}#yiv8758777567 #yiv8758777567ygrp-text tt {font-size:120%;}#yiv8758777567 #yiv8758777567ygrp-vital ul li:last-child {border-right:none !important;}#yiv8758777567