Subject Re: [firebird-support] Re: One table taking a long time to insert/update
Author Alexandre Benson Smith
robertgilland wrote:
>> You need to track down this 'offending' connection/transaction.
>>
>>
>
> have run
>
> gfix.exe -l DBASE.GDB
>
> no limbo transactions were found.
>
> Kind Regards,
>
> Robert.
>

The problem is not limbo transactions. The problem is a long running
transaction.

Limbo transaction occurs on failed two-phase commits.

Long running transaction occurs when will start a transaction and let it
open for a long period.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br