Transactions in limbo

From InterBase
Jump to: navigation, search


Option values are Process and Ignore.

To ignore limbo transactions during backup, set the Transactions in Limbo option value to Ignore.

When IBConsole ignores limbo transactions during backup, it ignores all record versions created by any limbo transaction, finds the most recently committed version of a record, and backs up that version.

Limbo transactions are usually caused by the failure of a two-phase commit. They can also exist due to system failure or when a single-database transaction is prepared.

Before backing up a database that contains limbo transactions, it is a good idea to perform transaction recovery, by choosing Database>Maintenance>Transaction Recovery in the Database Maintenance window. Refer to Recovering Transactions for more information.

This function corresponds to the -limbo option of gbak.