Subject Re: [firebird-support] Finding a deadlocked transaction
Author Thomas Steinmaurer
> Is there some way to list currently active transaction on a given
> database? I keep getting a deadlock at a certain place in my code, and I
> can quite understand *why* I am getting it, but I just can't find which
> transaction is left active - obviously I am overlooking one, but I just
> can't find it, everywhere I look, I see started transactions properly
> committed (or rollbacked). So I thought I would place breakpoints at
> critical moments of my code, listing active transactions at each
> breakpoint, until I located the forgotten transaction.
> I had great hopes in the -list parameter of gfix, but apparently I don't
> have any limbo transactions, even just before I get the deadlock :-(

Use the monitoring table MON$TRANSACTIONS in Firebird 2.1 and up.

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!