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