Hi There !

This message is a follow-up so you could know what happens.


Alexandre Benson Smith wrote:

> For the second time I had a corruption with FB, the first one was due to
> a disk failure, this one I had not verified yet, but I suppose due to
> RAM (OS reported problem earlier during the day)
>

In fact there is a bad RAM module on the server, I removed it.

> I have no practical experience with corrupted databases, FB is stable
> enough to does not make me work on this kind of trouble regularly ;)
>
> So I need your advice...
>
> What I did:
>
> 1.) Stop FB service
> 2.) Renamed original database
> 3.) Copy the renamed file to the original name to work on it
> 4.) Tried gbak with -g without success, sorry did not wrote down the
> error, but could do it again if it's needed (I don't think so)
> 5.) gfix -validate
> 6.) gfix -mend
>
> Results from firebird.log:
> cpack-01-s (Server) Tue Jan 6 23:26:53 2009
> Database: /home/bd/odin.fdb
> internal gds software consistency check (wrong record length
> (183), file: vio.cpp line: 1090)
>
>
> cpack-01-s (Server) Tue Jan 6 23:35:31 2009
> Database: /home/bd/odin.fdb
> Index 3 is corrupt on page 61191 level 0. File:
> ../src/jrd/validation.cpp, line: 1549
> in table NOTAFISCALENDERECO (184)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:37:13 2009
> Database: /home/bd/odin.fdb
> Relation has 4 orphan backversions (0 in use) in table CLIENTE (139)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:37:23 2009
> Database: /home/bd/odin.fdb
> Relation has 9 orphan backversions (0 in use) in table LOTE (175)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:37:42 2009
> Database: /home/bd/odin.fdb
> Relation has 3 orphan backversions (0 in use) in table
> NOTAFISCAL (183)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:37:49 2009
> Database: /home/bd/odin.fdb
> Record 663384 is wrong length in table NOTAFISCALITEM (188)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:38:11 2009
> Database: /home/bd/odin.fdb
> Relation has 322 orphan backversions (0 in use) in table
> PEDIDOVENDA (201)
>
> cpack-01-s (Server) Tue Jan 6 23:38:26 2009
> Database: /home/bd/odin.fdb
> Relation has 35 orphan backversions (0 in use) in table
> PEDIDOVENDAITEM (203)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:38:33 2009
> Database: /home/bd/odin.fdb
> Relation has 121 orphan backversions (0 in use) in table PRODUTO
> (207)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:39:01 2009
> Database: /home/bd/odin.fdb
> Record 344286 is wrong length in table SYNC_ACTIONDONE (273)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:39:01 2009
> Database: /home/bd/odin.fdb
> Chain for record 344286 is broken in table SYNC_ACTIONDONE (273)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:39:03 2009
> Database: /home/bd/odin.fdb
> Relation has -1 orphan backversions (1 in use) in table
> SYNC_ACTIONDONE (273)
>
>
>
> cpack-01-s (Server) Tue Jan 6 23:39:03 2009
> Database: /home/bd/odin.fdb
> Page 74700 is an orphan
>
> 7.) Did a back-up using gbak successfully
>
> 8.) Restored to another file, everything was going well, but on the
> index creation phase I got error, looking at firebird.log I got this:
>

estoring this back-up on anoher machine runs perfect well, so my
costumer's data are in place

Could someone explain what the gfix errors above means ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br