Subject Re: [firebird-support] Database corruption, please help
Author Ann W. Harrison
Sudheer Palaparambil wrote:
> Hi,
>
> When I try to back my database, gbak is aborting with the following error
> ..................
> ..................
> writing data for table PURCHASE_DET
> ERROR: internal gds software consistency check (cannot find record
> fragment (248))
> ERROR: gds_$receive failed
> Exiting before completion due to errors
> ERROR: internal gds software consistency check (can't find after bugcheck)
>


Have you tried gbak with the -g switch? That switch disables
garbage collection and, with luck, the lost fragment will be in
a back version, allowing you to get a clean backup. If that
doesn't work, you can do a metadata backup, create an empty
database, and pump data from the broken database into the new
database. A little experimentation will show you where the
corruptions are in the PURCHASE_DET table so you can use an
index lookup to avoid them.


Regards,


Ann