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 <n...@tetrasys.eu> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
