Библиотека

Short explanation of gfix.exe output

When gfix.exe finishes it writes a summary of errors (if any) to the standard output (normally to the screen). Here is a short explanation of gfix output:

• Number of record level errors - number of corrupted record found during gfix work. There records are not correct - essentially, lost.
• Number of index page errors - number of index pages in bad indices. When even the only key is incorrect in index, gfix marks whole index as bad, so number of pages usually is high. However, since it does not affect user's data and corrupted indices will be recreated during backup/restore, this can be considered as for your information only.
• Number of transaction page errors - number of transaction pages which were fixed by gfix. Usually if you see this message it means that gfix did its job and now transactions are Ok.
• Number of BLOB errors - number of bad BLOB pages, it indicates number of bad BLOBs
• Number of database page errors - this is the overall number of database pages, which were visited and changed/marked as bad by gfix. Also, this is mostly for your information.

So, gfix output gives you an approximate estimation of problems found in the corrupted Firebird or InterBase database. The good thing about this summary that if gfix is able to print it, it means that database is consistent enough.