Subject Re: [firebird-support] Limbo transaction - How to solve this?
Author Vlad Horsun
> How do i solve this?
> It's happening about once a week, when the link between 3 replicating
> servers goes down.
> The only way i could solve this is backing up and restoring the
> database with the limbo transaction, but it takes more than 1 hour,
> and there are desperated users needing to use the application.
> Is there a way to prevent this from happening?
>
> The hosts names are ok and i can connect to each database alone.
>
> [root@server1 log]# gfix -list kins01
> Transaction 65443 is in limbo.
> Could not reattach to database for transaction 65443.
> Original path: kinsberg.personalsoft.com.br:kins01
> Multidatabase transaction:
> Host Site: server1.thalys-sp.com.br
> Transaction 65443
> is not available.

Does host "server1.thalys-sp.com.br" is available at this time and
does Firebird is running there ?

How do you connect in your application to every participant
database (show every connect string please) ?

Regards,
Vlad