> ---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 
 > 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




  • [firebird-support... Jeferson Sisto jsis...@gmail.com [firebird-support]
    • Re: [firebir... liviusliv...@poczta.onet.pl [firebird-support]
      • Re: [fir... Jeferson Sisto jsis...@gmail.com [firebird-support]
      • RE: [fir... 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
        • Re: ... Jeferson Sisto jsis...@gmail.com [firebird-support]
          • ... 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
          • ... Ann Harrison aharri...@ibphoenix.com [firebird-support]
    • [firebird-su... hv...@users.sourceforge.net [firebird-support]
      • Re: [fir... Jeferson Sisto jsis...@gmail.com [firebird-support]
        • Re: ... hv...@users.sourceforge.net [firebird-support]

Reply via email to