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

Something went wrong in a distributed transaction spanning multiple databases. Prominent examples are e.g. replication tools.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.