Subject | Strange database corruption |
---|---|
Author | Rodrigo Gonçalves |
Post date | 2004-03-01T16:24:35Z |
Hi,
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
disappeared.
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
http://www.goncalves.cjb.net
WinXP / Debian 3 / FreeBSD
"I download therefore I am"
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
disappeared.
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
http://www.goncalves.cjb.net
WinXP / Debian 3 / FreeBSD
"I download therefore I am"