using gfix with -v -f parameters, gfix change the FDB file and give different
result from first time to the second.
-------------------------------------------------------------------------------------------------------------------
Key: CORE-3580
URL: http://tracker.firebirdsql.org/browse/CORE-3580
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.1.3
Environment: /opt/firebird/bin/fb_config --version
2.1.3.18185-0.i686 (Super Server)
cat /proc/version
Linux version 2.6.18-164.el5 (root@localhost.localdomain) (gcc version
4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Fri Dec 3 09:02:01 CST 2010
Reporter: novrain
first time, using gfix to validate the FDB file, the output is( and md5 info):
[root@OMM-32Klinux dbfiles]# md5sum FIREBIRD_CM.FDB
449cb174adc3271d3204e1f35db6c1f7 FIREBIRD_CM.FDB
[root@OMM-32Klinux dbfiles]# /opt/firebird/bin/gfix -v -f FIREBIRD_CM.FDB
-user sysdba -password Comm2011
Summary of validation errors
Number of database page errors : 1
after that, the md5 info of FDB file changed:
[root@OMM-32Klinux dbfiles]# md5sum FIREBIRD_CM.FDB
4f1b8afc0c502bdd931a2e97c62e6bd0 FIREBIRD_CM.FDB
then run gfix again, the errors of FIREBIRD_CM.FDB disappeared:
[root@OMM-32Klinux dbfiles]# /opt/firebird/bin/gfix -v -f FIREBIRD_CM.FDB
-user sysdba -password Comm2011
(no output)
It seems that gfix change the FDB file everytime, but why give the different
result?
By the way, this FDB file was corrupted after some SQL statements were executed.
The FDB file is too big to upload.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
