Subject Re: [firebird-support] Corruption of firebird db
Author The Wogster
jstahl80 wrote:
> I have had 3 times now database corruption of an FB1.5 database
> after these happenings:
>
> 1. The disk containing the DB is running low on free space.
> 2. It seems to me, that as a result of this, the machine runs out of
> RAM. Note however, that the swap file is on a different disk.
> 3. After a normal shutdown of the machine, the database file is
> corrupt having page pointers pointing behind the EOF.
>
> Is such corruption known problem?
>
> Here is an excerpt of the firebird log. There are no write errors
> for the db file.
>

I think your running out of disk space, and some application is using
some temporary files, so that after the restart it appears that your
just low on disk space. With databases, doesn't really matter which
database software your using, if you run out of disk space, then all
bets are off.

It's time to clean out your hard drive, toss away all that stuff you
haven't used in a while. Most hard drives, get a real collection of
rubbish on them, old applications that are not used anymore, DLLs that
were used for applications that are no longer installed. The biggest
collector of crap is your browser, it's not uncommon to find that there
are thousands of cookies, from sites you visited once, that decide that
the 450 cookies it leaves behind, have a lifespan of 65,536 years.

You should always maintain between 10 - 20% free space on your hard
disk, if it's too hard to clean up, drives are cheap.

W