Subject Firebird 1.5.1 sucking all memory
Author jssahdra
Hi,
I have firebird 1.5.1 SS on a custom built linux kernel using Red Hat
9 without NPTL support. When firbird is started, its memory use shown
in the top is very low. But it continously keeps increasing and goes
upto 500MB and even more. Then a point comes, when it stops
responding and need to be restarted.

Here is top command output:

16:13:32 up 2 days, 5:05, 4 users, load average: 0.34, 0.16, 0.13
81 processes: 78 sleeping, 2 running, 1 zombie, 0 stopped
CPU states: 0.9% user 10.0% system 0.0% nice 0.0% iowait
88.9% idle
Mem: 1031904k av, 912432k used, 119472k free, 0k shrd,
101440k buff
184344k active, 693288k inactive
Swap: 2040244k av, 1128k used, 2039116k free
142844k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU
COMMAND
28521 firebird 9 0 585M 585M 2660 S 0.0 58.0 0:23 0
fbserver
3308 root 8 0 28232 27M 2712 S 1.5 2.7 3:17 0
ssg200f



=========================
Here is the header output:


Database header page information:
Flags 0
Checksum 12345
Generation 1162385
Page size 4096
ODS version 10.1
Oldest transaction 1145881
Oldest active 1162375
Oldest snapshot 1162375
Next transaction 1162376
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 28, 2004 10:25:32
Attributes

Variable header data:
*END*