Subject Re: [firebird-support] Re: Error on Gfix
Author
> ---In firebird-support@yahoogroups.com, <jsistox@...> wrote :
>
> Hi Vlad, thank for your e-mail!
>
> I understood what you said, however, in the link http://www.firebirdsql.org/manual/gfix-dbverify.html I got the following information:
>
>
> Full Validation
>
> By default, validation works at page level. If no need to go deeper and validate at the record level as well, the command to do this is:
>
> gfix -v[alidate] -full database_name
>
> using this option will validate, report and update at both page and record level. Any corrupted structures etc will be fixed.
>
>
> With the text above, I understood that the command gfix -v -full would fix both orphan page and record level error.
>
> Is the text above wrong? 

  Yes, it is poorly worded and thus not correct. Note, validation process was always poorly documented, unfortunately.

A bit more info :
a) orphan record versions not fixed in any case, they just stay in database
b) hard corrupted records could be fixed by marking as "damaged" but only if -mend was specified.
  Such records stay in database and skipped by the engine.
c) orphan pages are fixed if and only if there was no other errors detected and -full was specified

Regards,
Vlad