Note: I aplogize if this message arrives later again to the forum but I am having problems with my e-mail and so now I am sending this from the web.
-------------

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

--- In firebird-support@yahoogroups.com, "Gustavo" <gusm@...> wrote:
>
> Any idea of what can I do to repair the database. Please!!
>
> ----- Original Message -----
> From: Gustavo
> To: firebird-support@yahoogroups.com
> Sent: Wednesday, August 12, 2009 1:04 PM
> Subject: [firebird-support] HELP!! Database corrupted
>
>
> Hello:
>
> I use FireBird 2.1.2.18118 and I have a database corrupted. I tried to repair it using gfix -mend or gfix -v -f but in both cases I get the following message:
>
> internal gds software consistency check (cannot find tip page (165), file: tra.cpp line 2494)
>
> I found in http://tracker.firebirdsql.org/browse/CORE-2268 that this is an error reported recently but it doesn´t say what is the solution.
>
> What can I do to repair the database?
>
> Gustavo
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> __________ 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]
>