Re: [Firebird-net-provider] FbDatabaseInfo.ActiveTransactions

[Gerdus v. Z. <ger...@gm...>]

If OldestActiveTransaction does not increase it means there is an old
transaction is still busy and has not commited/rolledback.
You can use the monitoring tables and the transaction ID that
OldestActiveTransaction gives to find out about the transaction that is
stuck.

find the application/connection:
http://www.firebirdfaq.org/faq352/

queries in transaction:
select * from MON$STATEMENTS where MON$TRANSACTION_ID = XX


On Fri, 8 Jun 2018 at 12:30, Norbert Saint Georges <ns...@te...> wrote:

> Gerdus van Zyl a écrit :
> > Normal if it reverts to 0.
> he does not reverts to 0, it keeps an old transaction
>
> > Check that NextTransaction and OldestActiveTransaction do increase after
> > every transaction.
>
> OldestActiveTransaction remain imperturbably always the same.
>
> however, NextTransaction returns the active transaction :-(
>
> thank you very much.
>
> --
> Norbert Saint Georges
> http://tetrasys.fi
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>