Subject Memory consumption or database corruption
Author Aldo Caruso
Hi,
I'm using firebird 2.5 superserver, php5 and apache2 on a Linux server.

I noticed an increase in memory ( 50 MB / day ) in the last months,
that forced me to periodically restart apache server (once every two or
three weeks).

Yesterday, after an apache restart, memory started to increase out
of control in a few minutes, as well as the number of apache processes (
normally 30, yesterday more than 100 ) and the number of firebird
threads ( normally 10, yesterday more than 100 ). Needless to say that
the web page didn't respond.

I tried restarting firebird server, but nothing changed ( memory
and processes started to grow out of control again ).

I took caution measures ( stopped apache, firebird, made a copy of
the database file, etc.)

I stopped apache server, shut down the database, ran "gfix
-validate -full" which threw the error shown below.

Summary of validation errors
Number of record level errors : 1

Also in the /var/log/firebird2.5.log I found the following lines

( when the problem began )

INET/inet_error: read errno = 104

( when doing gfix -validate )

Relation has 2407 orphan backversions (0 in use) in table PROPS (147)

Afterwards I made a back up and restore of the database, no errors
were shown during those processes, and everything went back to normality.

I wonder whether these errors point out some kind of database
corruption and if they are related with the memory consumption symptoms
I described before.

Thanks
Aldo Caruso