Subject Problem Firebird 2.1 Superserver
Author Olaf Kluge
Hello,

we have a big problem with firebird 2.1.

Here the gstat-statistics:

Flags 0
Checksum 12345
Generation 23475579
Page size 4096
ODS version 11.1
Oldest Trans. 23475559
Oldest active 23475560
Oldest snapsh. 23475560
Next Transaktion 23475561
Bumped Trans. 1
Sequence No. 0
Next attachm. ID 2063
Implementation ID 16
Shadow Count 0
Page buffers 0
Next header page 0
Database dialect 3
Generation date Feb 5, 2009 15:03:40
Attributes force write

Sweep interval: 20000

It looks fine, but the process fbserver takes hour to hour more RAM from the
system. From yesterday to this day increases the size from 300 Megabyte to
500 Megabyte. The firebird-process-size increases minutely more and more.

The pagefile increases too. The problem is, that firebird jbird driver
returns after one week of running firebird an error message, that firebird
cannot allocate more memory.

The server:

2 Gigabyte RAM,
P4 3000
XP pro

What can be the problem? How can I find and solve it?

Thanks for helping.

Best regards

Olaf Kluge