> This problem cropped up with a user DB. We're running Firebird 2.1,
> with an application written in Delphi, using IBObjects as the interface.
>
> A table in the user's database (it's a temp table that we empty and
> fill at program startup) began throwing an error with the following:
>
> ISC_ERROR_CODE: 335544459
> ISC_ERROR_MESSAGE: "record from transaction 690824 is stuck in limbo".
>
> To try to figure things out, I went into Database Workbench, and got
> the same error message (same transaction # also) any time I tried to
> view the data or run an SQL against the table. I was finally able to
> clear things by dropping and re-creating the table.
>
> NOW ... my REAL question ... if this happens again, is there any
> facility, either within the Firebird native tools, or in DB Workbench,
> that I can use to clear the hung record and restore a table to
> functionality? Preferably without loss of other data...???

I have not encountered this kind of problem before.
You probably should seek for help on the Firebird support forums.

Let us know what you figure out.

Thanks,
Jason Wharton