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