--- In firebird-support@yahoogroups.com, "Mon Mariola" <label@...> wrote:

>
> >> I have a question about a problem of corruption in a database.
> >>
> >> A database with Firebird 2.1.3 SuperServer in Windows XP with path
> >> 'localhost:c:\Data\database.fdb'
> >>
> >> The client will be working without problems for months.
> >>
> >> Yesterday by mistake change the system date and forward a few days, and
> >> continues to work without noticing the incorrect date.
> >>
> >> Today, he realizes the mistake and put the correct date.
> >>
> >> Try to work and begin the strange errors. Missing records. Now the
> >> database
> >> is corrupt.
> >>
> >> Could it be due to changing the system date?
> >>
> >> Ruben Marti.
> >
> >what kind of corruption?
> >you use gfix for this?
>
> gfix -v -full -user SYSDBA -password masterkey
> localhost:c:\Data\database.fdb
> Summary of validation errors
>
> Number of record level errors : 51776
> Number of data page errors : 1
> Number of database page errors : 9
>
> The Friday backup is correct. I do a backup (gbak -b -g) and restore
> (gbak -c) without problems. The client is working with the backup. So the
> only thing that interests me is to know what happened.
>
> I've checked the Event Viewer from Windows to see any possible disk failure
> or failure of Firebird, but I see nothing strange.
>
> Even now when I had some error with the database has always been a hard
> drive failure.
>
> The client confirms to me that the only thing he has seen strange is that
> the system date was changed. Can this be the reason?
>
> In any case, I will check your computer for any possible viruses or adware.
>
> Thank you.
> Ruben Marti.
>

Look into Firebird.log there are detailed information about corruption
raported by gfix

put here this info

but i can you suggest to change FB2.1.3 to FB2.1.4.408 - this is stable version for me in 24/7 system with high load. With FB2.1.3 i got many corruption in indexes which was fixed.

Karol Bieniaszewski