Subject Re: [firebird-support] Kill a specify transaction
Author Thomas Steinmaurer

> Can I kill an active transaction(concurrency)?
> If yes, How Can I do it?
> I started an operation between two Databases on Internet(TCP/IP)...
> When the link is broken, the transaction is active don't
> stop... and when the connection is turning back and I try to run the
> process again, the operation Return "deadlock"...

As far as I understand, you have a distributed transaction across two
databases, which somehow fails, e.g. due to a faulty network etc.

If so, then your distributed transaction is stuck in "limbo". Use gfix
to tell the server what you want to do (commit vs. rollback) with the
stuck transaction. Look here:

With regards,

Thomas Steinmaurer
Upscene Productions

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!