Subject | Record In Limbo ... what's it mean? |
---|---|
Author | olgreyfox15 |
Post date | 2009-03-03T00:15:39Z |
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...???
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...???