Subject | db became corrupt - why? |
---|---|
Author | Nick Upson |
Post date | 2010-06-25T07:52:17Z |
Hi, I'm running FirebirdCS-2.1.2.18118-0 or FC8, suddenly yesturday
programs using the database started throwing errors like this one:
(this is from gbak)
internal gds software consistency check (decompression overran buffer
(179), file: sqz.cpp line: 222)
gfix gave
Number of record level errors : 4
Number of data page errors : 1
Number of index page errors : 3
Number of database page errors : 6
I did a backup and restore, which partially failed (fk indexes) which
I was able to correct by restoring with inactive indexes and removing
the data that was causing the problem, then I enabled the indexes.
What I need to understand is what caused this and how to avoid it
happening again. This system had been running for several weeks
without issue.
programs using the database started throwing errors like this one:
(this is from gbak)
internal gds software consistency check (decompression overran buffer
(179), file: sqz.cpp line: 222)
gfix gave
Number of record level errors : 4
Number of data page errors : 1
Number of index page errors : 3
Number of database page errors : 6
I did a backup and restore, which partially failed (fk indexes) which
I was able to correct by restoring with inactive indexes and removing
the data that was causing the problem, then I enabled the indexes.
What I need to understand is what caused this and how to avoid it
happening again. This system had been running for several weeks
without issue.