Subject Strange database corruption
Author Rodrigo Gonçalves

in one of our clients (he was using Interbase 6) there was a database
corruption which made the database "turn back" to the state it was three
days ago - records created, excluded, changed during the three days just

The database itself is working normally, no problems to access, delete
ou insert data.

But when we run gfix, there is a big quantity of corrupted registries in
one of the main tables, which holds patients records. After a
backup/restore, the corruptions are gone but the data is from three days
ago, as I stated earlier.

I've already recommended the update to FB 1.5 but we are a worried with
the fact of the database losing all three-days data (also the server was
powered off during these days, so a long-running transaction is not a
reason for the corruption).

Losing part of the data is understandable, but all data including from
tables not being changed at the problem's moment is strange, very strange...

Rodrigo Gonçalves - Ciências da Computação - UFSC
ICQ UIN: 24006835
WinXP / Debian 3 / FreeBSD

"I download therefore I am"