transaction stuck in limbo

Posted on 2003-03-11
Medium Priority
Last Modified: 2013-12-09

   I've got between 3 and 12 computers ( at different locations ) with the same problem.. :

The computers are runnning Interbase 6 and replication.

Some of the computers are slower than the others, about once a week I get an "Transaction Stuck In Limbo" error message while an updating script is running on the 'master' computer, The error message only occurs on the slave computers which are being replicated to...  and to fix the problem I perform a backup and restore on the 'master' and 'slave' while the replication service has stopped.  

Has anyone got the same problem..  ? Please help guys..
Question by:tonytone1978
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

BAlexandrov earned 210 total points
ID: 8136464
Better ask at borland.public.interbase.replication newsgroup at news://newsgroups.borland.com

Bojidar Alexandrov

Expert Comment

ID: 8158941
Your question is product (IBReplicator?) related, so you should follow Bojidar's suggestions.

Though, just for your information. A transaction gets in limbo if something unpredictable happens during a two-phase commit (usually used in replication, when a transaction spans over two or more databases). So, there went something wrong in your replication process. Either perform a backup and restore or use gfix.exe to commit/rollback a transaction in limbo.

Thomas Steinmaurer

Author Comment

ID: 8221814
I have moved to the firebird database http://firebird.sourceforge.net 
and had no unexplained transaction stuck in limbo problems..

Thanks guys..

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question