Subject Re: [firebird-support] Re: Corruption in database
Author Mon Mariola
>> 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.