Subject Re: [firebird-support] md5 hash change everytime I run gfix -v -f. No errors.
Author Mark Rotteveel
On 1-5-2014 20:15, Jan Nowa wrote:
> The title is basically self-explanatory. Use of "gfix -validate -full"
> returns no errors, yet changes *somthing* in the database file, because
> the hash is different. Why is that?

From
http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html
:

When a database is validated the following checks are made and corrected
by default:

* Orphan pages are returned to free space. This updates the database.
* Pages that have been misallocated are reported.
* Corrupt data structures are reported.

Orphan pages are not considered errors and are - AFAIK - not reported.

If you just want to check and not modify the database, add the -n (or
-no_update) option.

Mark
--
Mark Rotteveel