Subject | Re: [firebird-support] Re: database became broken for any reasons |
---|---|
Author | Ann Harrison |
Post date | 2014-05-19T16:07:49Z |
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