Subject Re: [firebird-support] Error on Gfix
Author Jeferson Sisto

I know Firebird.log and its informations... also, this information are very helpful.

However, always when we detect a corrupt database, our team run a backup/restore. It can be a problem when a database has 20, 30 GB. I read that gfix can fix orphan pages, and our corrupt is about orphan pages. I ran the command gfix -v -full but I don't if it works because ALWAYS returns the result below.

May someone else help us?


Jeferson Sisto
(17) 98827-6685 (Oi - WhatsApp)

2015-09-29 15:43 GMT-03:00 liviuslivius@... [firebird-support] <>:

look into Firebird.log – there are more infos about corruptions recognized by gfix
Karol Bieniaszewski
Sent: Tuesday, September 29, 2015 2:53 PM
Subject: [firebird-support] Error on Gfix

I'm using Firebird 2.5.x and the command gfix -v -full returned:
Summary of validation errors
Number of record level errors : 3
Number of database page errors : 1993
What I have to do in order to fix it, without a backup/restore? I read in "Firebird Documentation" that the command gfix -v -full will fix the orphan pages and record level erros, however, every time when i ran "gfix -v -full" is returned the error above.
Thank you

Jeferson Sisto
+55 (17) 98827-6685 (Oi - WhatsApp)