Hi Fabiano!
Perhaps Debian is trying to put in cache your database file and this file cache
is competing for the available memory with the page cache of Firebird.
In Firebird 2.5(unfortunately I don't know Firebird 3) the parameters to
control the comsuption of memory for the file cache are:
FileSystemCacheSizeFileSystemCacheThreshold
On Thursday, May 24, 2018, 8:30:09 AM CDT, Fabiano Bonin
fabiano.bo...@personalsoft.com.br [firebird-support]
<firebird-support@yahoogroups.com> wrote:
Hi, Omacht!
Indeed, it needs a sweep.
There a scheduled script that runs every night to sweep the database, and it
broke with FB3 upgrade.
I fixed the script and it will run this night.
But, do you think the memory exaustion can be related to this issue?
Regards,
Fabiano
2018-05-24 2:47 GMT-03:00 Omacht András aoma...@mve.hu [firebird-support]
<firebird-support@yahoogroups.com>:
Hi Fabiano!
You should run garbage collection (sweep).
Oldest transaction 905
Oldest active 62303005
Oldest snapshot 62303005
Next transaction 62382577
András
OMACHT ANDRÁS
fejlesztési igazgató
[cid:image001.png@01CFE703. C881C660]
Libra Szoftver Zrt.
1113 Budapest, Karolina út 65.
Tel.: +36 1 255 3939
Fax: +36 1 209 1477
http://www.libraszoftver.hu<ht tp://www.libraszoftver.hu/>
From: firebird-support@yahoogroups. com [mailto:firebird-support@
yahoogroups..com]
Sent: Wednesday, May 23, 2018 4:29 PM
To: firebird-support@yahoogroups. com
Subject: Re: [firebird-support] Firebird using all available memory
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
[A képet a feladó eltávolította.]
2018-05-22 18:30 GMT-03:00 'Thomas Kragh-Pedersen (TKG)'
t...@kmd.dk<mailto:t...@kmd.dk> [firebird-support]
<firebird-support@yahoogroups. com<mailto:firebird-support@ yahoogroups.com>>:
Hey Fabiano
Perhaps DefaultDbCachePages is overwritten by database header information.
Gstat -h will tell you that. Look for “Page buffers”
From: firebird-support@yahoogroups. com<mailto:firebird-support@
yahoogroups.com> <firebird-support@yahoogroups. com<mailto:firebird-support@
yahoogroups.com>>
Sent: 18. maj 2018 16:12
To: firebird-support@yahoogroups. com<mailto: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....
__________ Information from ESET Mail Security, version of virus signature
database 17432 (20180523) __________
The message was checked by ESET Mail Security.
http://www.eset.com
[Non-text portions of this message have been removed]
#yiv2857404402 #yiv2857404402 -- #yiv2857404402ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2857404402
#yiv2857404402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2857404402
#yiv2857404402ygrp-mkp #yiv2857404402hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2857404402 #yiv2857404402ygrp-mkp #yiv2857404402ads
{margin-bottom:10px;}#yiv2857404402 #yiv2857404402ygrp-mkp .yiv2857404402ad
{padding:0 0;}#yiv2857404402 #yiv2857404402ygrp-mkp .yiv2857404402ad p
{margin:0;}#yiv2857404402 #yiv2857404402ygrp-mkp .yiv2857404402ad a
{color:#0000ff;text-decoration:none;}#yiv2857404402 #yiv2857404402ygrp-sponsor
#yiv2857404402ygrp-lc {font-family:Arial;}#yiv2857404402
#yiv2857404402ygrp-sponsor #yiv2857404402ygrp-lc #yiv2857404402hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2857404402
#yiv2857404402ygrp-sponsor #yiv2857404402ygrp-lc .yiv2857404402ad
{margin-bottom:10px;padding:0 0;}#yiv2857404402 #yiv2857404402actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2857404402
#yiv2857404402activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2857404402
#yiv2857404402activity span {font-weight:700;}#yiv2857404402
#yiv2857404402activity span:first-child
{text-transform:uppercase;}#yiv2857404402 #yiv2857404402activity span a
{color:#5085b6;text-decoration:none;}#yiv2857404402 #yiv2857404402activity span
span {color:#ff7900;}#yiv2857404402 #yiv2857404402activity span
.yiv2857404402underline {text-decoration:underline;}#yiv2857404402
.yiv2857404402attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2857404402 .yiv2857404402attach div a
{text-decoration:none;}#yiv2857404402 .yiv2857404402attach img
{border:none;padding-right:5px;}#yiv2857404402 .yiv2857404402attach label
{display:block;margin-bottom:5px;}#yiv2857404402 .yiv2857404402attach label a
{text-decoration:none;}#yiv2857404402 blockquote {margin:0 0 0
4px;}#yiv2857404402 .yiv2857404402bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2857404402
.yiv2857404402bold a {text-decoration:none;}#yiv2857404402 dd.yiv2857404402last
p a {font-family:Verdana;font-weight:700;}#yiv2857404402 dd.yiv2857404402last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2857404402
dd.yiv2857404402last p span.yiv2857404402yshortcuts
{margin-right:0;}#yiv2857404402 div.yiv2857404402attach-table div div a
{text-decoration:none;}#yiv2857404402 div.yiv2857404402attach-table
{width:400px;}#yiv2857404402 div.yiv2857404402file-title a, #yiv2857404402
div.yiv2857404402file-title a:active, #yiv2857404402
div.yiv2857404402file-title a:hover, #yiv2857404402 div.yiv2857404402file-title
a:visited {text-decoration:none;}#yiv2857404402 div.yiv2857404402photo-title a,
#yiv2857404402 div.yiv2857404402photo-title a:active, #yiv2857404402
div.yiv2857404402photo-title a:hover, #yiv2857404402
div.yiv2857404402photo-title a:visited {text-decoration:none;}#yiv2857404402
div#yiv2857404402ygrp-mlmsg #yiv2857404402ygrp-msg p a
span.yiv2857404402yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2857404402
.yiv2857404402green {color:#628c2a;}#yiv2857404402 .yiv2857404402MsoNormal
{margin:0 0 0 0;}#yiv2857404402 o {font-size:0;}#yiv2857404402
#yiv2857404402photos div {float:left;width:72px;}#yiv2857404402
#yiv2857404402photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv2857404402
#yiv2857404402photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2857404402
#yiv2857404402reco-category {font-size:77%;}#yiv2857404402
#yiv2857404402reco-desc {font-size:77%;}#yiv2857404402 .yiv2857404402replbq
{margin:4px;}#yiv2857404402 #yiv2857404402ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2857404402 #yiv2857404402ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2857404402
#yiv2857404402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2857404402
#yiv2857404402ygrp-mlmsg select, #yiv2857404402 input, #yiv2857404402 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2857404402
#yiv2857404402ygrp-mlmsg pre, #yiv2857404402 code {font:115%
monospace;}#yiv2857404402 #yiv2857404402ygrp-mlmsg *
{line-height:1.22em;}#yiv2857404402 #yiv2857404402ygrp-mlmsg #yiv2857404402logo
{padding-bottom:10px;}#yiv2857404402 #yiv2857404402ygrp-msg p a
{font-family:Verdana;}#yiv2857404402 #yiv2857404402ygrp-msg
p#yiv2857404402attach-count span {color:#1E66AE;font-weight:700;}#yiv2857404402
#yiv2857404402ygrp-reco #yiv2857404402reco-head
{color:#ff7900;font-weight:700;}#yiv2857404402 #yiv2857404402ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2857404402 #yiv2857404402ygrp-sponsor
#yiv2857404402ov li a {font-size:130%;text-decoration:none;}#yiv2857404402
#yiv2857404402ygrp-sponsor #yiv2857404402ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2857404402
#yiv2857404402ygrp-sponsor #yiv2857404402ov ul {margin:0;padding:0 0 0
8px;}#yiv2857404402 #yiv2857404402ygrp-text
{font-family:Georgia;}#yiv2857404402 #yiv2857404402ygrp-text p {margin:0 0 1em
0;}#yiv2857404402 #yiv2857404402ygrp-text tt {font-size:120%;}#yiv2857404402
#yiv2857404402ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2857404402
