Well finally I "repaired" the database doing the following:

I detected there was one table corrupted and I drop this table.
I did gfix -mend.
I did backup and restore.
I pumped from a backup of yesterday the records of the table I had dropped.
I added manually to the table I had dropped the records of today.

Now I am worry about the following. As I read in http://tracker.firebirdsql.org/browse/CORE-2268, this is a bug of FireBird which affects versions 2.1.1 (and other older versions) and even 2.5 Alpha 1 and it was fix in version 2.5 Beta 2. Then my questions are:

1. What is the specific cause of this corruption? Is something related to something that perhaps I can avoid doing with my databases?
2. May be I can update to 2.5 Beta 2, but it´s a Beta and then I don´t know which other bug it has. Then... what do you suggest?

Thanks in advance

Gustavo

----- Original Message -----
From: Carlos H. Cantu
To: Gustavo
Sent: Wednesday, August 12, 2009 3:14 PM
Subject: Re: [firebird-support] HELP!! Database corrupted


Take a look here: www.ib-aid.com

Or, if you are in Brazil, here:
http://www.firebase.com.br/fb/produtos.php#ibsurgeon

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br

G> Any idea of what can I do to repair the database. Please!!

G> ----- Original Message -----
G> From: Gustavo
G> To: firebird-support@yahoogroups.com
G> Sent: Wednesday, August 12, 2009 1:04 PM
G> Subject: [firebird-support] HELP!! Database corrupted

G> Hello:

G> I use FireBird 2.1.2.18118 and I have a database corrupted. I
G> tried to repair it using gfix -mend or gfix -v -f but in both cases I get the following message:

G> internal gds software consistency check (cannot find tip page (165), file: tra.cpp line 2494)

G> I found in http://tracker.firebirdsql.org/browse/CORE-2268 that
G> this is an error reported recently but it doesn´t say what is the solution.

G> What can I do to repair the database?

G> Gustavo

G> [Non-text portions of this message have been removed]

G>

G> __________ Información de NOD32, revisión 4329 (20090812) __________

G> Este mensaje ha sido analizado con NOD32 antivirus system
G> http://www.nod32.com

G> [Non-text portions of this message have been removed]

G> ------------------------------------

G> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

G> Visit http://www.firebirdsql.org and click the Resources item
G> on the main (top) menu. Try Knowledgebase and FAQ links !

G> Also search the knowledgebases at http://www.ibphoenix.com

G> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
G> Yahoo! Groups Links






__________ Información de NOD32, revisión 4329 (20090812) __________

Este mensaje ha sido analizado con NOD32 antivirus system
http://www.nod32.com


[Non-text portions of this message have been removed]