Subject Re: [firebird-support] Re: database became broken for any reasons
Author Ann Harrison
On Fri, May 16, 2014 at 1:46 AM, markovdmitri@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


I use gfix for define broken DB or not, and I try to do backup and restore.
I may see a lot of diffrent errors, for example orphan pages, corrupted indexes, also orphan backversions, but the last is not a error for database.

Gfix reports problems that are not actually corruption as if they were serious.   Anytime the database shuts down without being closed cleanly, there's a chance that it will contain orphan pages, orphan back versions of records, and index entries that don't correspond to a record.  The first two problems represent lost space.  All three can be fixed by a backup/restore cycle with gbak.   Firebird's index handling code will generally ignore incorrect index entries.

Problems reported by gbak - either on backup or restore are likely to be actual corruption. 

Good luck,

Ann