Subject Re: Database Crash
Author Alexander V.Nevsky
--- In ib-support@y..., "erg_sg" <erg_sg@y...> wrote:
> :) I backup the data to csv files and delete the event data every
> night (at a pre-set time). The backed-up data is not used currently.
> The archives are stored to be used to generate device event based
> reports backdated.
>
> So currently its more like backup, delete and go.. rather than
backup
> and restore.

Ergsg, all that you described is very like on malfunction of
garbage collection after mass delete. I can't call it "bug" because I
can't provide reproducable test, but all (about 10 for 6 years of
usage of different versions of IB/FB) corruptions of gdb I encountered
were related with it. Can't speak sure on this mysterious subject but
I have'nt corruptions since start of FB RC2 and more recent builds
usage.
Some shamanism. Try to make backup and delete in exlusive access to
gdb if you can. Try to make one more backup with garbage collection ON
after delete still being exclusive user to be shure it will not be
performed in time of normal functionality of your system.
Knowing you use rather old IB6 and never refresh you database,
perhaps result of gstat -h from corrupted database can be interesting.

Best regards, Alexander V.Nevsky.