> 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
http://www.upscene.com
http://blog.upscene.com/thomas/

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