At 10:45 AM 7/10/2004 +0000, you wrote:

>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.

[snip]

>=========================
>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*

Find and fix the application that is holding read-write transactions open
and you are likely to solve all your problems. A gap of nearly 16.500
between oldest transaction and oldest active [transaction] represents a
very huge transaction account in memory, as well as a large amount of
uncollected garbage on disk.

Also check that you don't have your page cache set to a size that is larger
than is justified by the amount of RAM you have available.

,/heLen