Zd wrote:

>
> Somehow I've managed to break one of my DB tables under Firebird 2.1.1.
>
> Here are the symptoms:
> I can select individual records from the table using their id, but I can't do any mass operations on the database. (DELETE FROM, UPDATE OR SELECT * statements)
>
> I'm getting the following error message:
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Internal gds software consistency check (can't continue after bugcheck).

That's a secondary error. check the log, there's an earlier message
that may indicate the nature the problem more clearly.

>
> I've tried to backup the database, and the same error message pops up.
>
> It's a developer database (not a production one) but it'd be good to have my test data back.
>
> To be honest, I have no idea what produced this error. I was messing around writing custom UDFs for the database and deleting some expression indices that used existing udfs, but I'm not sure if that was the cause of the problem or something else.

Nothing you do should corrupt a table, so we need to know what the
original error was.

> Any ideas on how to repair my damaged table?

If you can select ranges of records by id, you can copy them to a
temporary table, delete them, and copy them back. But lets find
the cause of the problem first.


Good luck,

Ann