Subject Re: [firebird-support] Transaction in limbo
Author Mark Rotteveel
On 19-7-2016 09:32, Michael.Vilhelmsen@... [firebird-support] wrote:
> I have a database, which have had to instances where there have been
> Transactions in limbo.
> I know how to fix this.
> I am on the other hand unsure why they appear.
> What can cause this?
> What should/could I check, so I can eliminate this from occuring.
> The database is a Firebird 2.5 running Classic Server.
> We have some 120+ database accross some 10+ servers. This is the only
> one, where this is happening.

Transactions in limbo are prepared but not committed / rolled back. This
can happen when an application uses 2-phase commits but doesn't perform
the second phase (eg because of bugs, failures or crashes). The primary
use case for 2-phase commits is distributed transactions.

Mark Rotteveel