Subject Damaged table, how to repair it?
Author Zd
Hi!

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).

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.

Any ideas on how to repair my damaged table?

Thanks,
Zd

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